A SQL Server Analysis Services (SSAS) cube contains a large measure group. The fact
table supporting the measure group is loaded with new data throughout the day.
You have the following requirements:
Ensure that the cube displays current data as quickly as possible.
Maximize availability of the cube.
Maximize query performance for all aggregation levels.
You need to choose a partitioning strategy that meets the requirements.
Which partitioning strategy should you choose? (More than one answer choice may achieve
the goal. Select the BEST answer.)
A.
Create one partition for the current day that uses multidimensional OLAP (MOLAP) with
proactive caching as a storage mode.
B.
Create one partition for the current month that uses hybrid OLAP (HOLAP) as a storage
mode.
C.
Create one partition for the current day that uses relational OLAP (ROLAP) as a storage
mode.
D.
Create one partition for the current day that uses multidimensional OLAP (MOLAP) as a
storage mode. Process the partition each night.
Explanation:
“new data throughout the day (…) Ensure that the cube displays current data as quickly as possible.” -> ROLAP -> C
My mistake. “Maximize query performance for all aggregation levels” -> HOLAP -> B
Proactive caching aims to update cube as soon as possible maximizing query performance. So the correct answer is A.
https://msdn.microsoft.com/en-us/library/ms174769(v=sql.110).aspx
A is the correct answer