A company is planning to migrate an on-premises database to Azure. The database relies on SQL Server Agent jobs and cross-database queries. The migrated database must meet the following requirements:
- Provide high availability and automatic failover to a paired secondary region.
- Do not require modifications to the application connection strings during a failover.
- Support offloading read-only reporting queries to the secondary region.
Which two options should you include in the design to meet the requirements? (Select two.)
- Azure SQL Managed Instance as the database deployment optionCevap
- An auto-failover group configured for the database instancesCevap
- CAzure SQL Database single database as the database deployment option
- DActive geo-replication configured between database servers
Cevap
The design must include Azure SQL Managed Instance and an auto-failover group.
To meet the requirements, the design must use Azure SQL Managed Instance because it supports SQL Server Agent and cross-database queries, which are legacy features from the on-premises environment. Additionally, configuring an auto-failover group ensures automatic failover and provides read-write and read-only listener endpoints that prevent the need to modify application connection strings during a failover.
Adım Adım Çözüm
Anahtar Kavram
Selecting the appropriate Azure SQL deployment option based on legacy feature requirements and configuring auto-failover groups for seamless multi-region HA/DR with read-scale routing.
Tahmini Süre:2m 0s