You need to select a storage mode for each measure group

HOTSPOT
You are designing a SQL Server Analysis Services (SSAS) cube that contains two measure
groups named Sales History and Current Sales.
The Sales History measure group has the following characteristics:

Data changes on a monthly basis.
The measure group contains a very high data volume.
Queries that use the measure group only reference aggregate data.
The measure group includes SUM, MIN, MAX, and COUNT aggregate functions.
The Current Sales measure group has the following characteristics:
Data changes frequently.
The measure group contains a low data volume.
Queries that use the measure group often reference non-aggregate data.
The measure group includes SUM, MIN, MAX, and COUNT aggregate functions.
You need to select a storage mode for each measure group. The solution must meet the
following requirements:
For the Sales History measure group, query performance must be optimized over data
latency.
For the Current Sales measure group, data latency must be optimized over query
performance.
What should you do? To answer, select the appropriate storage mode for each measure
group in the answer area.

HOTSPOT
You are designing a SQL Server Analysis Services (SSAS) cube that contains two measure
groups named Sales History and Current Sales.
The Sales History measure group has the following characteristics:

Data changes on a monthly basis.
The measure group contains a very high data volume.
Queries that use the measure group only reference aggregate data.
The measure group includes SUM, MIN, MAX, and COUNT aggregate functions.
The Current Sales measure group has the following characteristics:
Data changes frequently.
The measure group contains a low data volume.
Queries that use the measure group often reference non-aggregate data.
The measure group includes SUM, MIN, MAX, and COUNT aggregate functions.
You need to select a storage mode for each measure group. The solution must meet the
following requirements:
For the Sales History measure group, query performance must be optimized over data
latency.
For the Current Sales measure group, data latency must be optimized over query
performance.
What should you do? To answer, select the appropriate storage mode for each measure
group in the answer area.

Answer:



Leave a Reply 10

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


Carlos Escobar

Carlos Escobar

Sales History : Low-latency Molap
Current Sales: Low-latency Molap

Dim

Dim

For Current Sales-RT Rolap or RT Holap (cause told that Queries that use the measure group often reference non-aggregate data).

Fabio J.

Fabio J.

Sales History : Low-latency Molap
Current Sales = Real-Time Holap

Shak

Shak

sales History – MOLAP
Current Sales – Low Latency Molap

Sales HIstory Data changes on a monthly basis – therefore can be scheduled therefore MOLAP, NOT low Latency molap.
Current Sales: Low Latency Molap because question does not mention real-time but mentions that latency must be optimised

https://msdn.microsoft.com/en-us/library/ms175646.aspx

derek cao

derek cao

should be

scheduled molap(latency is 24 hour, but it is fast)
holap (no latency, could support min/max)
?