nerdexam
Microsoft

70-466 · Question #99

You need to configure the partition storage settings to support the reporting requirements. Which partition storage setting should you use?

The correct answer is A. Low-latency MOLAP. Low-latency MOLAP is a proactive caching setting that automatically rebuilds the MOLAP cache with a short silence interval after source data changes, balancing query performance with near-real-time data freshness.

Configure and maintain an analysis services database

Question

You need to configure the partition storage settings to support the reporting requirements. Which partition storage setting should you use?

Options

  • ALow-latency MOLAP
  • BIn-Memory
  • CHigh-latency MOLAP
  • DRegular
  • EDirectQuery
  • FLazyAggregations

How the community answered

(63 responses)
  • A
    78% (49)
  • B
    6% (4)
  • C
    3% (2)
  • D
    2% (1)
  • E
    2% (1)
  • F
    10% (6)

Why each option

Low-latency MOLAP is a proactive caching setting that automatically rebuilds the MOLAP cache with a short silence interval after source data changes, balancing query performance with near-real-time data freshness.

ALow-latency MOLAPCorrect

Low-latency MOLAP configures SSAS proactive caching to detect source data changes and trigger a MOLAP cache rebuild after a brief silence interval (typically seconds). Until the new cache is ready, queries fall back to ROLAP against the relational source, then switch back to MOLAP once rebuilt, giving users both fast MOLAP aggregations and data that stays current for time-sensitive reporting requirements.

BIn-Memory

In-Memory is the default query mode for SSAS Tabular (xVelocity/VertiPaq engine) and is not a proactive caching partition storage option in SSAS Multidimensional.

CHigh-latency MOLAP

High-latency MOLAP uses a longer silence interval before rebuilding the cache, resulting in more stale data and is unsuitable when reporting requirements demand timely data.

DRegular

Regular MOLAP stores aggregations in MOLAP format but has no proactive caching - data is only refreshed during a full scheduled process, making it too stale for latency-sensitive reporting.

EDirectQuery

DirectQuery bypasses MOLAP aggregations entirely and issues every query directly to the relational source, sacrificing the performance benefits of pre-built aggregations.

FLazyAggregations

LazyAggregations is not a standard SSAS Multidimensional proactive caching partition storage setting; it is not a recognized option in this context.

Concept tested: SSAS proactive caching low-latency MOLAP partition storage

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

Topics

#partition storage#MOLAP#proactive caching#low-latency MOLAP

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice