You are deploying an update to a SQL Server Analysis Services (SSAS) cube to a
production environment.
The production database has been configured with security roles.
You need to preserve the existing security roles in the production database. Database roles
and their user accounts from the development environment must not be deployed to the
production server.
Which deployment method should you use?
A.
Use the SQL Server Analysis Services Deployment Wizard.
B.
Backup and restore the database.
C.
Use the SQL Server Analysis Services Migration Wizard.
D.
Deploy the project from SQL Server Data Tools to the production server.
The other solutions will replace the destination cube with all the settings. “A”
http://mund-consulting.com/Blog/images/deployment-partitions-roles.png