オンプレミスのMicrosoft SQL Server 2022インスタンス(SQL1)があります。Azureサブスクリプションには、Azure SQL Managed Instance(SQLMI1)が含まれています。SQL1とSQLMHの間で双方向のディザスターリカバリーソリューションを構成する必要があります。ソリューションには何を含めるべきですか?
正解: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. This fits the case because the requested outcome is: You need to configure a bidirectional disaster recovery solution between SQL1 and SQLMH. The selected feature addresses that outcome directly rather than relying on a workaround.
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 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 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 is not wrong technology in general, but it is the wrong HA/DR control for this scenario ' s failure model.
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 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.