MicrosoftMicrosoft
70-465 · Question #154
70-465 Question #154: Real Exam Question with Answer & Explanation
Sign in or unlock 70-465 to reveal the answer and full explanation for question #154. The question stem and answer options stay visible for context.
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
Unlock 70-465 to see the answer
You've previewed enough free 70-465 questions. Unlock 70-465 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Dynamic Management Views (DMVs)#VIEW SERVER STATE#SQL Server permissions#least privilege