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.
A.
Enable versioning.
B.
Enable caching.
C.
Enable report history.
D.
Create snapshots.
E.
Implement pagination.
what is the meaning of versioning?
and how it helps to improve rendering performance?
Correct answer is pagination and snapshot so D and E
https://msdn.microsoft.com/en-us/library/ms159638.aspx
Agree
You are correct. D and E
Article explains it perfectly!
Pagination and snapshot
Caching improves the performance https://msdn.microsoft.com/en-us/library/ms155927(v=sql.120).aspx while scheduled snapshots prevent reports run on demand.
B and E could be correct too?
Caching indeed improves performance, but the question specificially asks about the rendering of the report, imo that makes D (snapshot) and E (pagination) the 2 most likely candidates. I’d do caching too but the way the question is stated and limited to 2 answers makes it D & E.