nerdexam
Microsoft

70-466 · Question #51

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. SSAS linked measure groups are read-only by design and cannot have their partitions write-enabled; the partition must belong to a local measure group before write-back can be enabled.

Build an analysis services database

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

(35 responses)
  • A
    57% (20)
  • B
    9% (3)
  • C
    23% (8)
  • D
    11% (4)

Why each option

SSAS linked measure groups are read-only by design and cannot have their partitions write-enabled; the partition must belong to a local measure group before write-back can be enabled.

AImplement the linked measure group as a local measure group.Correct

Write-enabling a partition requires that the partition belong to a local measure group within the same database, because write-back data must be stored locally and the partition's storage must be under direct control of the current cube. Converting the linked measure group to a local measure group removes the read-only restriction inherited from the source database, allowing the target partition to be write-enabled for Excel What-If Analysis scenarios.

BImplement the local measure group as a linked measure group.

Converting a local measure group into a linked measure group would move it to a remote database and make it read-only, which is the opposite of what is needed for write-enabling.

CSet the Type property of the partition's measure group to Forecast.

The Type property on a measure group is a semantic annotation for tools and does not control or enable write-back functionality on partitions.

DSet the StorageMode property of the linked measure group to Rolap.

Write-back in SSAS requires MOLAP storage, not ROLAP; switching to ROLAP would actually prevent write-back from functioning correctly.

Concept tested: SSAS write-enabled partitions and linked measure group limitations

Source: https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/set-partition-writeback

Topics

#linked measure groups#write-back#MOLAP partitions#What-If Analysis

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-466 Practice