70-448 · Question #305
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. You should set the ProactiveCaching property of the partition to real-time hybrid online analytical. See the full explanation below for the reasoning.
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. To meet the business development, you create a SQL Server 2008 Analysis Server (SSAS) solution with a measure group contained. The measure group named Meatruth has a single partition. Now you are asked to not only make sure you have all aggregations that are part of the measure group stored in a multidimensional format, but also make sure the queries that use the measure group always refer to the newest edition of the source detail data. So what action should you perform to achieve that goal?
Options
- AYou should set the ProactiveCaching property of the partition to scheduled multidimensional online
- BYou should set the ProactiveCaching property of the partition to real-time multidimensional online
- CYou should set the ProactiveCaching property of the partition to real-time hybrid online analytical
- DYou should set the ProactiveCaching property of the partition to real-time relational online analytical
- EYou should set the ProactiveCaching property of the partition to automatic multidimensional online
How the community answered
(43 responses)- A9% (4)
- C84% (36)
- D2% (1)
- E5% (2)
Community Discussion
No community discussion yet for this question.