nerdexam
Microsoft

70-466 · Question #48

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 dimensio

The correct answer is B. For the dimension attributes of the geography dimension, define appropriate attribute relationships.. Defining attribute relationships in an SSAS dimension allows the engine to optimize aggregation storage and reduce processing time by understanding the natural hierarchy between attributes.

Build an analysis services database

Question

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?

Exhibit

70-466 question #48 exhibit

Options

  • AFor the geography dimension, set the ProcessingMode property to LazyAggregations
  • BFor the dimension attributes of the geography dimension, define appropriate attribute relationships.
  • CFor the geography dimension, set the ProcessingPriority property to 1.
  • DFor the dimension attributes of the geography dimension, set the GroupingBehavior property to EncourageGrouping.

How the community answered

(40 responses)
  • A
    3% (1)
  • B
    75% (30)
  • C
    15% (6)
  • D
    8% (3)

Why each option

Defining attribute relationships in an SSAS dimension allows the engine to optimize aggregation storage and reduce processing time by understanding the natural hierarchy between attributes.

AFor the geography dimension, set the ProcessingMode property to LazyAggregations

LazyAggregations defers aggregation building to query time rather than processing time, which can actually hurt query performance under load.

BFor the dimension attributes of the geography dimension, define appropriate attribute relationships.Correct

When attribute relationships are explicitly defined, SSAS knows that certain attributes functionally depend on others, allowing it to avoid storing redundant aggregations and to optimize query plans. This directly improves both dimension processing speed (fewer aggregations to compute) and query performance (more efficient aggregation navigation). Because the underlying data already supports these relationships, defining them is a low-risk, high-reward change.

CFor the geography dimension, set the ProcessingPriority property to 1.

ProcessingPriority controls the order in which objects are processed when processing multiple objects simultaneously, not the speed or efficiency of processing.

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

GroupingBehavior is a hint for client tools about how to group dimension members and has no impact on server-side query or processing performance.

Concept tested: SSAS attribute relationships for performance optimization

Source: https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/attribute-relationships-define

Topics

#attribute relationships#dimension processing#query performance#geography dimension

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice