nerdexam
Microsoft

70-448 · Question #6

You maintain a report in a SQL Server 2008 Reporting Services (SSRS) instance. The report contains query parameters that allow users to filter the contents of the report. The report queries the data…

The correct answer is C. Remove the filters from the dataset queries. See the full explanation below for the reasoning.

Question

You maintain a report in a SQL Server 2008 Reporting Services (SSRS) instance. The report contains query parameters that allow users to filter the contents of the report. The report queries the data source randomly. You configure the report to be rendered from a report execution snapshot. You need to ensure that users can continue to use parameters to filter the report. What should you do?

Options

  • AAdd a default value to all parameters.
  • BModify the datasets to use the Table query type.
  • CRemove the filters from the dataset queries.
  • DMove the queries to the stored procedures.

How the community answered

(28 responses)
  • A
    7% (2)
  • B
    4% (1)
  • C
    86% (24)
  • D
    4% (1)

Community Discussion

No community discussion yet for this question.

Full 70-448 Practice