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 geography dimension, all non-key attributes relate directly to the key attribute.
The underlying data of the 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 geography dimension, define appropriate attribute relationships.

B.
For the geography dimension, set the ProcessingMode property to LazyAggregations.

C.
For the geography dimension, set the ProcessingPriority property to 1.

D.
For the dimension attributes of the geography dimension, set the GroupingBehavior property to
EncourageGrouping.

One Comment on “You need to increase query and dimension processing per…


Leave a Reply