You work as a database administrator for Abc.com. You are responsible for managing a SQL Server 2008 Analysis Services (SSAS) database. You are in the process of creating a new measure group in a cube. Abc.com has an application that keeps the partitions on the production copy of the cube. You need to obtain the cube definition on the production server while ensuring that you do not overwrite any existed partitions. What should you do?
1)You should consider using the Deployment Wizard in conjunction with the proper selection. 2)You should consider using a SQL Server 2008 Integration Services (SSIS) package Thereafter the processing selection should be set to Do Process. 3)You should consider using the SQL Server Analysis Services Data source component in Microsoft SQL Server Integration Services (SSIS). 4)You should consider using the DBCC SHRINKFILE. Thereafter the processing selection should be set to Do Process. PreviousNext
Suggest other answer Login to Discuss/suggest the answer...
You can help us to improve by giving your valuable suggestions at firstname.lastname@example.org
By using the service of this site, I agree that I will serve wholeheartedly
and will not indulge in any sort of activity that threats the integrity of the organisation I am working for / I work for.
I have a firm believe in the notion that knowledge should be open source and
helping the needy and deserving part of society will always be my motto.
Knowledge is the power, Dont miss any paper, Subscribe to us