nerdexam
Microsoft

70-466 · Question #92

Drag and drop question. You need to optimize the Regions dimension. How should you configure the attribute relationships? (To answer, drag the appropriate attribute from the list of attributes to the

The correct hierarchy relationship is as follows: 'Area Key' is related to 'State', 'State' is related to 'Country', and 'Country' is related to 'Region'. This forms a chain: Area Key -> State -> Country -> Region.

Build an analysis services database

Question

Drag and drop question. You need to optimize the Regions dimension. How should you configure the attribute relationships? (To answer, drag the appropriate attribute from the list of attributes to the correct location in the hierarchy relationship. Use only attributes that apply.)

Exhibit

70-466 question #92 exhibit

Explanation

The correct hierarchy relationship is as follows: 'Area Key' is related to 'State', 'State' is related to 'Country', and 'Country' is related to 'Region'. This forms a chain: Area Key -> State -> Country -> Region.

Topics

#attribute relationships#dimension optimization#hierarchy#Regions dimension

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice