Microsoft Exam Questions

You need to ensure that the policy is configured to meet the security requirement

You administer a SQL Server 2008 instance. Your company security policy is designed to
prevent changes to the server to the server configuration. You plan to use Policy-Based
Management Framework to implement the security policy. You need to ensure that the
policy is configured to meet the security requirement. What should you do?

A.
Disable the nested triggers server configuration.

B.
Use a domain account for the SQLAgent service.

C.
Use the Local Service account for the SQLAgent service.

D.
Enable the nested triggers server configuration option.

Explanation: