PrepAway - Latest Free Exam Questions & Answers

You need to delete the dimension

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?

PrepAway - Latest Free Exam Questions & Answers

A.
Deploy the project from the development environment by using SQL Server Management Studio.

B.
Script the deletion of the dimension as an XMLA command for execution against the production model.

C.
Use the SQL Server Analysis Migration Wizard.

D.
Write a T-SQL command to drop the dimension from the database

One Comment on “You need to delete the dimension


Leave a Reply