What should you recommend?

You have two SQL Server instances named SQLDev and SQLProd that have access to various storage media.
You plan to synchronize SQLDev and SQLProd.
You need to recommend a solution that meets the following requirements:
. The database schemas must be synchronized from SQLDev to SQLProd.
. The database on SQLDev must be deployed to SQLProd by using a package.
. The package must support being deployed to Windows Azure SQL Database.
What should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.
A. A database snapshot
B. SQL Server Integration Services (SSIS)
C. Change data capture
D. A data-tier application

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.