Microsoft
70-448 · Question #293
70-448 Question #293: Real Exam Question with Answer & Explanation
Sign in or unlock 70-448 to reveal the answer and full explanation for question #293. The question stem and answer options stay visible for context.
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.
Unlock 70-448 to see the answer
You've previewed enough free 70-448 questions. Unlock 70-448 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.