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: 
Why not HOLAP and ROLAP?
https://msdn.microsoft.com/en-us/library/ms174915.aspx
0
0
HOLAP and ROLAP Agree
0
0
Agree with you. Holap and Rolap answers best all the requirments.
Its said that “Users must be able to retrieve aggregate data…”
not the detailed data.
0
0
Answer is correct. It is MOLAP and HOLAP.
“The processing time for partition1 and partition2 must be minimized.” Means it can’t be ROLAP for either because it takes the longest for processing. Partition 1 I would still say MOLAP, even though it says aggregate data, just because MOLAP is still faster than HOLAP for querying in general. “The least possible amount of storage must be used for partition2.” Partition 2 is HOLAP. HOLAP is a mix between MOLAP and ROLAP, and ROLAP uses less storage than MOLAP, so HOLAP would be somewhere in between on storage, but still minimize processing time.
0
0
I dont agree with you bman, sorry 🙂
“Users must be able to retrieve aggregate data from partition1 as quickly as possible.”
(From MSDN) _ “…HOLAP storage mode is generally suited for partitions in cubes that require rapid query response for summaries based on a large amount of source data. However, where users generate queries that must touch leaf level data, such as for calculating median values, MOLAP is generally a better choice.”
In the question is referred that you need do access to leaf data, just mention that you need to access to aggregated data.
“The least possible amount of storage must be used for partition2.”
However, ROLAP enables users to view data in real time and can save storage space when you are working with large datasets that are infrequently queried, such as purely historical data.
I think the right answer it’s
Partition 1 _ HOLAP
Partition 2 _ ROLAP
1
0
You totally ignored the processing time must be minimized requirement, so it cannot be rolap for either. I could see HOLAP, HOLAP meeting the requirements, other than MOLAP should process quicker and still meets the aggregrate performance requirement plus some.
0
0
Bman, I think, that MOLAP processing time would be maximum, because it copy all source data to multidimensional structure, unlike HOLAP, which stored only aggregetes in multidimensional structure. ROLAP generally not cause a copy of the source data.
Isn’t it?
0
0
holap and rolap
sorry bman – “Least possible” storage space sounds like its a stronger requirement than processing time must be minimized.
0
0
also they only require aggregate data in Partition 1 to be accesed as quickly as possible … so MOLAP is NOT the best answer for Partition 1
0
0
Usually posts some incredibly interesting stuff like this. If you are new to this site.
0
0
that could be the end of this report. Here you will come across some web pages that we consider youll appreciate, just click the links over
0
0