Microsoft
70-448 · Question #153
70-448 Question #153: Real Exam Question with Answer & Explanation
Sign in or unlock 70-448 to reveal the answer and full explanation for question #153. The question stem and answer options stay visible for context.
Question
You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server 2008. Now you are employed in a company which is named NaproStar and work as a developer of a SQL Server 2008 Reporting Services (SSRS) report for the company. A parameter named Kind is contained in your developed report and you use it to filter a list of Sales. Besides, the list uses a dataset, which includes the queries of SELECT p.SalesID, p.Place, p.ListName, FROM SalesAmount.Sales AS p WHERE p.Kind = @Kind. To meet the business requirements, the report parameter is modified to allow multiple values. Now you are asked to modify the report to help search for multiple Kind values and minimize the development effort. What action should be performed to achieve the goal above?
Options
- AThe query should be modified by using the IN operator instead of the = operator
- BThe query should be implemented in a stored procedure that uses dynamic SQL for execution
- CThe query should be modified in a table-valued user-defined function.
- DThe query should be implemented in a view
- EThe query should be implemented in a table-valued user-defined function.
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.