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.
Hot Area:
