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.
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.
B
0
0
Average Quantity On Hand is Molap, so can be left as is (we only need to take care to process it every hour)
Total Quantity On Hand must be in real time, so only ROLAP is ok.
The answer “D” is the best here – additional measure group with storage mode ROLAP
0
0
I agree with Ralph. D
0
0