PdfPrep.com

What should you do?

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 you do?
A . Write a Multidimensional Expressions (MDX) command to drop the dimension from the database.
B . Write a Data Mining Extensions (DMX) command to drop the dimension from the database.
C . Script the deletion of the dimension as an XMLA command for execution against the production model.
D . Write a T-SQL command to drop the dimension from the database.

Answer: C

Exit mobile version