You work as the network database administrator at MiracleInfocom .com. The MiracleInfocom .com network consists of a single Active Directory domain named MiracleInfocom .com. All servers on the MiracleInfocom .com network run Windows Server 2003 and all client computers run Windows XP Professional. The MiracleInfocom .com network contains a Microsoft SQL Server 2005 database server named MiracleInfocom -DB01 which you administer. The MiracleInfocom .com network uses a database called Bill EmployeeData which is used to create monthly reports. All of the network employees have a SQL Server login to access the server. A new MiracleInfocom .com security policy requires that all the SQL logins use the same complexity and password expiration policies used by Microsoft Windows Server 2003. The networks Windows Server 2003 computers are configured to require complex passwords and periodic password changes. The security policy additionally states that all users must change their password the first time when login onto MiracleInfocom -DB01. MiracleInfocom .com has recently hired a new employee who requires access to the database server using the account named Rory A. You are required to create a SQL Server login account for the user that adheres to all the appropriate requirements. What should you do?
A. You should execute CREATE LOGIN RoryA WITH PASSWORD = Moles4M4 MUST_CHANGE CHECK_EXPIRATION = ON, CHECK_POLICY = ON
B. You should execute CREATE LOGIN RoryA WITH PASSWORD = Moles4M4 MUST CHANGE CHECK_POLICY = OFF
C. You should execute CREATE LOGIN RoryA WITH PASSWORD = Moles4M4 MUST Change CHECK_POLICY = ON
D. You should execute CREATE LOGIN RoryA WITH PASSWORD = Moles4M4 CHECK_EXPIRATION = OFF, CHECK_POLICY = OFF
Answer:A
You work as the network database administrator at MiracleInfocom .com. The MiracleInfocom .com network consists of a single Active Directory domain named MiracleInfocom .com. All servers on the MiracleInfocom .com network run Windows Server 2003 and all client computers run Windows XP Professional. The MiracleInfocom .com network contains a Microsoft SQL Server 2005 database server named MiracleInfocom -DB01 which you administer. The MiracleInfocom .com network uses a database called Bill EmployeeData which is used to create monthly reports. All of the network employees have a SQL Server login to access the server. A new MiracleInfocom .com security policy requires that all the SQL logins use the same complexity and password expiration policies used by Microsoft Windows Server 2003. The networks Windows Server 2003 computers are configured to require complex passwords and periodic password changes. The security policy additionally states that all users must change their password the first time when login onto MiracleInfocom -DB01. MiracleInfocom .com has recently hired a new employee who requires access to the database server using the account named Rory A. You are required to create a SQL Server login account for the user that adheres to all the appropriate requirements. What should you do?
A. You should execute CREATE LOGIN RoryA WITH PASSWORD = Moles4M4 MUST_CHANGE CHECK_EXPIRATION = ON, CHECK_POLICY = ON B. You should execute CREATE LOGIN RoryA WITH PASSWORD = Moles4M4 MUST CHANGE CHECK_POLICY = OFF C. You should execute CREATE LOGIN RoryA WITH PASSWORD = Moles4M4 MUST Change CHECK_POLICY = ON D. You should execute CREATE LOGIN RoryA WITH PASSWORD = Moles4M4 CHECK_EXPIRATION = OFF, CHECK_POLICY = OFF