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

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.

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.

HOLAP combines MOLAP-style aggregation storage for fast query performance with relational storage for detail data, reducing the multidimensional storage footprint. Disabling proactive caching means the cube will not automatically detect source data changes and rebuild, which is appropriate when updates need to be controlled and scheduled rather than triggered on every source change.

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.