Question 120 of 267 from exam AZ-303: Microsoft Azure Architect Technologies
Question
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
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanations
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.
https://docs.microsoft.com/en-us/azure/azure-sql/database/auto-failover-group-overview