Microsoft
70-448 · Question #54
70-448 Question #54: Real Exam Question with Answer & Explanation
Sign in or unlock 70-448 to reveal the answer and full explanation for question #54. 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) 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.
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.