You are configuring the partition storage settings for a SQL Server Analysis Services (SSAS) cube.
The partition storage must meet the following requirements:
Optimize the storage of source data and aggregations in the cube.
Use proactive caching.
Drop cached data that is more than 30 minutes old.
Update the cache when data changes, with a silence interval of 10 seconds.
You need to select the partition storage setting.
Which setting should you select?
To answer, select the appropriate setting in the answer area.
Hot Area:
Correct Answer:
Explanation/Reference:
http://msdn.microsoft.com/en-us/library/ms175646.aspx
Low Latency MOLAP
Detail data and aggregations are stored in multidimensional format. The server listens for notifications of changes to the data and switches to real-time ROLAP while MOLAP objects are reprocessed in a cache. A silence interval of at least 10 seconds is required before updating the cache. There is an override interval of 10 minutes if the silence interval is not attained. Processing occurs automatically as data changes with a target latency of 30 minutes after the first change.
This setting would typically be used for a data source with frequent updates when query performance is somewhat more important than always providing the most current data. This setting automatically processes MOLAP objects whenever required after the latency interval.
Performance is slower while the MOLAP objects are being reprocessed.
