1Z0-531 Question #52: Real Exam Question with Answer & Explanation

Question

Options

• ACALC DIM is faster than AGG on Sparse dimensions
• BAGG is faster than CALC DIM on Sparse dimensions
• CCALC DIM calculates member formulas
• DAGG calculates member formulas
• ECALC DIM calculates Sparse dimensions
• FAGG calculates Sparse dimensions
• GCALC DIM calculates Dense dimensions
• HAGG calculates Dense dimensions

Explanation

Differences bettewen CALC DIM and AGG. CALC DIM (Product); This line calculates the Product dimension doing both outline aggregation (such as rolling all the Colas up into the parent value) and member formulas (C), if they exist for members in that dimension. If we want to calculate multiple dimensions using this command (say, Market and Product), just separate them with commas: CALC DIM (Market, Product); Remember how we said that "CALC DIM" not only does aggregation but also member formulas? Well, how many member formulas are there in the Market and Product dimensions? That's right: none, so "CALC DIM" is wasting time looking for formulas that you know aren't there. For sparse dimensions that don't have formulas, there's a command that only does aggregation and as such, is usually faster: AGG (Market, Product) (B, F) Note: The CALC DIM command calculates the formulas and aggregations associated with each member of all the specified dimensions. This command calculates the formulas and aggregations associated with each member of all of the specified dimensions. The order in which dimensions are calculated depends on whether they are dense (G) or sparse (E). All of the dense dimensions are calculated first, in the order that the dense dimensions appear in dimList. The sparse dimensions are then calculated in a similar order.

No community discussion yet for this question.