You are conducting a design review of a multidimensional project.
In the Customer Geography dimension, all non-key attributes relate directly to the key
attribute.
The underlying data of the Customer Geography dimension supports relationships between
attributes.
You need to increase query and dimension processing performance.
What should you do?
A.
For the dimension attributes of the Customer Geography dimension, define appropriate
attribute relationships.
B.
For the dimension attributes of the Customer Geography dimension, set the
GroupingBehavior property to EncourageGrouping.
C.
For the Customer Geography dimension, set the Processing Mode property to
LazyAggregations.
D.
For the Customer Geography dimension, set the ProcessingPriority property to 1.
Answer:
A.- For the dimension attributes of the Customer Geography dimension, define appropriate attribute relationships.
Answer is A
A
Yes, A:
https://www.mssqltips.com/sqlservertip/2567/ssas–best-practices-and-performance-optimization–part-3-of-4/
Specify the appropriate attribute relationship type
By default an attribute relationship is considered Flexible, but wherever applicable make it Rigid for better performance. If you make it rigid, SSAS doesn’t bother updating members of a dimension on subsequent processing and hence improves the performance. Please make sure you are changing relationships to rigid only in cases where it does not change or else you may get exceptions during processing.
A.
For the dimension attributes of the Customer Geography dimension, define appropriate
attribute relationships.