Microsoft Exam 70-467 Topic 18 Question 2 Discussion

Actual exam question for Microsoft's 70-467 exam

Question #: 2
Topic #: 18

An existing cube dimension that has 30 attribute hierarchies is performing very poorly. You have the following requirements:

Implement drill-down browsing.

Reduce the number of attribute hierarchies but ensure that the information contained within them is available to users on demand.

Optimize performance.

You need to redesign the cube dimension to meet the requirements.

What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

Aset the AggregateFunction property to Sum on all measures. Use the SCOPE statement in a Multidimensional Expressions (MDX) calculation to tune the aggregation types.

BSet the AttributeHierarchyOptimizedState property to FullyOptimized on the attribute hierarchies.

CCreate user-defined hierarchies. For the attributes sourced by the levels of the user-defined hierarchies, set the RelationshipType property to Rigid. Run incremental processing.

DRemove as many attribute hierarchies as possible from the dimension. Reintroduce the information in the attribute hierarchies as properties. Implement natural hierarchies and set the AttributeHierarchyVisible property to False for attributes used as levels in the natural hierarchies.

Show Suggested Answer

Suggested Answer: D

by Raul at May 03, 2022, 08:36 PM

Limited Time Offer

25%

Off

Get Premium 70-467 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!