PrepAway - Latest Free Exam Questions & Answers

What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You deploy a SQL Server 2008 Analysis Services (SSAS) cube. The cube contains a measure group that uses table binding. The measure group contains 200 million rows. A job that processes the measure group fails. The log shows an out-of-memory error. The job uses the Process Update option.
You need to resolve the error. You need to perform this action without increasing the available physical memory for the SSAS instance. What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Change the job to process the cube.

B.
Change the job to process the measure group with the Process Full option.

C.
Increase the number of partitions in the measure group.

D.
Increase the number of aggregations in the measure group.

Explanation:
Tip: "out-of-memory error" = "Increase the number of partitions"


Leave a Reply