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
Explanation:
To query a dynamic management view or function requires SELECT permission on object and VIEW SERVER
STATE or VIEW DATABASE STATE permission.Reference: Dynamic Management Views and Functions (Transact-SQL)
https://msdn.microsoft.com/en-us/library/ms188754.aspx