You work as a database administrator at You are responsible for managing a SQL Server 2008 database server named ABC-DB01. You are in the process of creating a complex report on ABC-DB01 using SQL Server 2008 Reporting Services (SSRS). You receive an instruction to have the report cached for the first twenty minutes upon commencing the request. You then decide to configure ABC-DB01 to comply with the stipulation. Which of the following actions should you take?

1)The Full cache option should be configured.

2)You should configure the data source as a parameter from the data table.

3)You should configure the Default cache option.

4)Report execution caching should be configured.

  • : 301
  • : 13
    Previous Next

    Report execution caching should be configured.

    Suggest other answer
    Login to Discuss/suggest the answer...

  • Exam: 70-448 MS SQL Server 2008, Business Intelligence

    Recommended Learning for you

    Subscribe here for free mock test on IAS PCS SSC and other competitive exam. Signup here to get SSC CGL Solution and main exam study material