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 ne

ed 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

An

Explanation:

To query a dynamic management view or function requires SELECT permission on object and VIEW SERVER STATE or VIEW DATABASE STATE permission.

References: https://msdn.microsoft.com/en-us/library/ms188754.aspx