You are a database administrator for AIOTestKing.com. A user named AIOTestKing belongs to the Windows SalesManagers group. AIOTestKing needs a Reporting Services report to display annual sales information by territory. A user named Joe reports to AIOTestKing and belongs to the Windows Sales group. He needs a report that is limited to his sales territory, but still displays the same detailed sales data that is on AIOTestKing’s report. You need to design a secure solution that meets the reporting needs of the users and that consumes the minimal amount of server resources. What should you do?
A.
Design a report for AIOTestKing that includes two data regions. One data region is used for summary sales data. The other data region is used for the detailed sales data for each sales representative. Then, design a report for Joe that displays the detailed sales data.
B.
Design two reports for AIOTestKing. One report includes the territory information, and one report includes the detailed sales data. Then, design a report for Joe that displays the detailed sales data for his territories.
C.
Design a report for AIOTestKing that includes the territory information. Then, design a report for Joe that includes detailed sales data for his territories. Finally, configure Jack Bill report so that it includes the data in Joes report.
D.
Design a parameterized report for AIOTestKing that includes all territory information.
Then, design a linked report for Joe that links to AIOTestKings report.
Explanation:
Parameterized filters allow different partitions of data to be sent to different Subscribers without requiring multiple publications to be created (parameterized filters were referred to as dynamic filters in previous versions of SQL Server).A partition is simply a subset of the rows in a table;depending on the settings chosen when creating a parameterized filter, each row in a published table can belong to one partition only (which produces nonoverlapping partitions) or to two or more partitions (which produces overlapping partitions). A linked report is a report with settings and properties of its own, but links to the report definition of another report. Linked reports are useful when you have a base report that you want to vary for specifie groups or users; for example,regional report that returns different data based on a regional code. A linked report is typically created from a parameterized report when you want to vary and then save different parameter values with each report instance.