PrepAway - Latest Free Exam Questions & Answers

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.)

PrepAway - Latest Free Exam Questions & Answers

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:


Leave a Reply