You are developing a SQL Server 2008 Analysis Services (SSAS) method for Company.com.
You make before caching enable for a partition.
You should make sure that SSAS could search connected information when You could update many aspects storage.
Which is the correct answer?
A.
You should configure the attribute of ProcessingMode the partition to Immediate.
B.
You should configure the attribute of ProcessingMode the partition to LazyAggregations.
C.
You should configure the attribute of ProcessingMode the partition to OnCacheComplete.
D.
You should configure the attribute of ProcessingMode the partition to Common.
Explanation:
ProcessingMode
Defines the place in the cube processing at which data becomes available to users. By default, ProcessingMode is set to Regular, and users cannot access the measure group until processing is
complete. If ProcessingMode is set to LazyAggregations, data is accessible as soon as it is processed, but processing takes longer.
Answer C is correct according to explaination. There are 2 types of processing – Regular and lazyAggregations only.