PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

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


Leave a Reply