PrepAway - Latest Free Exam Questions & Answers

You need to increase query and dimension processing per…

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?

PrepAway - Latest Free Exam Questions & Answers

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.


Leave a Reply