Microsoft Exam Questions

You need to increase query and dimension processing performance

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.