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

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?

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.
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.
Create a drillthrough action that will query the underlying data source in real time for the
Total Quantity On Hand measure.

C.
Change the storage mode of the partition to ROLAP.

D.
Add an additional MOLAP partition to the measure group.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Ralph

Ralph

TotalQuantity on hand will see the data “live” if it will be configured as ROLAP