You are modifying a SQL Server Analysis Services (SSAS) multidimensional database. You have identified a dimension that is no longer used by any cubes. You need to delete the dimension. What should yo

Question

Options

• AWrite a T-SQL command to drop the dimension from the database.
• BScript the deletion of the dimension as an XMLA command for execution against the production model.
• CUse the SQL Server Analysis Services Migration Wizard.
• DDeploy the project from the development environment by using SQL Server Management Studio.

• A
  3% (1)
• B
  83% (33)
• C
  5% (2)
• D
  10% (4)

Explanation

In SQL Server Analysis Services (SSAS), multidimensional objects such as dimensions, cubes, and measures are not managed using T-SQL - that language applies to the relational SQL Server engine, not the SSAS analytical engine. SSAS objects are managed via XMLA (XML for Analysis), which is the standard protocol for communicating with SSAS. To delete a dimension from a production SSAS server, you script the deletion as an XMLA Delete command and execute it using a tool like SQL Server Management Studio's XMLA query window. Option A is wrong because T-SQL DROP cannot target SSAS objects. Option C is irrelevant - no such migration wizard exists for this task. Option D is incorrect because 'Deploy from development environment using SSMS' is not a valid deployment method; SSAS projects are deployed from SSDT (SQL Server Data Tools), not SSMS.

No community discussion yet for this question.