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?

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?

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.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Marchello

Marchello

A.
For the dimension attributes of the geography dimension, define appropriate attribute relationships.