You need to configure the storage mode for each cube partition

HOTSPOT
You have an OLAP cube named Cube1. Cube1 has two partitions named partition1 and
partition2.
You need to configure the storage mode for each cube partition.
The solution must meet the following requirements:
Users must be able to retrieve aggregate data from partition1 as quickly as possible.
The processing time for partition1 and partition2 must be minimized.
The least possible amount of storage must be used for partition2.
What should you do? To answer, select the appropriate storage mode for each partition in
the answer area.

HOTSPOT
You have an OLAP cube named Cube1. Cube1 has two partitions named partition1 and
partition2.
You need to configure the storage mode for each cube partition.
The solution must meet the following requirements:
Users must be able to retrieve aggregate data from partition1 as quickly as possible.
The processing time for partition1 and partition2 must be minimized.
The least possible amount of storage must be used for partition2.
What should you do? To answer, select the appropriate storage mode for each partition in
the answer area.

Answer:

Show Hint

Leave a Reply 5

Your email address will not be published. Required fields are marked *

SZ

SZ

partition1:HOLAP
partition2:ROLAP

partition1:

aggregate data: returns quickly
process time : minimum

it couldn’t be MOLAP, it doesn’t mention about processing detail data besides MOLAP process time is greater than HOLAP

Partition2:

Process time: minimum
Storage Space: minimum

It doesn’t mention about the aggregates and cube query performance, it only care about the process time and storage space, so it’s ROLAP.

Reply