nerdexam
Microsoft

70-466 · Question #58

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 me

The correct answer is 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.. To support different update frequencies for measures in a single MOLAP measure group, you must separate them into distinct measure groups with different storage modes.

Configure and maintain an analysis services database

Question

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?

Exhibit

70-466 question #58 exhibit

Options

  • ACreate a new measure group for the Total Quantity On Hand measure. Configure the storage mode for the new measure group's partition to ROLAP.
  • BCreate an XMLA script that will process the cube and then use SQL Server Agent to execute the script continuously.
  • CChange the storage mode of the partition to use proactive caching with minimum latency.
  • DCreate a new measure group for the Average Quantity On Hand measure. Configure the storage mode for the new measure group's partition to ROLAP.

How the community answered

(25 responses)
  • A
    48% (12)
  • B
    8% (2)
  • C
    16% (4)
  • D
    28% (7)

Why each option

To support different update frequencies for measures in a single MOLAP measure group, you must separate them into distinct measure groups with different storage modes.

ACreate a new measure group for the Total Quantity On Hand measure. Configure the storage mode for the new measure group's partition to ROLAP.Correct

ROLAP storage mode reads data directly from the relational source on every query, providing real-time data without requiring cube processing. By moving Total Quantity On Hand into its own measure group configured as ROLAP, it reflects source changes immediately. The original measure group retaining Average Quantity On Hand can remain MOLAP and be processed on the hourly schedule independently.

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

Continuously executing an XMLA process script via SQL Agent is not a real-time update mechanism and imposes excessive load without providing true real-time results.

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

Proactive caching with minimum latency applies to the entire partition and cannot differentiate update frequencies between individual measures within the same measure group.

DCreate a new measure group for the Average Quantity On Hand measure. Configure the storage mode for the new measure group's partition to ROLAP.

This is backwards - it assigns ROLAP (real-time) to Average Quantity On Hand, which only needs hourly updates, while leaving Total Quantity On Hand in the MOLAP partition that requires manual processing.

Concept tested: SSAS MOLAP vs ROLAP storage mode per measure group

Source: https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/set-partition-storage-molap-rolap-holap

Topics

#ROLAP storage#real-time updates#measure groups#mixed latency requirements

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-466 Practice