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…

The correct answer is A. Execute a processStructure command. B: processUpdate only supported for dimensions C: processIndex updates indexes and aggregations D: processData processes data only without updating aggregations or indexes

Maintain a BI Solution

Question

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?

Options

AExecute a processStructure command.
BExecute a processUpdate command.
CExecute a processIndex command.
DExecute a processData command.

How the community answered

(22 responses)

A
73% (16)
B
9% (2)
C
5% (1)
D
14% (3)

Explanation

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

Topics

#XMLA processing#processIndex#aggregation processing#SSAS maintenance

Community Discussion

No community discussion yet for this question.

Full 70-448 Practice