What should you do?

You create a Management Data Warehouse instance and enable data collection. You have an Active Directory Domain………. DS) group named SQLDevelopers.

Members of the SQLDevelopers group must be able to run reports that show information about Microsoft SQL Server…….. SQL Server activity.

You need to grant the developers permissions to run the reports by using the principle of least privilege.

What should you do?
A . In the msdb database, add SQLDevelopers to the mdwdmin role.
B . In the msdb database, add SQLDevelopers to the mdw_reader role.
C . In the MDW database, add SQLDevelopers to the db_datareader role.
D . In the msdb database, add SQLDevelopers to the mdw_admin role.

View Answer

Answer: C

Explanation:

Members of the mdw_reader role have Read access to the management data warehouse. Because the purpose of this role is to support troubleshooting by providing access to historical data, members of this role cannot view other elements of the management data warehouse schema.

Note: The Server Activity data collection set collects information about resources used by the SQL Server instance (processor, memory, disk I/O, and network usage), SQL Server instance activity (batch requests, logouts, SQL compilations and recompilations, transactions, user connections, and logins) and waits

Incorrect: Members of the mdw_admin role have Read, Write, Update, and Delete access to the management data warehouse.

Members of this role can perform the following operations: