You administer a SQL Server 2008 instance. You plan to deploy multiple databases to the
instance. You design the security policy for the instance. A stored procedure verifies the
partition compression settings on each database deployed to the instance. You plan to use
a policy to execute the stored procedure. You need to ensure that the policy is enforced by
using Policy-Based Management Framework. What should you do?

A.
Grant EXECUTE permissions on the stored procedure to the
##MS_PolicyEventProcessingLogin## login.

B.
Enable the nested triggers server configuration option.

C.
Grant EXECUTE permissions on the stored procedure to the SQLAgent service account.

D.
Grant EXECUTE permissions on the stored procedure to the
##MS_PolicyTsqlExecutionLogin## login.