You need to implement the company security policy that is stored in the RestrictedLogonHours table

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?

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:



Leave a Reply 0

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