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.
Explanation: