You work as a Database Administrator (DBA) at ABC.com. The company uses a Microsoft SQL
Server 2012 infrastructure.
You discover an unused database dimension in a SQL Server Analysis Services (SSAS)
multidimensional database. You confirm that no cubes use the database dimension.
You want to delete the dimension.
How should you delete the dimension?
A.
By deleting the object in SQL Server Management Studio.
B.
By running the New Dimension Wizard.
C.
By dropping the dimension using a T-SQL command.
D.
By redeploying the project without the dimension.
Explanation:
A. should be correct
http://technet.microsoft.com/en-us/library/ms174957(v=sql.105).aspx
D. should be correct
or you u can manage it with an xmla command
any other way would not work
in D) you would loose partitions and would need to reprocess cube. a) is correct.
A. works as long as the dimension is not linked to a cube within the database
One of our guests not long ago proposed the following website.