You are a database developer and you have about two years experience in creating
business intelligence (BI) solutions by using SQL Server2008.
Now you are employed in a company which is named NaproStar and you are in charge of a
SQL
Server 2008 Analysis Services (SSRS) database for the company.
To meet the business requirements, a new measure group is created in one of the cubes.
A program with partitions maintained is on the production copy of the cube.
Now you get an order from the CIO that you should have the cube definition updated on the
production server, besides, you should not rewrite any existing partitions.
So what action should you perform to achieve that goal?
A.
The Business Intelligence Development Studio (BIDS) should be used and the processing
option should be set to Do Not Process
B.
The Analysis Wizard should be used along with the appropriate options
C.
The Deployment Wizard should be used along with the appropriate options
D.
An UPDATE CUBE statement should be executed in Microsoft SQL Server Management
Studio (SSMS)
E.
The Analysis Services Destination component should be used in Microsoft SQL Server
Integration Services (SSIS)