nerdexam
Microsoft

70-448 · Question #332

You create a SQL Server 2008 Reporting Services (SSRS) report that contains a dataset. The dataset retrieves data by executing a stored procedure. The report contains a table and a matrix that use…

The correct answer is C. Add a filter to the table. See the full explanation below for the reasoning.

Question

You create a SQL Server 2008 Reporting Services (SSRS) report that contains a dataset. The dataset retrieves data by executing a stored procedure. The report contains a table and a matrix that use the dataset. You need to limit data that is displayed in the table while ensuring that the matrix is unaffected. What should you do?

Options

  • AAdd a filter to the dataset.
  • BAdd a filter to the matrix.
  • CAdd a filter to the table.
  • DAdd a parameter to the stored procedure that filters the result set.

How the community answered

(52 responses)
  • A
    8% (4)
  • B
    6% (3)
  • C
    85% (44)
  • D
    2% (1)

Community Discussion

No community discussion yet for this question.

Full 70-448 Practice