Plan and configure a high availability and disaster recovery environment →hardMultiple ChoiceObjective-mapped

DP-300 Practice Question: Plan and configure a high availability and disaster recovery environment

Exhibit

Refer to the exhibit.

```json
{
  "properties": {
    "databases": ["/subscriptions/.../databases/db1"],
    "partnerServers": [
      {
        "id": "/subscriptions/.../servers/secondary",
        "location": "westeurope"
      }
    ],
    "readWriteEndpoint": {
      "failoverPolicy": "Automatic",
      "failoverGracePeriodMinutes": 60
    },
    "readOnlyEndpoint": {
      "failoverPolicy": "Disabled"
    }
  }
}
```

You are reviewing the ARM template snippet for an Azure SQL Database failover group. The primary server is in East US. The secondary is in West Europe. The readWriteEndpoint has automatic failover with a grace period of 60 minutes. The readOnlyEndpoint is disabled. After a complete outage in East US, what will happen?

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

✓

The failover group will wait 60 minutes, then automatically fail over to West Europe.

With automatic failover policy and a grace period, the system will wait for 60 minutes before automatically failing over to West Europe. The read-only endpoint is disabled, so no read-only routing is available. Option A is incorrect because the grace period is 60 minutes, not zero. Option C is incorrect because automatic failover is enabled. Option D is incorrect because the failover will happen within 60 minutes, not immediately.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

✗
The failover group will not fail over automatically because the grace period is too long.
Why it's wrong here
It will fail over after 60 minutes.
✓
The failover group will wait 60 minutes, then automatically fail over to West Europe.
Why this is correct
Correct.
✗
The failover group will immediately fail over to West Europe.
Why it's wrong here
Grace period of 60 minutes applies.
✗
The failover group requires manual failover because readOnlyEndpoint is disabled.
Why it's wrong here
Automatic failover is enabled.

Go deeper

DP-300 Practice Question: Plan and configure a high availability and disaster recovery environment

Exhibit

Why each option matters

Option-by-option breakdown

Related to this question