You are a database administrator for AIOTestKing.com. A database named OLTP_Report makes data available to Reporting Services reports. You use Reporting Services to create a report named SalesDeviation, which displays sales goals and sales representatives’ actual sales. You need to manage report subscriptions. All sales representatives located in the Windows Sales group who do not meet sales goals must automatically receive a SalesDeviation report every Monday morning. What should you do?
A.
Create two new roles: GoalMet for sales representatives who have met their goals, and GoalMissed for sales representatives who have missed their goals. Then, assign the Windows Sales group to the GoalMissed role to allow those sales representatives to run reports.
B.
Create a data-driven subscription to the SalesDeviation report. Then, for the subscription’s recipients, specify a Transact-SQL query that returns the names of sales representatives who have fallen short of their goals.
C.
Create a data-driven subscription to the SalesDeviation report. Then, assign the Windows Sales group to the predefined Browser role. Finally, specify the Windows Sales group in the parameter of the subscription.
D.
Assign the Windows Sales group to the predefined Browser role. Then, ask all sales representatives in the Windows Sales group to create user-defined subscriptions to the SalesDeviation report by using My Subscriptions.