You design a Business Intelligence (BI) solution by using SQL Server 2008. The solution has been deployed by using default settings on a SQL Server 2008 Analysis Services (SSAS) instance. The solution has a large cube that processes 10 million fact rows. You frequently encounter out-of-memory exceptions when the cube is processed. You need to recommend a solution to resolve the out-of-memory exceptions when the cube is processed. You want to achieve this task by using the minimum amount of development effort.
What should you do?
A.
Reduce the number of aggregations.
B.
Partition the cube. Process the cube based on each partition.
C.
Increase the physical memory available to the SSAS instance by modifying the MemoryTotalMemoryLimit server property.
D.
Increase the physical memory available to the SSAS instance by modifying the OLAPProcessBufferMemoryLimit server property.
Explanation:
Tip: "out-of-memory exceptions … development effort" = "OLAPProcessBufferMemoryLimit"