PrepAway - Latest Free Exam Questions & Answers

Which setting should you select?

HOTSPOT
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.

PrepAway - Latest Free Exam Questions & Answers

Answer:

Explanation:

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.

One Comment on “Which setting should you select?


Leave a Reply