Microsoft
70-467 · Question #142
70-467 Question #142: Real Exam Question with Answer & Explanation
The correct answer is D: Display only the children of the current hierarchy level and drill through to the selected. For a six-level hierarchy with 1 million members, drill-through navigation that fetches only the children of the currently selected level minimizes processing time and simplifies report design.
Question
You are designing a complex report that displays sales metrics for a customer hierarchy. The customer hierarchy has six levels and contains approximately 1 million members. You have the following requirements: - Allow users to easily display and navigate data. - Minimize report processing time. - Simplify the report design and maintenance processes. You need to design a report that meets the requirements. How should you design the report? (More than one answer choice may achieve the goal. Select the BEST answer.)
Options
- ARetrieve all customers and use drilldown groupings to show or hide hierarchy levels.
- BAdd a report part for each hierarchy level.
- CAdd a subreport for each hierarchy level.
- DDisplay only the children of the current hierarchy level and drill through to the selected
Explanation
For a six-level hierarchy with 1 million members, drill-through navigation that fetches only the children of the currently selected level minimizes processing time and simplifies report design.
Common mistakes.
- A. Retrieving all 1 million customers in a single query and using drilldown groupings to hide rows still loads the entire dataset into memory, significantly increasing processing time and violating the performance requirement.
- B. Adding a separate report part for each of the six hierarchy levels increases design complexity and maintenance effort, violating the requirement to simplify the report design and maintenance processes.
- C. Using a subreport for each hierarchy level causes separate server-side processing requests per level, introducing significant performance overhead and increasing design and maintenance complexity.
Concept tested. SSRS drill-through navigation for large hierarchical datasets
Community Discussion
No community discussion yet for this question.