Microsoft
70-448 · Question #16
You create a SQL Server 2008 Analysis Server (SSAS) solution. Your solution contains a measure group named FactMeasures with a single partition. You need to ensure that the following requirements…
The correct answer is A. Real-time hybrid online analytical processing (HOLAP). See the full explanation below for the reasoning.
Question
You create a SQL Server 2008 Analysis Server (SSAS) solution. Your solution contains a measure group named FactMeasures with a single partition. You need to ensure that the following requirements are met:
- Queries that use FactMeasures always refer to the latest version of
the source detail data.
- All aggregations that are part of FactMeasures are stored in a
multidimensional format. Which storage mode should you set the ProactiveCaching property of the partition to?
Options
- AReal-time hybrid online analytical processing (HOLAP)
- BReal-time relational online analytical processing (ROLAP)
- CAutomatic multidimensional online analytical processing (MOLAP)
- DScheduled multidimensional online analytical processing (MOLAP)
How the community answered
(23 responses)- A78% (18)
- B4% (1)
- C13% (3)
- D4% (1)
Community Discussion
No community discussion yet for this question.