Exam DP-200 topic 1 question 4 discussion

Actual exam question from Microsoft's DP-200

Question #: 4
Topic #: 1

You are a data architect. The data engineering team needs to configure a synchronization of data between an on-premises Microsoft SQL Server database to
Azure SQL Database.
Ad-hoc and reporting queries are being overutilized the on-premises production instance. The synchronization process must:
✑ Perform an initial data synchronization to Azure SQL Database with minimal downtime
✑ Perform bi-directional data synchronization after initial synchronization
You need to implement this synchronization solution.
Which synchronization method should you use?

A. transactional replication
B. Data Migration Assistant (DMA)
C. backup and restore
D. SQL Server Agent job
E. Azure SQL Data Sync

Show Suggested Answer

Suggested Answer: E 🗳️
SQL Data Sync is a service built on Azure SQL Database that lets you synchronize the data you select bi-directionally across multiple SQL databases and SQL
Server instances.
With Data Sync, you can keep data synchronized between your on-premises databases and Azure SQL databases to enable hybrid applications.
Compare Data Sync with Transactional Replication

References:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-sync-data

by Ashwinee at Aug. 4, 2020, 9:15 a.m.

Comments

Submit Cancel

promiseve

4 years, 3 months ago

the answer is E

upvoted 2 times

...

chaoxes

4 years, 6 months ago

Correct answer is E. SQL Data Sync is a service built on Azure SQL Database that lets you synchronize the data you select bi-directionally across multiple databases, both on-premises and in the cloud. Source: https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-data-sql-server-sql-database

upvoted 4 times

memo43

4 years ago

keyword is bi-directional

upvoted 1 times

...

syu31svc

4 years, 6 months ago

Can only be E

upvoted 1 times

...

jgil

4 years, 9 months ago

https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-data-sql-server-sql-database

upvoted 2 times

...