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…

Question

Options

• AYou should change the attribute of the ProactiveCaching property.
• BYou should change the attribute of the DataAggregation property.
• CYou should change the attribute of the ProcessingMode property.
• DYou should change the attribute of the ProcessingPriority property.

• A
  71% (22)
• B
  3% (1)
• C
  19% (6)
• D
  6% (2)

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. 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.

No community discussion yet for this question.