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)- A8% (3)
- D3% (1)
- E16% (6)
- F71% (27)
- H3% (1)
Community Discussion
No community discussion yet for this question.