You administer a SQL Server 2008 infrastructure. Developers in your company have rights
to author policies. A test server is used to develop and test the policies. The Policy-Based
Management feature generates SQL Server Agent alerts when a policy is violated. The
developers are able to create and modify policies, but are unable to test policy violation
alerts. You need to grant the necessary permission to the developers to test the policies.
You also need to comply with the least privilege principle when you grant the permission.
What should you do?
A.
Grant the ALTER TRACE permission to the developers.
B.
Add the developers to the PolicyAdministratorRole role in the MSDB database.
C.
Add the developers to the sysadmin server role.
D.
Grant the EXECUTE permission on the sys.sp_syspolicy_execute_policy stored
procedure to the developers.