An enterprise is designing a disaster recovery and high availability solution for an inventory management application. The database tier has the following requirements:
- Support for SQL Server Agent jobs and cross-database queries.
- Automatic failover to a secondary Azure region with a single connection string that automatically routes write traffic to the active primary.
- Provision of a secondary read-only endpoint in the secondary region for reporting workloads.
Which two database configurations should you include in the design to meet the requirements? (Select two.)
- Deploy Azure SQL Managed Instance in both the primary and secondary regions, configured within an auto-failover group.Answer
- Configure the application to connect using the auto-failover group's read-write listener endpoint.Answer
- CDeploy Azure SQL Database single databases using active geo-replication to the secondary region.
- DConfigure a SQL Server on Azure Virtual Machines deployment using Standard HDD storage for transaction log disks.
Answer
To meet the requirements, the design must include deploying Azure SQL Managed Instance in both the primary and secondary regions within an auto-failover group, and configuring the application to connect using the auto-failover group's read-write listener endpoint.
Deploying Azure SQL Managed Instance in an auto-failover group satisfies the requirements for SQL Server Agent and cross-database queries while providing automatic failover. Utilizing the auto-failover group's read-write listener endpoint ensures that the application connection string automatically routes write traffic to the active primary region without manual configuration updates during a failover event.
Step-by-Step Solution
Key Concept
Relational database HA and DR design using Azure SQL Managed Instance auto-failover groups