You are developing a SQL Server Analysis Services (SSAS) multidimensional project that is configured to
source data from a SQL Azure database.
The cube is processed each night at midnight.
The largest partition in the cube takes 12 hours toprocess, and users are unable to access the cube until
noon.
The partition must be available for querying as soon as possible after processing commences.
You need to ensure that the partition is available for querying as soon as possible, without using source data to
satisfy the query.
Which three actions should you perform in sequence?
(To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the
correct order.)
Which three actions should you perform in sequence?
You are developing a SQL Server Analysis Services (SSAS) multidimensional project that is configured to
source data from a SQL Azure database.
The cube is processed each night at midnight.
The largest partition in the cube takes 12 hours toprocess, and users are unable to access the cube until
noon.
The partition must be available for querying as soon as possible after processing commences.
You need to ensure that the partition is available for querying as soon as possible, without using source data to
satisfy the query.
Which three actions should you perform in sequence?
(To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the
correct order.)
OK.
Lazy Aggregations. When set to lazy aggregations, partitions will be available to user queries immediately after data has been loaded. Aggregations will be created as a separate background process while users start to query the partition.
https://svangasql.wordpress.com/2011/11/21/ssas-processing-mode-lazy-aggregations/