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.
{
  "properties": {
    "partnerServers": [
      {
        "id": "/subscriptions/.../resourceGroups/rg1/providers/Microsoft.Sql/servers/server2"
      }
    ],
    "readWriteEndpoint": {
      "failoverPolicy": "Automatic",
      "failoverGracePeriod": 60
    },
    "readOnlyEndpoint": {
      "failoverPolicy": "Disabled"
    },
    "databases": [
      "/subscriptions/.../resourceGroups/rg1/providers/Microsoft.Sql/servers/server1/databases/db1"
    ]
  }
}

You have configured a failover group using the JSON template shown. The primary server is server1 in East US, and the secondary server is server2 in West US. During a test, you notice that read-only queries against the secondary endpoint are failing. What is the most likely cause?

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 failover policy is disabled.

The read-only endpoint failover policy is set to Disabled, which prevents read-only queries from being routed to the secondary endpoint. Option B is incorrect because the database is included in the failover group databases list. Option C is incorrect because the failover grace period only affects automatic failover, not read-only routing. Option D is incorrect because the read-write endpoint failover policy is Automatic, which is not related to the read-only query failure.

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-only endpoint failover policy is disabled.
Why this is correct
Disabled policy prevents read-only routing to secondary.
✗
The database is not included in the failover group databases list.
Why it's wrong here
It is included.
✗
The failover grace period is set too high.
Why it's wrong here
Grace period doesn't affect read-only routing.
✗
The read-write endpoint failover policy is set to Automatic.
Why it's wrong here
That is for read-write, not read-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