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

HOTSPOT

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

You have the Azure SQL databases shown in the following table.

You create a failover group named failover1 that has the following settings:

• Primary server: sqlserver1

• Secondary server: sqlserver2

• Read/Write failover policy: Automatic

• Read/Write grace period (hours): 1 hour

View Answer

Answer:

Explanation:

Box 1: Yes

DB1 is on the primary server

Box 2: No

DB3 is on the secondary server.

You can put all or several databases within an elastic pool into the same failover group.

Box 3: No

A failover group is a named group of databases managed by a single server or within a managed instance that can fail over as a unit to another region in case all or some primary databases become unavailable due to an outage in the primary region.

The secondary cannot be in the same region as the primary.