Microsoft Exam Questions

Which partitioning strategy should you choose?

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: