nerdexam
Microsoft

70-448 · Question #212

You develop a SQL Server 2008 Reporting Services (SSRS) instance of a report model. The organization requires that users of a report be able to dynamically change the server environment. You need to…

The correct answer is F. Create a dynamic data source from a dataset that includes a list of distinct servers. See the full explanation below for the reasoning.

Question

You develop a SQL Server 2008 Reporting Services (SSRS) instance of a report model. The organization requires that users of a report be able to dynamically change the server environment. You need to create a parameter that gives the user the option to choose the server before report execution. What should you do?

Options

  • ACreate a distinct dataset that includes all possible values and attach it to the parameter.
  • BCreate a dynamic dataset that utilizes the WHERE clause to filter by the parameter.
  • CCreate a dynamic data source from a dataset by using the IN operator.
  • DConfigure the Internal Visibility option for the parameter.
  • EChange the dataset from a shared dataset to an embedded dataset in the report.
  • FCreate a dynamic data source from a dataset that includes a list of distinct servers.
  • GCreate a dynamic dataset that includes a list of the different users.
  • HConfigure the Hidden Visibility property.

How the community answered

(38 responses)
  • A
    8% (3)
  • D
    3% (1)
  • E
    16% (6)
  • F
    71% (27)
  • H
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 70-448 Practice