Which storage mode should you set the ProactiveCaching property of the partition to?

You create a SQL Server 2008 Analysis Server (SSAS) solution.
Your solution contains a measure group named FactMeasures with a single partition.
You need to ensure that the following requirements are met:
Queries that use FactMeasures always refer to the latest version of the source detail data.
All aggregations that are part of FactMeasures are stored in a multidimensional format.
Which storage mode should you set the ProactiveCaching property of the partition to?

You create a SQL Server 2008 Analysis Server (SSAS) solution.
Your solution contains a measure group named FactMeasures with a single partition.
You need to ensure that the following requirements are met:
Queries that use FactMeasures always refer to the latest version of the source detail data.
All aggregations that are part of FactMeasures are stored in a multidimensional format.
Which storage mode should you set the ProactiveCaching property of the partition to?

A.
Real-time hybrid online analytical processing (HOLAP)

B.
Real-time relational online analytical processing (ROLAP)

C.
Automatic multidimensional online analytical processing (MOLAP)

D.
Scheduled multidimensional online analytical processing (MOLAP)



Leave a Reply 0

Your email address will not be published. Required fields are marked *