nerdexam
Microsoft

70-448 · Question #159

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 B. You should have the default value configured for the parameter based on an expression. 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) solution for the company. Then you add a report with a query parameter and a single dataset to the solution. Now you get an order from your company CIO, according to his requirement, you need to make sure that the report can be executed with no user interaction from the Report Manager. What action should you perform to achieve this goal?

Options

  • AFrom the dataset, you should have available values configured for the parameter.
  • BYou should have the default value configured for the parameter based on an expression
  • CYou should have the parameter data configured to refresh whenever the parameter is refreshed.
  • DYou should have the default value configured for the report.
  • EYou should use snapshot execution to configure the report.

How the community answered

(24 responses)
  • A
    13% (3)
  • B
    71% (17)
  • C
    4% (1)
  • D
    8% (2)
  • E
    4% (1)

Community Discussion

No community discussion yet for this question.

Full 70-448 Practice