You work as a developer at ABC.com. The company uses a Microsoft SQL Server 2012
infrastructure.
A SQL Server Analysis Services (SSAS) cube is used by the Sales department. The database
has security roles defined for Sales users and managers.
You are developing an update to the SSAS cube. The development environment database has
security roles defined for the developers.
You need to deploy the update without changing the current security roles and members defined
for Sales users and managers. Roles and members included in the update must not be deployed.

How should you deploy the update?

A.
You should use Windows Backup to restore a copy of the database.

B.
You should use SQL Server Data Tools to deploy the update.

C.
You should use the SQL Server Analysis Services Deployment Wizard to deploy the update.

D.
You should copy the updated files and allow the copy to overwrite the current files.

Explanation: