Questions derived from the 70-445 – TS: Microsoft SQL Server 2005 Business Intelligence – Implementation and Maintenance Microsoft Self-Test Software Practice Test.
Objective: Managing SSRS
SubObjective: Manage SSRS reports by using Report Manager
Item Number: 70-422.214.171.124
Single Answer, Multiple Choice
You are a database administrator for your company. The regional managers and administrators of the company have access to the national sales reports of the company. You need to develop the regional sales reports based on the national sales reports for the regional sales team, which does not have access to the national sales reports. The management and administration of these reports should be easy.
What should you do to generate the regional sales reports?
- Create reports for the region.
- Create linked reports for the region.
- Add a region group in national sales reports.
- Modify the national sales reports with an extra parameter named Region.
B. Create linked reports for the region.
To generate regional reports from national reports, you should create linked reports for the region. Linked reports are created based on existing reports and can use different properties from the existing master report. Linked reports are not created on multiple locations and therefore, are easy to manage and administer. In this scenario, a regional linked report can be generated from the national report by restricting the access to regional sales data. Because the report being created is a linked report, it will not be created on multiple locations. To create a linked report, you can use the CreateLinkedReports button on the general Properties page.
You should not create new reports for the region because the reports will be deployed on multiple locations. It will become difficult to manage and maintain the reports in multiple locations. According to the scenario, the management and administration of these reports should be easy. Therefore, you should create linked reports instead of new reports for the region.
The options stating that you should add a region group in the national sales reports and modify the national sales reports with an extra parameter named Region are incorrect. The regional sales team does not have access to the national sales team reports and will not be able to view the reports. Therefore, making changes to the national sales reports will not help you achieve the objective.
Adding, Modifying and Deleting Linked Reports