You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance. The a SQL Server 2008 instance is used on a Windows Server 2000 server and uses
the mixed authentication mode. Management wants you to ensure the following:
•SQL Server 2008 logins must have the same password complexity rules which are enforced by
Windows Server 2000 for authentication.
•Full compliance of all users with regarding to adhering to the password complexity rules.
What actions should you take?? (Each correct option is part of the answer. Choose TWO)
A.
You should consider using the ALTER LOGIN … CHECK_EXPIRATION = OFF statement to
change the entire login of all users.
B.
You should consider using the ALTER LOGIN … CHECK_EXPIRATION = ON statement to
change the entire login of all users.
C.
You should consider using the command ALTER LOGIN … NO CREDENTIAL.
D.
You should consider using the command ALTER LOGIN … UNLOCK.
E.
You should consider using the command ALTER LOGIN … ADD CREDENTIAL.
F.
You should consider using the command ALTER LOGIN … DROP CREDENTIAL.
G.
You should consider using the ALTER LOGIN … CHECK_POLICY = ON statement to change
the entire login of all users.
H.
You should consider using the ALTER LOGIN … CHECK_POLICY = OFF statement to change
the entire login of all users.
I.
Create a policy using Policy-Based Management that matches the requirements of this scenario.
J.
You should consider using the ALTER LOGIN … CREDENTIAL = statement to change the
entire login of all users.
Explanation:
ALTER LOGIN
CHECK_POLICY = { ON | OFF }
Applies only to SQL Server logins. Specifies that the Windows password policies of the computer
on which SQL Server is running should be enforced on this login. The default value is ON.
Policy-Based Management is a system for managing one or more instances of SQL Server 2008.
When SQL Server policy administrators use Policy-Based Management, they use SQL Server
Management Studio to create policies to manage entities on the server, such as the instance of
SQL Server, databases, or other SQL Server objects.