Microsoft
70-467 · Question #165
70-467 Question #165: Real Exam Question with Answer & Explanation
The correct answer is D: Automatic MOLAP. Because the SSIS package already fully processes Cube1 daily and MOLAP pre-calculates aggregations, Automatic MOLAP is the best setting as its proactive caching intelligently manages cache rebuilds without triggering aggregation processing during active querying.
Question
You have a data warehouse named DW1. An OLAP cube named Cube1 uses DW1 as its data source. Cube1 uses the MOLAP storage mode. You create a SQL Server Integration Services (SSIS) package that updates DW1, and then processes Cube1. The package executes each day at 06:00. You need to configure the storage settings of Cube1. The solution must ensure that aggregation processing is reduced as much as possible during cube querying. What is the best storage setting you should you use for Cube1? More than one answer choice may achieve the goal. Select the BEST answer.
Options
- AMedium-latency MOLAP
- BScheduled MOLAP
- CLow-latency MOLAP
- DAutomatic MOLAP
Explanation
Because the SSIS package already fully processes Cube1 daily and MOLAP pre-calculates aggregations, Automatic MOLAP is the best setting as its proactive caching intelligently manages cache rebuilds without triggering aggregation processing during active querying.
Common mistakes.
- A. Medium-latency MOLAP triggers MOLAP cache rebuilds after a medium silence interval and can temporarily drop to ROLAP mode during the rebuild window, potentially exposing aggregation processing overhead during active querying.
- B. Scheduled MOLAP rebuilds the MOLAP cache on a fixed schedule regardless of query activity, which means the aggregation store can be dropped and rebuilt at a time that may coincide with active query periods.
- C. Low-latency MOLAP triggers very frequent MOLAP cache rebuilds to minimize data latency, which increases the likelihood that aggregation reprocessing overlaps with active user queries - working against the requirement to reduce processing during querying.
Concept tested. SSAS MOLAP proactive caching storage mode selection
Community Discussion
No community discussion yet for this question.