YouaretheadministratorofaSQLServer2005computernamedSQL1.Youcreateasecuritytemplatethatdisablesunnecessaryservices.ThetemplateisappropriateonlyforSQL1.YouneedtoensurethatthesecuritytemplateisappliedtoSQL1.Yoursolutionmustensurethatthetemplateautomaticallyoverridesanymanualconfigurationchangesmadebyotheradministratorswithinanhour.Whatshouldyoudo？（）A.Use the SQL Server Surface Area Configuration tool to import the security template.B.Use the Local Security Policy editor to import the security template into the Local Security Policy object.C.Configure Task Scheduler to import the security template by using Secedit.exe. Configure the task to run every half hour.D.Configure Task Scheduler to run the Microsoft Baseline Security Analyzer tool every half hour.

单项选择题

You are the administrator of a SQL Server 2005 computer named SQL1. You create a security template that disables unnecessary services. The template is appropriate only for SQL1. You need to ensure that the security template is applied to SQL1. Your solution must ensure that the template automatically overrides any manual configuration changes made by other administrators within an hour. What should you do？（）

A.Use the SQL Server Surface Area Configuration tool to import the security template.
B.Use the Local Security Policy editor to import the security template into the Local Security Policy object.
C.Configure Task Scheduler to import the security template by using Secedit.exe. Configure the task to run every half hour.
D.Configure Task Scheduler to run the Microsoft Baseline Security Analyzer tool every half hour.

相关考题

单项选择题 YouaretheadministratorofaSQLServer2005computernamedSQL1.SQL1isamemberofaMicrosoftActiveDirectorydomain.Youdonothaveanyrightsorprivilegestoperformdomainadministration.However，youhavebeengrantedmembershipinthelocalAdministratorsgrouponSQL1.YouperformmostofthemanagementofSQL1fromyouradministrativeworkstation.However，forsecurityreasons，youwanttotrackallattemptsforinteractivelogonsandnetworkconnectionstoSQL1.Whatshouldyoudo？（）

单项选择题 You are the administrator of a Microsoft Windows Server 2003 computer named Server1. SQL Server 2005 is installed on Server1 to host a database named MedDB. The MedDB database serves as the backend database for a new client/server application named MedDATA. Installation of the MedDATA application creates the database schema， application roles， and administrative accounts. It also sets all of the default permissions. You need to establish a permissions baseline for all objects in the MedDB database. What should you do？（）

备案号：湘ICP备14005140号-3

经营许可证号：湘B2-20140064

MCITP(70-444)