A company plans to migrate an on-premises database to Azure. The database workload requires SQL Server Agent jobs and cross-database queries. The disaster recovery (DR) solution must support automatic failover to a secondary Azure region with a recovery time objective (RTO) of less than 1 hour. After a failover, the application must connect to the database in the secondary region using the same connection string without requiring manual configuration changes. Which database solution and disaster recovery feature should you recommend?
- Azure SQL Managed Instance configured with a failover groupCevap
- BAzure SQL Database (single database) configured with active geo-replication
- CAzure SQL Managed Instance configured with active geo-replication
- DSQL Server on Azure Virtual Machines using Standard HDD disks for transaction logs and configured with Always On availability groups
Cevap
Azure SQL Managed Instance configured with a failover group
Azure SQL Managed Instance provides near-complete compatibility with the SQL Server database engine, including support for SQL Server Agent and cross-database queries. When configured with a failover group, it provides automatic failover capabilities and a single read-write listener endpoint. This listener endpoint ensures the application can connect to the primary instance in either region using the same connection string without manual configuration updates after a failover.
Adım Adım Çözüm
Anahtar Kavram
Selecting the correct Azure SQL deployment option based on legacy feature requirements and configuring failover groups for automatic multi-region DR with a single listener endpoint.
Tahmini Süre:1m 30s