nerdexam
Microsoft

70-460 · Question #37

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…

The correct answer is C. Option C. See the full explanation below for the reasoning.

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

70-460 question #37 exhibit

Options

  • AOption A
  • BOption B
  • COption C
  • DOption D

How the community answered

(38 responses)
  • A
    5% (2)
  • B
    11% (4)
  • C
    71% (27)
  • D
    13% (5)

Community Discussion

No community discussion yet for this question.

Full 70-460 Practice