Microsoft
70-450 · Question #14
70-450 Question #14: Real Exam Question with Answer & Explanation
Sign in or unlock 70-450 to reveal the answer and full explanation for question #14. The question stem and answer options stay visible for context.
Question
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?
Options
- AAdd the developers to the sysadmin server role.
- BGrant the ALTER TRACE permission to the developers.
- CAdd the developers to the PolicyAdministratorRole role in the MSDB database.
- DGrant the EXECUTE permission on the sys.sp_syspolicy_execute_policy stored procedure
Unlock 70-450 to see the answer
You've previewed enough free 70-450 questions. Unlock 70-450 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.