You need to implement the company security policy that is stored in the RestrictedLogonHours table.What should you do?

70-432 Sample Question: 7

Question: 7


You administer a SQL Server 2008 instance. The security policy permits members of a Windows group named CONTOSO\Sales to establish new connections to the SQL Server instance only during business horns between 07:00 horns and 19:00 hours. Other users may connect to the SQL Server instance any time.

You write the following Transact-SQL statements.

You need to implement the company security policy that is stored in the
RestrictedLogonHours table.What should you do?

A. Create a logon trigger that denies the connection to the CONTOSO\Sales group during
non-business hours.
B. Create a SQL Server Agent job that causes the SQL Server Windows service to pause
during non-business hours.
C. Create a SQL Server Agent job that periodically looks for and kills connections made by the CONTOSO\Sales group during non-business hours.
D. Create a policy that uses a condition based on the Server Audit facet. Use the policy to deny the connection to the CONTOSO\Sales group during non-business hours.

Answer: A