You have a SQL Server Analysis Services (SSAS) database named DB1 on a server named
Server1.
You need to deploy DB1 from Server1 to four other servers. If the destination server already
contains a copy of DB1, the database must be updated only. If the destination server does
not contain a copy of DB1, the database must be copied to the destination server.
What is the best deployment option to use? More than one answer choice may achieve the
goal. Select the BEST answer.
A.
Analysis Services Deployment Wizard
B.
Analysis Management Objects (AMO) automation
C.
Backup and Restore
D.
Synchronize Database Wizard