You are modifying a SQL Server Analysis Service (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 use proactive caching with minimum latency.
B. Create an XMLA script that will process the cube and then use SQL Server Agent to execute the script continuously.
C. Create a new measure group for the Average Quantity On Hand measure. Configure the storage mode for the new measure group’s partition to ROLAP.
D. Create a new measure group for the Total Quantity On Hand measure. Configure the storage mode for the new measure group’s partition to ROLAP.
