nerdexam
Microsoft

70-467 · Question #5

A SQL Server Analysis Services (SSAS) cube contains a large measure group. The fact table supporting the measure group is loaded with new data throughout the day. You have the following…

The correct answer is A. Create one partition for the current day that uses multidimensional OLAP (MOLAP) with. SSAS MOLAP partitioning with proactive caching satisfies requirements for data currency, availability, and query performance by automatically refreshing the cube when source data changes.

Design BI data models

Question

A SQL Server Analysis Services (SSAS) cube contains a large measure group. The fact table supporting the measure group is loaded with new data throughout the day. You have the following requirements:

  • Ensure that the cube displays current data as quickly as possible.
  • Maximize availability of the cube.
  • Maximize query performance for all aggregation levels.

You need to choose a partitioning strategy that meets the requirements. Which partitioning strategy should you choose? (More than one answer choice may achieve the goal. Select the BEST answer.)

Options

  • ACreate one partition for the current day that uses multidimensional OLAP (MOLAP) with
  • BCreate one partition for the current month that uses hybrid OLAP (HOLAP) as a storage
  • CCreate one partition for the current day that uses relational OLAP (ROLAP) as a storage
  • DCreate one partition for the current day that uses multidimensional OLAP (MOLAP) as a

How the community answered

(55 responses)
  • A
    56% (31)
  • B
    24% (13)
  • C
    7% (4)
  • D
    13% (7)

Why each option

SSAS MOLAP partitioning with proactive caching satisfies requirements for data currency, availability, and query performance by automatically refreshing the cube when source data changes.

ACreate one partition for the current day that uses multidimensional OLAP (MOLAP) withCorrect

MOLAP with proactive caching automatically detects changes in the relational source and triggers incremental cube refresh or cache invalidation, ensuring the partition reflects current data without manual intervention. Because aggregations are stored in the multidimensional format, query performance is maximized at all aggregation levels, and the cube remains available during background processing.

BCreate one partition for the current month that uses hybrid OLAP (HOLAP) as a storage

HOLAP stores base data in the relational source and only aggregations in multidimensional format, so it does not maximize query performance at all aggregation levels - particularly at the leaf level where relational queries are issued.

CCreate one partition for the current day that uses relational OLAP (ROLAP) as a storage

ROLAP stores all data and aggregations in the relational source, which provides the most current data but delivers the worst query performance because every aggregation query must hit the relational database directly.

DCreate one partition for the current day that uses multidimensional OLAP (MOLAP) as a

Standard MOLAP without proactive caching requires manual or scheduled processing to incorporate new fact data, failing the requirement to display current data as quickly as possible throughout the day.

Concept tested: SSAS MOLAP proactive caching for real-time data

Source: https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/partitions-proactive-caching

Topics

#SSAS partitioning#MOLAP#ROLAP#HOLAP

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-467 Practice