You maintain a SQL Server 2008 Analysis Services (SSAS) database. You create a new
measure group in one of the cubes.
You have a program that maintains partitions on the production copy of the cube.
You need to update the cube definition on the production server without overwriting any
existing partitions.
What should you do?
A.
Use the Deployment Wizard along with the appropriate options.
B.
Execute an UPDATE CUBE statement in Microsoft SQL Server Management Studio
(SSMS).
C.
Use the Analysis Services Destination component in Microsoft SQL Server Integration
Services (SSIS).
D.
Use the Business Intelligence Development Studio (BIDS) and set the processing option
to Do Not Process.