70-448 · Question #54
You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server 2008. Now you are employed in a company named NaproStar which uses SQL…
The correct answer is D. First, from the dataset queries remove the filters. Then filter the datasets by using the parameters. 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) by using SQL Server 2008. Now you are employed in a company named NaproStar which uses SQL Server 2008. You work as the technical support. There is a SQL Server 2008 Reporting Services (SSRS) instance. Now you are in charge of a report in this instance. Query parameters are contained in this report which queries the data source at random. Users are allowed to filter the contents of the report according to the query parameters. You perform this configuration on the report, making it be rendered from a report execution snapshot. You must make sure that parameters can still be used to filter the report after the configuration. So what action should you perform?
Options
- AA default value should be added to all parameters
- BFirst, the queries should be moved to the stored procedures.
- CThe datasets should be modified to use the Table query type
- DFirst, from the dataset queries remove the filters. Then filter the datasets by using the parameters.
How the community answered
(38 responses)- A3% (1)
- B11% (4)
- C5% (2)
- D82% (31)
Community Discussion
No community discussion yet for this question.