Microsoft
70-467 · Question #25
70-467 Question #25: Real Exam Question with Answer & Explanation
The correct answer is C: Option C. The correct MDX option uses an IIF conditional expression to apply a 1.5 multiplier for Customer A and a 1.1 multiplier for all other customers in a single efficient calculation pass.
Question
You are creating a Multidimensional Expressions (MDX) calculation for Projected Revenue in a cube. For Customer A, Projected Revenue is defined as 150 percent of the Total Sales for the customer. For all other customers, Projected Revenue is defined as 110 percent of the Total Sales for the customer. You need to calculate the Projected Revenue as efficiently as possible. Which calculation should you use? (More than one answer choice may achieve the goal. Select the BEST answer.)
Exhibit
Options
- AOption A
- BOption B
- COption C
- DOption D
Explanation
The correct MDX option uses an IIF conditional expression to apply a 1.5 multiplier for Customer A and a 1.1 multiplier for all other customers in a single efficient calculation pass.
Common mistakes.
- A. Option A likely uses a calculation structure requiring multiple passes or improperly scopes the conditional, introducing unnecessary formula engine overhead compared to a direct IIF expression.
- B. Option B likely relies on nested SCOPE assignments or a CASE-style construct that increases the number of calculation passes needed to resolve the projected revenue value.
- D. Option D likely applies the multiplier incorrectly or uses an inefficient expression that does not properly isolate the Customer A override from the general 110 percent rule, producing either wrong results or slower evaluation.
Concept tested. MDX IIF conditional calculation for member-specific projected revenue
Community Discussion
No community discussion yet for this question.