PrepAway - Latest Free Exam Questions & Answers

You need to ensure that only the aggregations are updated

You maintain a SQL Server 2008 Analysis Services (SSAS) instance.
You plan to process the aggregations of a cube by using an XML for Analysts (XMLA) script.
You need to ensure that only the aggregations are updated.
What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Execute a processStructure command.

B.
Execute a processUpdate command.

C.
Execute a processIndex command.

D.
Execute a processData command.

Explanation:
B: processUpdate only supported for dimensions
C: processIndex updates indexes and aggregations
D: processData processes data only without updating aggregations or indexes


Leave a Reply