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.
