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.

A. Add HelpDesk to the db_owner role for all of the databases.
B. Add HelpDesk to the new role.
C. Grant VIEW ANY DATABASE to the new role.
D. Grant VIEW SERVER STATE to the newrole.
E. Create a database role.
F. Create a server role.
  Discussion forum


Leave an answer