Which permissions should you assign to Dba1?

You are using dynamic management views to monitor an SQL Server server named SQL1. A database administrator named Dba1 must monitor the health of SQL1.
You need to ensure that Dba1 can access dynamic management views for SQL1.
The solution must use the principle of least privilege. Which permissions should you assign to Dba1?
A. VIEW ANY DEFINITION
B. VIEW SERVER STATE
C. VIEW DEFINITION
D. CONTROL SERVER

microsoft-exams

Leave a Reply

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


The reCAPTCHA verification period has expired. Please reload the page.