nerdexam
Microsoft

70-466 · Question #141

You have a SQL Server Reporting Services (SSRS) instance. The instance has a report that displays 3 million records. Users report that they experience performance issues when they use the report. You

The correct answer is A. Enable versioning. B. Enable caching.. Enabling caching in SSRS stores a processed copy of the report so subsequent requests are served without re-executing the query against all 3 million records, and versioning supports maintaining multiple cached instances.

Implement a reporting services solution

Question

You have a SQL Server Reporting Services (SSRS) instance. The instance has a report that displays 3 million records. Users report that they experience performance issues when they use the report. You need to ensure that the report renders as quickly as possible. Which two actions should you perform? Each correct answer presents part of the solution.

Options

  • AEnable versioning.
  • BEnable caching.
  • CEnable report history.
  • DCreate snapshots.
  • EImplement pagination.

How the community answered

(41 responses)
  • A
    73% (30)
  • C
    2% (1)
  • D
    7% (3)
  • E
    17% (7)

Why each option

Enabling caching in SSRS stores a processed copy of the report so subsequent requests are served without re-executing the query against all 3 million records, and versioning supports maintaining multiple cached instances.

AEnable versioning.Correct

Enabling versioning in SSRS allows the report server to maintain multiple cached or snapshot versions, supporting cache refresh workflows that prevent repeated full-dataset query execution and improve throughput for concurrent users.

BEnable caching.Correct

Report caching stores the processed report output in the report server database so that subsequent user requests within the cache expiration window are served directly from cache, bypassing the expensive query that retrieves 3 million records.

CEnable report history.

Report history retains snapshot copies for historical audit and comparison purposes but does not reduce rendering time for current on-demand report requests.

DCreate snapshots.

Snapshots pre-execute the report on a schedule, but without caching they do not prevent per-user re-rendering overhead; caching is required to fully eliminate repeated execution costs.

EImplement pagination.

Pagination improves the user experience by displaying data in pages but does not reduce the time required to execute the underlying query or process all 3 million records.

Concept tested: SSRS report caching and versioning for performance

Source: https://learn.microsoft.com/en-us/sql/reporting-services/report-server/caching-reports-ssrs

Topics

#SSRS performance#report caching#report snapshots#pagination

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-466 Practice