Which servers can be used as a secondary server?

You have three Azure SQL Database servers shown in the following table.

You plan to specify sqlserver1 as the primary server in a failover group.

Which servers can be used as a secondary server?
A . sqlserver4 and sqlserver5 only
B . sqlserver2 and sqlserver3 only
C . sqlserver1 and sqlserver3 only
D . sqlserver2 and sqlserver4 only

View Answer

Answer: D

Explanation:

The Resource Group must be the same.

The secondary server can have another location.

The secondary server cannot be the same as the primary server.

Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/auto-failover-group-configure