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

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

Exhibit

{
  "properties": {
    "partnerServers": [
      {
        "id": "/subscriptions/.../resourceGroups/rg2/providers/Microsoft.Sql/managedInstances/mi2",
        "location": "westus",
        "replicationRole": "Secondary"
      }
    ],
    "readWriteEndpoint": {
      "failoverPolicy": "Automatic",
      "failoverWithDataLossGracePeriodMinutes": 60
    },
    "readOnlyEndpoint": {
      "failoverPolicy": "Disabled"
    }
  }
}

Refer to the exhibit. You are reviewing the configuration of a failover group for an Azure SQL Managed Instance. Which statement is correct about this configuration?

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 read-only endpoint will not automatically redirect connections after failover.

The read-only endpoint's failover policy is set to Disabled, meaning it will not automatically redirect connections after a failover. Option A is incorrect because the read-write endpoint has its failover policy set to Automatic, so it will redirect connections automatically. Option C is incorrect because the grace period for data loss is set to 1 hour (3600 seconds), but the statement says 'more than 60 minutes' which is not exactly accurate; also the primary focus is on the endpoint behavior. Option D is incorrect because the read-only endpoint is used for read-only connections, not read-write.

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 read-write endpoint will not automatically redirect connections after failover.
Why it's wrong here
The readWriteEndpoint failoverPolicy is Automatic.
✓
The read-only endpoint will not automatically redirect connections after failover.
Why this is correct
The readOnlyEndpoint failoverPolicy is Disabled.
✗
The failover group will automatically fail over with data loss if the primary is unavailable for more than 60 minutes.
Why it's wrong here
While automatic failover is enabled, the grace period allows data loss; but the read-only endpoint is disabled.
✗
The read-only endpoint is used for read-write connections after failover.
Why it's wrong here
The read-only endpoint is for read-only connections only.

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