Administering a SQL Database Infrastructure — Question 9

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 SQL Azure.
What should you recommend? More than one answer choice may achieve the goal. Select the BEST answer.

Answer options

Correct answer: B

Explanation

The best solution is a data-tier application (B) as it allows for the deployment of entire database schemas and can be deployed to SQL Azure. A database snapshot (A) does not facilitate schema synchronization, while Change data capture (C) is used for tracking changes and does not support deployment. SQL Server Integration Services (SSIS) (D) is primarily for data transformation and loading, not for schema deployment.