Microsoft
70-448 · Question #301
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…
The correct answer is A. Use the Deployment Wizard along with the appropriate options. See the full explanation below for the reasoning.
Question
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?
Options
- AUse the Deployment Wizard along with the appropriate options.
- BExecute an UPDATE CUBE statement in Microsoft SQL Server Management Studio (SSMS).
- CUse the Analysis Services Destination component in Microsoft SQL Server Integration Services (SSIS).
- DUse the Business Intelligence Development Studio (BIDS) and set the processing option to Do Not Process.
How the community answered
(23 responses)- A74% (17)
- B17% (4)
- C4% (1)
- D4% (1)
Community Discussion
No community discussion yet for this question.