You are a database administrator for AIOTestKing.com. The company uses a SQL Server 2005 computer that runs Reporting Services. The server runs reports that include only data from the previous days sales. You discover that an OLTP database application runs slowly when reports are run during business hours and that reports sometimes time out.
You need to correct the problem and prevent it from recurring. What should you do?
A.
Configure the reports to run under the Snapshot isolation level.
B.
Store the report definitions on a separate server.
C.
Increase the size of the ReportServerTempDB database.
D.
Configure the reports to use report snapshots. Schedule the report snapshots to run after business hours.
Explanation:
A report snapshot is a report that contains layout information and query results that were retrieved at a specific point in time. Unlike on-demand reports, which get up-to-date query results when you select the report, report snapshots are processed on a schedule and then saved to a report server. When you select a report snapshot for viewing, the report server retrieves the stored report from the report server database and shows the data and layout that were current for the report at the time the snapshot was created.