Microsoft
70-448 · Question #210
You are a SQL Server 2008 Reporting Services (SSRS) developer. You develop a report with two parameters named Region and City in that order. When the Region parameter is selected, the City parameter…
The correct answer is B. Create a dynamic dataset that utilizes the WHERE clause to filter by the parameter. See the full explanation below for the reasoning.
Question
You are a SQL Server 2008 Reporting Services (SSRS) developer. You develop a report with two parameters named Region and City in that order. When the Region parameter is selected, the City parameter should be filtered by the Region selected. You need to enable this functionality. 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
(30 responses)- A3% (1)
- B83% (25)
- E10% (3)
- H3% (1)
Community Discussion
No community discussion yet for this question.