Microsoft
70-465 · Question #154
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…
The correct answer is B. VIEW SERVER STATE. To query a dynamic management view or function requires SELECT permission on object and VIEW SERVER STATE or VIEW DATABASE STATE permission. https://msdn.microsoft.com/en-us/library/ms188754.aspx
Submitted by jian89· Mar 5, 2026Design database security solutions
Question
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?
Options
- AVIEW ANY DEFINITION
- BVIEW SERVER STATE
- CVIEW DEFINITION
- DCONTROL SERVER
How the community answered
(57 responses)- A2% (1)
- B91% (52)
- C2% (1)
- D5% (3)
Explanation
To query a dynamic management view or function requires SELECT permission on object and VIEW SERVER STATE or VIEW DATABASE STATE permission. https://msdn.microsoft.com/en-us/library/ms188754.aspx
Topics
#Dynamic Management Views (DMVs)#VIEW SERVER STATE#SQL Server permissions#least privilege
Community Discussion
No community discussion yet for this question.