Microsoft
70-448 · Question #120
70-448 Question #120: Real Exam Question with Answer & Explanation
Sign in or unlock 70-448 to reveal the answer and full explanation for question #120. The question stem and answer options stay visible for context.
Question
You are developing a SQL Server 2008 Reporting Services (SSRS) report for Company.com. The source of the SSRS report data is a Transact-SQL stored procedure. The procedure does not have any input parameters and returns all records in a set of tables. Three other applications that run on Microsoft SQL Server also use the stored procedure. You need to limit the amount of data that is displayed on the report without affecting any other applications that use the stored procedure. What should you do?
Options
- AYou should run the Database Engine Tuning Advisor tool in the database.
- BYou should create a dataset filter and include the appropriate limiting expression.
- CYou should create a Report Parameter dialog box and include the appropriate limiting expression.
- DYou should add an expression to the Visibility property and include the appropriate limiting expression.
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.