Microsoft
70-460 · Question #82
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 B. 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 cube as a local cube.
- BImplement the linked measure group as a local measure group.
- CEnsure that the measure group measures only use semiadditive aggregation functions.
- DEnsure that the measure group measures only use nonadditive aggregation functions
How the community answered
(49 responses)- A4% (2)
- B71% (35)
- C8% (4)
- D16% (8)
Community Discussion
No community discussion yet for this question.