70-448 · Question #144
You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server 2008. Now you are employed in a company which is named…
The correct answer is C. To achieve this goal, the OnlineMode property for the partition should be set to Immediate. 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…
Question
You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server 2008. Now you are employed in a company which is named NaproStar and work as the technical support for the company which uses SQL Server 2008 Analysis Services (SSAS). To meet the business development, you create a (SSAS) solution and enable proactive caching for a partition. Now you get an order from your company CIO, according to his requirement, while updating the multidimensional storage, you should make sure that you can use SSAS to query relational data. What action below should be performed?
Options
- ATo achieve this goal, the OnlineMode property for the partition should be set to OnCacheComplete
- BTo achieve this goal, the ProcessingMode property for the partition should be set to LazyAggregations.
- CTo achieve this goal, the OnlineMode property for the partition should be set to Immediate.
- DTo achieve this goal, the ProcessingMode property for the partition should be set to Regular
How the community answered
(33 responses)- A3% (1)
- B15% (5)
- C76% (25)
- D6% (2)
Explanation
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.
Topics
Community Discussion
No community discussion yet for this question.