Microsoft
70-473 · Question #106
70-473 Question #106: Real Exam Question with Answer & Explanation
Sign in or unlock 70-473 to reveal the answer and full explanation for question #106. The question stem and answer options stay visible for context.
Question
You have a server named SQL1 that has Microsoft SQL Server 2016 installed. SQL1 contains a database named DB1. You need to ensure that a user named User1 can query dynamic management views to monitor DB1. The solution must minimize the number of permissions assigned to User1. You create a login for User1. Which permission should you grant to User1?
Options
- AALTER TRACE
- BVIEW SERVER STATE
- CVIEW DATABASE STATE
- DVIEW ANY DATABASE
Unlock 70-473 to see the answer
You've previewed enough free 70-473 questions. Unlock 70-473 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.