Administering Relational Databases on Microsoft Azure — Question 39

You have an Azure subscription.

You need to deploy two instances of SQL Server on Azure virtual machines in a highly available configuration that will use an Always On availability group. The solution must meet the following requirements:

• Minimize how long it takes to fail over.
• Maintain existing connections to the primary replica during a failover.

What should you do?

Answer options

• A. Connect each virtual machine to a different subnet on a virtual network. Deploy a basic Azure load balancer.
• B. Connect each virtual machine to a different subnet on a single virtual network.
• C. Connect each virtual machine to a single subnet on a single virtual network.
• D. Connect each virtual machine to a single subnet on a virtual network. Deploy a standard Azure load balancer.

Correct answer: C

Explanation

The correct answer is C, as connecting both virtual machines to a single subnet on a single virtual network allows for optimal communication and minimizes failover time. Option A does not provide the necessary environment for Always On availability groups, while B introduces unnecessary complexity by using separate subnets. Option D adds a standard Azure load balancer, which is not needed for maintaining connections during failover.