nerdexam
Microsoft

70-460 · Question #28

You are developing a SQL Server Analysis Services (SSAS) cube. The cube contains several dimensions, a local measure group, and a linked measure group. Both measure groups use MOLAP partitions. You…

The correct answer is A. Implement the linked measure group as a local measure group. See the full explanation below for the reasoning.

Question

You are developing a SQL Server Analysis Services (SSAS) cube. The cube contains several dimensions, a local measure group, and a linked measure group. Both measure groups use MOLAP partitions. You need to write-enable one of the linked measure group partitions to support Microsoft Excel 2010 PivotTable What-If Analysis. What should you do before the partition can be write- enabled?

Options

  • AImplement the linked measure group as a local measure group.
  • BImplement the local measure group as a linked measure group.
  • CSet the Type property of the partition's measure group to Forecast.
  • DSet the StorageMode property of the linked measure group to Rolap.

How the community answered

(26 responses)
  • A
    81% (21)
  • B
    12% (3)
  • C
    4% (1)
  • D
    4% (1)

Community Discussion

No community discussion yet for this question.

Full 70-460 Practice