Microsoft
70-473 · Question #36
70-473 Question #36: Real Exam Question with Answer & Explanation
Sign in or unlock 70-473 to reveal the answer and full explanation for question #36. The question stem and answer options stay visible for context.
Question
You have a Microsoft SQL Server instance on a Microsoft Azure virtual machine. The members of an Active Directory group named HelpDesk can log in to the SQL Server instance. You need to ensure that the members of HelpDesk can query dynamic management views and gather performance metrics from the SQL Server instance. Which three actions should you perform? Each correct answer presents part of the solution.
Options
- AAdd HelpDesk to the db_owner role for all of the databases.
- BAdd HelpDesk to the new role.
- CGrant VIEW ANY DATABASE to the new role.
- DGrant VIEW SERVER STATE to the new role.
- ECreate a database role.
- FCreate a server role.
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.