QuestionQ76

VerifiedPlan and configure a high availability and disaster recovery (HA/DR) environment

You have an on-premises application named App1 that stores data in an on-premises Microsoft SQL Server 2019 database named DB1.

You plan to deploy additional App1 instances to separate Azure regions. Each region will contain a separate instance of App1 and DB1. The separate instances of DB1 will synchronize 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?

Explanation

Azure SQL Data Sync is based on Azure SQL Database: its hub database must be an Azure SQL Database, and its member databases can be Azure SQL Database or SQL Server databases. Azure SQL Managed Instance is not supported by SQL Data Sync. An Azure SQL Database single database is a fully managed service and avoids the virtual-machine and SQL Server administration required by SQL Server on Azure virtual machines.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!