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.
Question
Options
- ALow-latency MOLAP
- BIn-Memory
- CHigh-latency MOLAP
- DRegular
- EDirectQuery
- FLazyAggregations
How the community answered
(63 responses)- A78% (49)
- B6% (4)
- C3% (2)
- D2% (1)
- E2% (1)
- F10% (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.
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.
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.
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.
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.
DirectQuery bypasses MOLAP aggregations entirely and issues every query directly to the relational source, sacrificing the performance benefits of pre-built aggregations.
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
Community Discussion
No community discussion yet for this question.