nerdexam
Microsoft

70-448 · Question #257

You maintain a SQL Server 2008 Analysis Services (SSAS) database on a production server. The database contains a cube. You add new functionality to the cube on a development server. You need to…

The correct answer is A. Use the Synchronize Database Wizard. See the full explanation below for the reasoning.

Question

You maintain a SQL Server 2008 Analysis Services (SSAS) database on a production server. The database contains a cube. You add new functionality to the cube on a development server. You need to deploy the new functionality from the development server to the production server by ensuring that the effect on the users is minimized. What should you do?

Options

  • AUse the Synchronize Database Wizard.
  • BCopy the appropriate files from the development server to the production server.
  • CDetach the production database.
  • DModify the Target Server property to the production server by using Business Intelligence Development

How the community answered

(38 responses)
  • A
    82% (31)
  • B
    5% (2)
  • C
    11% (4)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 70-448 Practice