Microsoft
70-473 · Question #36
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 th
The correct answer is B. Add HelpDesk to the new role. D. Grant VIEW SERVER STATE to the new role. F. Create a server role.. https://msdn.microsoft.com/en-us/library/ms188754.aspx
Design and implement data security
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.
How the community answered
(36 responses)- A6% (2)
- B61% (22)
- C11% (4)
- E22% (8)
Explanation
Topics
#SQL Server security#Server roles#Permissions#Dynamic Management Views
Community Discussion
No community discussion yet for this question.