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
A.
Analysis Services Deployment Wizard
https://technet.microsoft.com/en-us/library/ms174928(v=sql.110).aspx
D?
I’d say D, for A you need project files.
Agree.
The “the database must be updated only” condition
works only with D.
Correct is D.
“D” The Synchronize Wizard can be used to copy both data and metadata from a source server to a destination server. If the source server has the database copy that you want to deploy, copying the database copy to a destination server is straightforward. If the destination server already has a copy of the same database, it does not impact the synchronize operation and the database is updated. If there is no database, the new database is copied to the destination server
https://technet.microsoft.com/en-us/library/ms175446(v=sql.105).aspx
+1