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.
C – XMLA is correct. This language is an administrator language for defining objects, starting processing and so on. Language is an XML rather, but you can easily script actions to XMLA on Dev and execute it later on production.
Mdx is multidimensional query language only
Dmx is language used for predictive queries
Sql could be used against data source (sql server)
Thank Ralph for your tips.
C is correct, xmla is the language to manage your ssas multidimensional database