nerdexam
Microsoft

70-448 · Question #221

You maintain a SQL Server 2008 Analysis Services (SSAS) server. You add two new measure groups to an existing cube. You need to deploy only one of these measure groups to the production environment…

The correct answer is C. Use SQL Server Management Studio (SSMS) to issue an XMLA command. See the full explanation below for the reasoning.

Question

You maintain a SQL Server 2008 Analysis Services (SSAS) server. You add two new measure groups to an existing cube. You need to deploy only one of these measure groups to the production environment with minimal impact to the cube. What should you do?

Options

  • AUpdate the Data Source View.
  • BBack up and restore the cube to the production environment.
  • CUse SQL Server Management Studio (SSMS) to issue an XMLA command.
  • DUse the Synchronize Database Wizard with appropriate options.

How the community answered

(20 responses)
  • A
    15% (3)
  • B
    5% (1)
  • C
    75% (15)
  • D
    5% (1)

Community Discussion

No community discussion yet for this question.

Full 70-448 Practice