070-466 Free Dumps Study Materials
Question 3: 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
Correct Answer: D
Explanation: In the Synchronize Database Wizard dialog box, type the name of the source server and
source database in the appropriate fields.
Synchronization will occur for source and destination databases that have the same name.
If the destination server already has a database that shares the same name as the source database,
the destination database will be updated with the metadata and data of the source. If the database
does not exist, it will be created on the destination server. Click Next.
Ref: http://technet.microsoft.com/en-us/library/ms174928(v=sql.110).aspx