Exam 70-764 topic 1 question 161 discussion

Actual exam question from Microsoft's 70-764

Question #: 161
Topic #: 1

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)

Show Suggested Answer

Suggested Answer: B 🗳️
* 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. http://technet.microsoft.com/en-us/library/ ee210546.aspx

by vabjosh at May 4, 2019, 1:12 p.m.

Comments

Submit Cancel

cian

Highly Voted 6 years ago

I think the correct answer should be SSIS

upvoted 5 times

...

huzein

Most Recent 4 years, 7 months ago

"BEST" answer questions are always. What means "BEST", in which way "BEST"? SSIS is a possible answer, but the "BEST" answer, for whatever reason, is B. https://docs.microsoft.com/en-us/sql/relational-databases/data-tier-applications/data-tier-applications?view=sql-server-ver15

upvoted 1 times

...

Cococo

4 years, 7 months ago

What is this question about? Deploying changes from Dev DB to the Production one. Does Prod DB need the Dev's data? of course no... So there is a requirement to synch changes from Dev to Prod on schema level.. this is a .dacpac file(which is called a package by Microsoft) generated by the data-tier application Have a read please - https://docs.microsoft.com/en-us/sql/relational-databases/data-tier-applications/deploy-a-data-tier-application?view=sql-server-ver15

upvoted 1 times

...

tapsAch

4 years, 10 months ago

The correct answer is D. Refer: https://docs.microsoft.com/en-us/sql/integration-services/load-data-to-sql-database-with-ssis?view=sql-server-ver15

upvoted 1 times

...

Iva10

5 years ago

Probably B , becuase SSIS package don't synchronize well schemas only data https://books.google.hr/books?id=9157iScj0OIC&pg=PT118&lpg=PT118&dq=Data-tier+Applications+SSIS+package&source=bl&ots=_XBZ-BZvj8&sig=ACfU3U0eZ6Nd-KthKV8DiPQBknhpk2zlMQ&hl=hr&sa=X&ved=2ahUKEwj5iPrr-fTpAhXj_CoKHUb-CMYQ6AEwDXoECAcQAQ#v=onepage&q=Data-tier%20Applications%20SSIS%20package&f=false

upvoted 1 times

...

TheSwedishGuy

5 years, 4 months ago

The answer is D. SSIS creates a package called a .dacpac or a .bacpac that encapsulates a database's schema and data. SSIS also supports Azure. https://docs.microsoft.com/en-us/sql/relational-databases/data-tier-applications/data-tier-applications?redirectedfrom=MSDN&view=sql-server-ver15

upvoted 1 times

...