Administering Relational Databases on Microsoft Azure — Question 6

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?

Answer options

Correct answer: B

Explanation

The correct answer is Azure SQL Database single database as it is a fully managed service that simplifies administration and is ideal for applications requiring easy scaling and synchronization. Azure SQL Managed instance and SQL Server on Azure virtual machines require more administrative overhead, while Azure Database for PostgreSQL is not compatible with the existing SQL Server databases.