PrepAway - Latest Free Exam Questions & Answers

Which deployment method should you use?

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 inthe 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?

PrepAway - Latest Free Exam Questions & Answers

A.
Back up and restore the database.

B.
Use the SQL Server Analysis Services Migration Wizard.

C.
Use the SQL Server Analysis Services Deployment Wizard.

D.
Deploy the project from SQL Server Data Tools to the production server.


Leave a Reply