Microsoft
70-432 · Question #111
70-432 Question #111: Real Exam Question with Answer & Explanation
Sign in or unlock 70-432 to reveal the answer and full explanation for question #111. The question stem and answer options stay visible for context.
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.
Unlock 70-432 to see the answer
You've previewed enough free 70-432 questions. Unlock 70-432 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.