A financial services company is designing a high availability (HA) and disaster recovery (DR) solution for a database workload currently on-premises. The workload requires cross-database queries and SQL Server Agent jobs. The solution must support:
* An RTO of minutes
* An RPO of seconds
* Automatic failover to a secondary Azure region
* A single connection string that does not change after failover
* Minimal administrative overhead
Which two actions should you recommend to meet the requirements?
- Deploy Azure SQL Managed Instance as the relational database tier.Cevap
- Configure an auto-failover group that includes a read-write listener.Cevap
- CDeploy Azure SQL Database single databases and enable active geo-replication.
- DConfigure geo-redundant storage (GRS) backup replication on Azure SQL Database elastic pools.
Cevap
Deploy Azure SQL Managed Instance and configure an auto-failover group with a read-write listener.
To support instance-level features such as SQL Server Agent jobs and cross-database queries with minimal administrative overhead, Azure SQL Managed Instance is required. To meet the DR requirements, which include automatic failover to a secondary region, a -minute RTO, a -second RPO, and a single connection string, you must configure an auto-failover group with a read-write listener.
Adım Adım Çözüm
Anahtar Kavram
Designing high availability and disaster recovery for SQL Server workloads in Azure requiring SQL Agent and cross-database queries using SQL Managed Instance and Auto-Failover Groups.