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.
A.
A database snapshot
B.
A data-tier application
C.
Change data capture
D.
SQL Server Integration Services (SSIS)
Explanation:
http://technet.microsoft.com/en-us/library/ee210546.aspx
I think is D in our case(SSIS), not B.
See also http://www.microsoft4shared.com/free-download-new-updated-october-2016-microsoft-70-465-real-exam-61-70.html
Explanation:
“SIS supports connections to SQL Database by using the ADO.NET provider. OLEDB is not supported at this time. You can build the SSIS package connecting to SQL Database and create the data flow tasks the same way as you would against a typical on-premise SQL Server.
SSIS for Azure and Hybrid Data Movement”
think B is correct since it implies usage of DACPAC which is really the simplest way of exporting (or building via TFS) and deploying databases. It also works for Azure requirement.
B is the correct answer. SSIS basically is a tool to transfer data, while the question asks for transfering metadata.