nerdexam
Microsoft

70-448 · Question #254

You are maintaining a SQL Server 2008 Analysis Services (SSAS) solution in the production environment. You modify the solution to include two new measure groups in the development environment. You…

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

Question

You are maintaining a SQL Server 2008 Analysis Services (SSAS) solution in the production environment. You modify the solution to include two new measure groups in the development environment. You need to ensure that only one measure group is deployed to the cube in the production environment. What should you do?

Options

  • AUse the Deployment Wizard.
  • BUse Microsoft SQL Server Management Studio (SSMS) to issue an XMLA command.
  • CUse Microsoft SQL Server Management Studio (SSMS) to issue an UPDATE MEMBER command.
  • DUse Business Intelligence Development Studio (BIDS) along with the Deploy only changes option

How the community answered

(60 responses)
  • A
    5% (3)
  • B
    80% (48)
  • C
    3% (2)
  • D
    12% (7)

Community Discussion

No community discussion yet for this question.

Full 70-448 Practice