PrepAway - Latest Free Exam Questions & Answers

What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to develop SQL Server 2008 Reporting Services (SSRS) reports. Several reports will contain identical data regions.
You need to minimize the amount of maintenance when changes are made to the data regions.
What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Grant the Create Linked Reports role to all users.

B.
Create each data region as a report. Embed the reports by using the subreport control.

C.
Create a report template for each data region. Use the report template to create each report.

D.
Create a shared data source in the SSRS project. Use the new shared data source for all reports.

Explanation:
Tip: "amount of maintenance" = "subreport control"


Leave a Reply