You are modifying a SQL Server Analysis Services (SSAS) cube.
The cube consists of a single measure group that contains the following measures:
– Total Quantity On Hand
– Average Quantity On Hand
The measure group has a single partition that uses the MOLAP storage mode.
You need to modify the cube design to ensure that the Total Quantity On Hand measure is updated in real- time
and that Average Quantity On Hand measure is updated hourly.
What should you do?
A.
Change the storage mode of the partition to ROLAP.
B.
Create a drillthrough action that will query the underlying data source in real time for the Total Quantity On
Hand measure.
C.
Add an additional MOLAP partition to the measure group.
D.
Create a new measure group for the Total QuantityOn Hand measure. Configure the storage mode for the
new measure group s partition to ROLAP.