You are modifying a SQL Server Analysis Service (SSAS) cube.
The cube consist 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.
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.

B.
Change the storage mode of the partition to use proactive caching with minimum latency.

C.
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.

D.
Create an XMLA script that will process the cube and then use SQL Server Agent to execute the script
continuously.