Microsoft
70-448 · Question #119
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…
The correct answer is A. You should utilize the Deployment Wizard together with the proper selection. See the full explanation below for the reasoning.
Question
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?
Options
- AYou should utilize the Deployment Wizard together with the proper selection.
- BYou should utilize a SQL Server 2008 Integration Services (SSIS) package and configure the processing
- CYou should utilize the Analysis Services Destination component in Microsoft SQL Server Integration
- DYou should utilize the DBCC SHRINKFILE and configure the processing selection to Do Process.
How the community answered
(39 responses)- A79% (31)
- B8% (3)
- C10% (4)
- D3% (1)
Community Discussion
No community discussion yet for this question.