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: