70-466 · Question #129
You need to configure the dataset for the ManufacturingIssues report. The solution must meet the technical requirements and the reporting requirements. What should you do?
The correct answer is B. Add a query to retrieve the necessary data from the database. Configure the dataset to use query parameters. Configure the dataset to use query parameters. SSRS datasets should use query parameters to allow reports to dynamically filter data based on user-selected report parameters, meeting both flexibility and performance requirements.
Question
Options
- AConfigure the dataset to use a stored procedure. Add the necessary parameters for the stored procedure.
- BAdd a query to retrieve the necessary data from the database. Configure the dataset to use query parameters. Configure the dataset to use query parameters.
- CAdd a query to retrieve the necessary data from the database. Configure the dataset to use query parameters. Configure the dataset to use a table.
- DConfigure the dataset to use a table. Ensure that the database has a table that contains the necessary information.
How the community answered
(36 responses)- A17% (6)
- B72% (26)
- C3% (1)
- D8% (3)
Why each option
SSRS datasets should use query parameters to allow reports to dynamically filter data based on user-selected report parameters, meeting both flexibility and performance requirements.
Using a stored procedure adds unnecessary complexity and limits the ability to modify query logic within the report designer without changing the database object.
Adding a SQL query to the dataset and configuring query parameters links report-level parameters to the WHERE clause of the query, so only the relevant rows are retrieved from the database. This satisfies technical requirements by reducing data transfer and satisfies reporting requirements by enabling user-driven filtering. Query parameters are the standard SSRS pattern for parameterized data retrieval.
Configuring the dataset to use a table instead of a parameterized query returns all rows and pushes filtering to the report layer, degrading performance and not meeting the requirement for parameter-driven data retrieval.
Binding the dataset directly to a table with no query parameters returns all data and provides no dynamic filtering capability, failing to meet the stated reporting requirements.
Concept tested: Configuring SSRS dataset query parameters for dynamic filtering
Source: https://learn.microsoft.com/en-us/sql/reporting-services/report-data/report-parameters-report-builder-and-report-designer
Topics
Community Discussion
No community discussion yet for this question.