get the app get the app       get the app       get the app


Question: 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.


Previous Next
Exam


Suggest other answer
Login to Discuss/suggest the answer...

Exam Exam: 70-448 MS SQL Server 2008, Business Intelligence





Recommended Learning for you

Close(X)
Subscribe here for free mock test on IAS PCS SSC and other competitive exam. Signup here to get SSC CGL Solution and main exam study material