单项选择题
You are the administrator of a Microsoft Windows Server 2003 computer named SQL1. SQL1 runs SQL Server 2005 and is a member of a Microsoft Active Directory domain named Contoso.com. The domain is configured with all of the default settings. Several members of the information security team have requested access to SQL1. The information security team uses the Microsoft Windows XP Professional， Linux， and Macintosh operating systems to perform vulnerability assessments. The information security team members ask you to create two new logon accounts for their use. They would like the logon accounts to have the following user names and passwords： User name\password for first account： pentest\P@ssw0rdUser name\password for second account： hacktest\password You need to provide the information security team with the requested access to SQL1.
Which Transact-SQL script should you use？（）
A.CREATE LOGIN pentestWITH PASSWORD = 'P@ssw0rd' CREATE LOGIN hacktestWITH PASSWORD = 'password'
B.CREATE LOGIN pentestWITH PASSWORD = 'P@ssw0rd' CREATE LOGIN hacktestWITH PASSWORD = 'password',CHECK_POLICY = OFF
C.CREATE LOGIN pentestWITH PASSWORD = 'P@ssw0rd' CREATE LOGIN hacktestWITH PASSWORD = 'password'[HASHED]
D.CREATE LOGIN [CONTOSO\pentest]FROM WINDOWS CREATE LOGIN [CONTOSO\hacktest]FROM WINDOWS
相关考题
-
单项选择题
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. -
单项选择题
YouaretheadministratorofaSQLServer2005computernamedSQL1.SQL1isamemberofaMicrosoftActiveDirectorydomain.Youdonothaveanyrightsorprivilegestoperformdomainadministration.However，youhavebeengrantedmembershipinthelocalAdministratorsgrouponSQL1.YouperformmostofthemanagementofSQL1fromyouradministrativeworkstation.However，forsecurityreasons，youwanttotrackallattemptsforinteractivelogonsandnetworkconnectionstoSQL1.Whatshouldyoudo？（）
A.Create a Group Policy object （GPO） that is configured for success and failure auditing of the Audit account logon events setting. Ask the domain administrator to link the GPO to the object containing SQL1.
B.Configure the SQL Server service on SQL1 to audit all successful and failed logon attempts.
C.Edit the local security policy of SQL1. Then， configure success and failure auditing on the Audit logon events setting.
D.Run the SQL Server Profiler and use a standard default template. -
单项选择题
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？（）
A.Use the SQL Server 2005 Management Studio to review the permissions of the default database objects.
B.Query the sys.server_permissions table on Server1.
C.Execute the sp_helplogins system stored procedure for each of the default users that the MedDATA application creates.
D.Query the sys.database_permissions and sys.database_principals tables in the MedDB database.
