オンプレミスの Microsoft SQL Server 2022 インスタンス (名前: SQL1) があります。Azure サブスクリプションには、Azure SQL マネージドインスタンス (名前: SQLM11) が含まれています。SQL1 と SQLMI1 間で双方向の災害復旧ソリューションを構成する必要があります。ソリューションには何を含めるべきですか?
正解:B
Basic Concept: This question tests choosing the correct Azure migration approach by matching the source platform, target service, downtime tolerance, and administrative effort.
Why B is Correct: the Managed Instance link is part of the availability or recovery design space, but the correct choice must satisfy the specified failover, restore, quorum, RPO, or RTO requirement. In this scenario, the important constraint is: You have an Azure subscription that contains an Azure SQL managed instance named SQLM11 You need to configure a bidirectional disaster recovery solution between SQL1 and SQLMI1. the Managed Instance link satisfies that constraint without adding an unrelated service or manual process.
Why A is Wrong: Log Replay Service replays full, differential, and transaction log backups into Azure SQL Managed Instance, making it appropriate for low-downtime migrations from SQL Server. It handles a different resilience pattern and would not deliver the failover or recovery behavior required here.
Why C is Wrong: Azure Database Migration Service is the managed migration service used to move database engines to Azure targets with online or offline migration modes depending on source and target support. It does not meet the failover, restore, quorum, or cross-region continuity target stated in the question, even if it is valid in a different availability design.
Why D is Wrong: Auto-failover groups provide managed geo-replication and listener-based failover for Azure SQL Database or Managed Instance, including automatic failover policies for regional outages. It handles a different resilience pattern and would not deliver the failover or recovery behavior required here.