PrepAway - Latest Free Exam Questions & Answers

How can you increase the processing performance of the dimension?

You have been hired as a Business Intelligence (BI) developer at ABC.com. The company uses a
Microsoft SQL Server 2012 infrastructure.
A junior developer has created a multidimensional Microsoft SQL Server Analysis Services
project. The processing performance of the dimensions in the project needs to be optimized to
improve performance.
All dimension attributes in one of the dimensions directly relate to the key attribute. Relationships
between the non-key attributes are supported by the data in the dimension.
How can you increase the processing performance of the dimension?

PrepAway - Latest Free Exam Questions & Answers

A.
By modifying the default processing priority of the dimension.

B.
By configuring EncourageGrouping as the setting for the GroupingBehavior property.

C.
By defining attribute relationships within the dimension.

D.
By configuring DiscourageGrouping as the setting for the GroupingBehavior property.

Explanation:


Leave a Reply