nerdexam
Microsoft

70-768 · Question #45

How do you support the profit percentage in your solution design?

The correct answer is B. Create a calculated measure to divide profit by revenue. See the full explanation below for the reasoning.

Question

How do you support the profit percentage in your solution design?

Options

  • AAdd a fact table column and set the FormatString for the new measure to Percent.
  • BCreate a calculated measure to divide profit by revenue.
  • CAdd a new measure group to the cube to isolate the measure.
  • DDefine the MeasureExpression property on a new measure to divide profit by revenue.

How the community answered

(30 responses)
  • A
    17% (5)
  • B
    73% (22)
  • C
    3% (1)
  • D
    7% (2)

Community Discussion

No community discussion yet for this question.

Full 70-768 Practice