Posted by: Pdfprep
Post Date: November 17, 2020
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
Leave a Reply