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.

There are two types of dynamic management views and functions:

• Server-scoped dynamic management views and functions. These require VIEW SERVER STATE permission on the server.
• Database-scoped dynamic management views and functions. These require VIEW DATABASE STATE permission on the database.

References: https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/system-dynamic-management-views