You need to modify the report to help search for multiple Category values by using minimum amount of development effort

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?

A.
Implement the query in a view.

B.
Implement the query in a table-valued user-defined function.

C.
Modify the query to use the IN operator instead of the = operator.

D.
Implement the query in a stored procedure that uses dynamic SQL to execute the query.