PrepAway - Latest Free Exam Questions & Answers

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.

PrepAway - Latest Free Exam Questions & Answers

Answer:

5 Comments on “You need to configure the storage mode for each cube partition

  1. SZ says:

    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.




    0



    0

Leave a Reply