Microsoft
70-467 · Question #30
70-467 Question #30: Real Exam Question with Answer & Explanation
The correct answer is D: Remove as many attribute hierarchies as possible from the dimension.. Removing unnecessary attribute hierarchies from a dimension directly reduces the aggregation structures SSAS must build and maintain, improving both processing time and query performance.
Question
An existing cube dimension that has 30 attribute hierarchies is performing very poorly. You have the following requirements: - Implement drill-down browsing. - Reduce the number of attribute hierarchies but ensure that the information contained within them is available to users on demand. - Optimize performance. You need to redesign the cube dimension to meet the requirements. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
Options
- Aset the AggregateFunction property to Sum on all measures. Use the SCOPE statement in a
- BSet the AttributeHierarchyOptimizedState property to FullyOptimized on the attribute
- CCreate user-defined hierarchies. For the attributes sourced by the levels of the user-defined
- DRemove as many attribute hierarchies as possible from the dimension.
Explanation
Removing unnecessary attribute hierarchies from a dimension directly reduces the aggregation structures SSAS must build and maintain, improving both processing time and query performance.
Common mistakes.
- A. Setting AggregateFunction to Sum and using SCOPE statements controls how measures roll up, not the number or cost of attribute hierarchies, and does not address dimension browsing performance.
- B. Setting AttributeHierarchyOptimizedState to FullyOptimized instructs SSAS to build more complete aggregation structures, which increases rather than decreases processing overhead and storage.
- C. Creating user-defined hierarchies alone does not reduce attribute hierarchy count unless the source attribute hierarchies are also disabled; without disabling them, all original structures remain and performance does not improve.
Concept tested. SSAS dimension attribute hierarchy reduction for performance optimization
Community Discussion
No community discussion yet for this question.