nerdexam
Microsoft

70-448 · Question #293

You develop a SQL Server 2008 Reporting Services (SSRS) report. The report contains a parameter named Category that is used to filter a list of products. The list uses a dataset that contains the…

The correct answer is C. Modify the query to use the IN operator instead of the = operator. See the full explanation below for the reasoning.

Question

You develop a SQL Server 2008 Reporting Services (SSRS) report. The report contains a parameter named Category that is used to filter a list of products. The list uses a dataset that contains the following query:

You modify the report parameter to allow multiple values. You need to modify the report to help search for multiple Category values by using minimum amount of development effort. What should you do?

Options

  • AImplement the query in a view.
  • BImplement the query in a table-valued user-defined function.
  • CModify the query to use the IN operator instead of the = operator.
  • DImplement the query in a stored procedure that uses dynamic SQL to execute the query.

How the community answered

(60 responses)
  • A
    8% (5)
  • B
    17% (10)
  • C
    72% (43)
  • D
    3% (2)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-448 Practice