You are managing a SQL Server 2008 Analysis Services (SSAS) database for Company.com.
Among the cubes, you are developing a new measure group.
You own a program which keeps partitions on the production copy of the cube.
You should make sure that you could get the cube definition on the production server when you should not overwrite any existed partitions.
Which is the correct answer?
A.
You should utilize the Deployment Wizard together with the proper selection.
B.
You should utilize a SQL Server 2008 Integration Services (SSIS) package and configure the processing selection to Do Process.
C.
You should utilize the Analysis Services Destination component in Microsoft SQL Server Integration Services (SSIS).
D.
You should utilize the DBCC SHRINKFILE and configure the processing selection to Do Process.