nerdexam
Microsoft

70-448 · Question #272

You create a SQL Server 2008 Analysis Services (SSAS) solution. You enable proactive caching for a partition. You need to ensure that SSAS can query relational data when multidimensional storage is…

The correct answer is A. Set the OnlineMode property for the partition to Immediate. See the full explanation below for the reasoning.

Question

You create a SQL Server 2008 Analysis Services (SSAS) solution. You enable proactive caching for a partition. You need to ensure that SSAS can query relational data when multidimensional storage is being updated. What should you do?

Options

  • ASet the OnlineMode property for the partition to Immediate.
  • BSet the ProcessingMode property for the partition to Regular.
  • CSet the OnlineMode property for the partition to OnCacheComplete.
  • DSet the ProcessingMode property for the partition to LazyAggregations.

How the community answered

(26 responses)
  • A
    73% (19)
  • B
    4% (1)
  • C
    15% (4)
  • D
    8% (2)

Community Discussion

No community discussion yet for this question.

Full 70-448 Practice