What should you configure before you can add the managed instances to the instance failover group?

You have two Azure SQL Database managed instances in different Azure regions.

You plan to configure the managed instances in an instance failover group.

What should you configure before you can add the managed instances to the instance failover group?
A . Azure Private Link that has endpoints on two virtual networks
B . an internal Azure Load Balancer instance that has managed instance endpoints in a backend pool
C . an Azure Application Gateway that has managed instance endpoints in a backend pool
D . a Site-to-Site VPN between the virtual networks that contain the instances

View Answer

Answer: D

Explanation:

For two managed instances to participate in a failover group, there must be either ExpressRoute or a gateway configured between the virtual networks of the two managed instances to allow network communication.

You create the two VPN gateways and connect them.

Reference: https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/failover-group-add-instance-tutorial?tabs=azure-portal#4—create-a-primary-gateway