PrepAway - Latest Free Exam Questions & Answers

What is the best deployment option to use?

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.

PrepAway - Latest Free Exam Questions & Answers

A.
Analysis Services Deployment Wizard

B.
Analysis Management Objects (AMO) automation

C.
Backup and Restore

D.
Synchronize Database Wizard

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


Leave a Reply