70-448 · Question #153
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…
The correct answer is A. The query should be modified by using the IN operator instead of the = operator. See the full explanation below for the reasoning.
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.
How the community answered
(60 responses)- A83% (50)
- B7% (4)
- C5% (3)
- D2% (1)
- E3% (2)
Community Discussion
No community discussion yet for this question.