What should you do to ensure the following?

You work as a database administrator at Domain.com. Domain.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 authenticated logins has the same password complexity rules which are enforced by Windows Server 2000.
* Full compliance of all users with regarding to adhering to the password complexity rules.

What should you do? (Choose TWO)

You work as a database administrator at Domain.com. Domain.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 authenticated logins has the same password complexity rules which are enforced by Windows Server 2000.
* Full compliance of all users with regarding to adhering to the password complexity rules.

What should you do? (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_POLICY = ON statement to change the entire login of all users.

C.
You should consider using the ALTER LOGIN … CHECK_POLICY = OFF statement to change the entire login of all users.

D.
You should consider developing an SQL Server Agent job which implements to raise an alert, if triggered by a violation by any user.



Leave a Reply 0

Your email address will not be published. Required fields are marked *