DP-300: Administering Microsoft Azure SQL Solutions

By Microsoft · Question Mode

QuestionQ26

Plan and configure a high availability and disaster recovery (HA/DR) environment

You have an Azure subscription.

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

  • Minimize the time required for failover.
  • Preserve existing connections to the primary replica during failover.

What should you do?

Explanation

Deploying the SQL Server virtual machines in separate subnets within the same virtual network removes the availability group's dependency on an Azure Load Balancer for listener routing. Avoiding load-balancer health-probe detection reduces failover delay and provides the appropriate multi-subnet listener configuration for the replicas.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!