70-432 · Question #111
You are the administrator of a SQL Server 2008 instance which uses mixed authentication mode. The instance runs on a computer which has Windows Server 2003 installed. You have to make sure that the…
The correct answer is C. You should modify all logins by using the ALTER LOGIN ... CHECK_POLICY = ON E. You should create a policy by using Policy-Based Management. See the full explanation below for the reasoning.
Question
You are the administrator of a SQL Server 2008 instance which uses mixed authentication mode. The instance runs on a computer which has Windows Server 2003 installed. You have to make sure that the SQL Server 2008 authenticated logins follow the same password complexity rules that are enforced by Windows Server 2003. Besides this, you must make sure that the password complexity rules continue to be enforced. Which action should you perform to achieve this goal? (choose more than one)
Options
- AYou should create an SQL Server Agent job.
- BYou should modify all logins by using the ALTER LOGIN ... HASHED statement.
- CYou should modify all logins by using the ALTER LOGIN ... CHECK_POLICY = ON
- DYou should modify all logins by using the ALTER LOGIN ... CHECK_EXPIRATION = ON
- EYou should create a policy by using Policy-Based Management.
How the community answered
(32 responses)- A9% (3)
- B3% (1)
- C72% (23)
- D16% (5)
Community Discussion
No community discussion yet for this question.