You are creating a SQL Server 2008 Analysis Services (SSAS) database which contains
some measure groups for Company.com.
One of measure groups Product Data allows refresh Than others’ frequently.
You should make sure that Product Data measure group would operate on a schedule
managed through SSAS.
Which is the correct answer?
A.
You should change the attribute of the ProactiveCaching property.
B.
You should change the attribute of the DataAggregation property.
C.
You should change the attribute of the ProcessingMode property.
D.
You should change the attribute of the ProcessingPriority property.
Explanation:
The ProactiveCaching property determines whether the SSAS service will process and
update the dimension automatically. Most typical SSAS solutions use MOLAP storage and
do not employ proactive caching.
EXAM TIP
Proactive caching is especially useful when the relational database is transaction oriented
and data changes at random. When data changes are predictable—such as when you use
an extract, transform, and load (ETL) process to load data—consider processing the cube
explicitly. When the data source is transaction oriented and you want minimum latency,
consider confi guring the cube to process automatically by using proactive caching.
How Proactive Caching Works
When you enable proactive caching, the server can listen for data change notifications and
can update dimensions and measures dynamically in an “autopilot” mode.