70-466 · Question #48
You are conducting a design review of a multidimensional project. In the geography dimension, all non-key attributes relate directly to the key attribute. The underlying data of the geography dimensio
The correct answer is B. For the dimension attributes of the geography dimension, define appropriate attribute relationships.. Defining attribute relationships in an SSAS dimension allows the engine to optimize aggregation storage and reduce processing time by understanding the natural hierarchy between attributes.
Question
Exhibit
Options
- AFor the geography dimension, set the ProcessingMode property to LazyAggregations
- BFor the dimension attributes of the geography dimension, define appropriate attribute relationships.
- CFor the geography dimension, set the ProcessingPriority property to 1.
- DFor the dimension attributes of the geography dimension, set the GroupingBehavior property to EncourageGrouping.
How the community answered
(40 responses)- A3% (1)
- B75% (30)
- C15% (6)
- D8% (3)
Why each option
Defining attribute relationships in an SSAS dimension allows the engine to optimize aggregation storage and reduce processing time by understanding the natural hierarchy between attributes.
LazyAggregations defers aggregation building to query time rather than processing time, which can actually hurt query performance under load.
When attribute relationships are explicitly defined, SSAS knows that certain attributes functionally depend on others, allowing it to avoid storing redundant aggregations and to optimize query plans. This directly improves both dimension processing speed (fewer aggregations to compute) and query performance (more efficient aggregation navigation). Because the underlying data already supports these relationships, defining them is a low-risk, high-reward change.
ProcessingPriority controls the order in which objects are processed when processing multiple objects simultaneously, not the speed or efficiency of processing.
GroupingBehavior is a hint for client tools about how to group dimension members and has no impact on server-side query or processing performance.
Concept tested: SSAS attribute relationships for performance optimization
Source: https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/attribute-relationships-define
Topics
Community Discussion
No community discussion yet for this question.
