70-467 · Question #82
You need to implement the aggregation designs for the cube. What should you do?
The correct answer is B. Use the Aggregation Design Wizard. The Aggregation Design Wizard in SSAS is the tool used to define and optimize aggregations for a cube partition based on performance goals.
Question
You need to implement the aggregation designs for the cube. What should you do?
Options
- AUse the Usage-Based Optimization Wizard.
- BUse the Aggregation Design Wizard.
- CPartition the cube by month.
- DImplement cache warming in SSAS via an SSIS package.
How the community answered
(29 responses)- A7% (2)
- B90% (26)
- C3% (1)
Why each option
The Aggregation Design Wizard in SSAS is the tool used to define and optimize aggregations for a cube partition based on performance goals.
The Usage-Based Optimization Wizard relies on existing query log data to refine aggregations after the cube is in use; it cannot be used for initial aggregation design without prior usage history.
The Aggregation Design Wizard allows you to specify a performance gain target or storage limit and then automatically designs aggregations for cube partitions. It works at design time to pre-compute summaries that speed up MDX query response, which is the correct tool for implementing aggregation designs.
Partitioning the cube by month is a data management and scalability strategy, not a method for designing aggregations.
Cache warming via SSIS pre-loads the SSAS cache with query results but does not define or create aggregation designs for the cube.
Concept tested: SSAS aggregation design wizard for cube optimization
Source: https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/designing-aggregations-analysis-services
Topics
Community Discussion
No community discussion yet for this question.