DP-300 Certification Practice Question #222

Question

You have an on-premises app named App1 that stores data in an on-premises Microsoft SQL Server 2019 database named DB1.
You plan to deploy additional instances of App1 to separate Azure regions. Each region will have a separate instance of App1 and DB1. The separate instances of
DB1 will sync by using Azure SQL Data Sync.
You need to recommend a database service for the deployment. The solution must minimize administrative effort.
What should you include in the recommendation?

Accepted Answer

To implement multi-region synchronization for SQL databases using Azure SQL Data Sync while minimizing administrative effort, **Azure SQL Database single database** (Option B) should be recommended. Azure SQL Data Sync is natively built for Azure SQL Database and on-premises SQL Server instances to perform bi-directional synchronization. It explicitly does not support Azure SQL Managed Instance (Option A). Furthermore, using Azure SQL Database (PaaS) minimizes administrative overhead compared to deploying SQL Server on Azure VMs (Option D), which requires managing the virtual machine and operating system updates.

More DP-300 practice questions