VM1 と VM2 という名前の Azure Virtual Machines 上の SQL Server の 2 つのインスタンスを含む Azure サブスクリプションがあります。どちらのインスタンスも Microsoft SQL Server 2019 CU8 を実行します。フェールオーバー クラスター インスタンス (FCI) を VM1 と VM2 にデプロイする必要があります。ソリューションでは、次の必要性を排除する必要があります。
* 分散ネットワーク名 (DNN)
* ロードバランサー
あなたは何をするべきか?
正解:D
Basic Concept: This question tests high availability and disaster recovery design for Azure SQL, SQL Server on Azure VMs, and regional failure scenarios.
Why D is Correct: Connect VM1 and VM2 to different subnets on a single virtual network. is correct because it is the feature whose normal purpose matches the stated requirement. Connect VM1 and VM2 to different subnets on a single virtual network. is part of the availability or recovery design space, but the correct choice must satisfy the specified failover, restore, quorum, RPO, or RTO requirement. The scenario wording points to that specific behavior: You need to deploy a failover cluster instance (FCI) to VM1 and VM2.
Why A is Wrong: Deploy VM1 and VM2 to a single proximity placement group. is part of the availability or recovery design space, but the correct choice must satisfy the specified failover, restore, quorum, RPO, or RTO requirement. It handles a different resilience pattern and would not deliver the failover or recovery behavior required here.
Why B is Wrong: Deploy VM1 and VM2 to different proximity placement groups in the same Azure region.
is part of the availability or recovery design space, but the correct choice must satisfy the specified failover, restore, quorum, RPO, or RTO requirement. It is not wrong technology in general, but it is the wrong HA/DR control for this scenario ' s failure model.
Why C is Wrong: Connect VM1 and VM2 to a single subnet. is part of the availability or recovery design space, but the correct choice must satisfy the specified failover, restore, quorum, RPO, or RTO requirement. 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.