You design a Business Intelligence (BI) solution by using SQL Server 2008. The solution has a cube that is processed periodically. The cube takes several hours to process. Cube processing results in a considerable amount of downtime. You need to minimize the downtime while maintaining the best possible query performance of the cube.
What should you do?
A.
Use the multidimensional online analytical processing (MOLAP) cube storage model.
Process the cube on a staging server.
Use database synchronization to copy the cube to a production server.
B.
Use the relational online analytical processing (ROLAP) cube storage model.
Process the cube on a staging server.
Use database synchronization to copy the cube to a production server.
C.
Use the hybrid online analytical processing (HOLAP) cube storage model.
Process the cube on a production server.
D.
Partition the cube into several partitions.
Use the relational online analytical processing (ROLAP) cube storage model for each partition.
Process the cube on a production server.
Explanation:
Tip: "minimize the downtime … best possible query performance" = "MOLAP"MOLAP
The MOLAP storage mode causes the aggregations of the partition and a copy of its source data to be stored in a multidimensional structure in Analysis Services when the partition is processed. This MOLAP structure is highly optimized to maximize query performance. The storage location can be on the computer where the partition is defined or on another computer running Analysis Services. Because a copy of the source data resides in the multidimensional structure, queries can be resolved without accessing the partition’s source data. Query response times can be decreased substantially by using aggregations. The data in the partition’s MOLAP structure is only as current as the most recent processing of the partition.
As the source data changes, objects in MOLAP storage must be processed periodically to incorporate those changes and make them available to users. Processing updates the data in the MOLAP structure, either fully or incrementally. The time between one processing and the next creates a latency period during which data in OLAP objects may not match the source data. You can incrementally or fully update objects in MOLAP storage without taking the partition or cube offline.ROLAP will not improve performance. HOLAP storage mode is generally suited for partitions in cubes that require rapid query response for summaries based on a large amount of source data