70-467 Question #84: Real Exam Question with Answer & Explanation

The correct answer is C: Hybrid OLAP (HOLAP) with proactive caching disabled. HOLAP with proactive caching disabled stores aggregations in multidimensional format while leaving detail data in the relational source, without triggering automatic cache rebuilds when source data changes.

Question

You need to select the appropriate storage settings for the cube. Which settings should you choose?

Options

ARelational OLAP (ROLAP) with proactive caching enabled
BMultidimensional OLAP (MOLAP) with proactive caching enabled and a rebuild interval of
CHybrid OLAP (HOLAP) with proactive caching disabled
DHybrid OLAP (HOLAP) with proactive caching enabled

Explanation

HOLAP with proactive caching disabled stores aggregations in multidimensional format while leaving detail data in the relational source, without triggering automatic cache rebuilds when source data changes.

Common mistakes.

A. ROLAP stores all data and aggregations in the relational database, which results in significantly slower query performance compared to MOLAP or HOLAP because no pre-computed aggregations are stored multidimensionally.
B. MOLAP with proactive caching enabled stores all data multidimensionally and automatically rebuilds the cube when source data changes, which causes frequent processing overhead and latency gaps during rebuilds.
D. HOLAP with proactive caching enabled would trigger automatic cache refreshes on source data changes, introducing uncontrolled processing load and brief periods of stale or unavailable data.

Concept tested. SSAS HOLAP storage mode and proactive caching configuration

Reference. https://learn.microsoft.com/en-us/analysis-services/multidimensional-models-olap-logical-cube-objects/partitions-proactive-caching

Community Discussion

No community discussion yet for this question.

Full 70-467 Practice