You create several reports for the ABC.com with SQL Server Report Services (SSRS) 2008. The
sales manager wants to look at the QtrSales report from last year to review sales figures from the
previous year. The QtrSales report has been modified several times and the data source has
changed.
How should you retrieve the information from last year’s QtrSales report using the least amount of
administrative effort?
A.
Isolate a single snapshot from report history of the QtrSales report from last year. Run the
QtrSales report.
B.
Change the data source to the previous year’s report configuration. Run the QtrSales report
with the data parameters for last year.
C.
Modify the QtrSales report to the same report configuration as last year. Run the QtrSales
report.
D.
Create a separate report database. Restore an archived backup of the QtrSales report from
last year. Change the data source to the previous configuration. Run the QtrSales report with the
data parameters for last year.