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

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

Exhibit

{
  "properties": {
    "databases": [
      "/subscriptions/.../databases/OrdersDB"
    ],
    "partnerServers": [
      {
        "id": "/subscriptions/.../servers/secondary-server",
        "location": "westus"
      }
    ],
    "readWriteEndpoint": {
      "failoverPolicy": "Automatic",
      "failoverGracePeriodMinutes": 60
    },
    "readOnlyEndpoint": {
      "failoverPolicy": "Disabled"
    }
  },
  "type": "Microsoft.Sql/servers/failoverGroups"
}

Refer to the exhibit. You have an Azure SQL Database failover group configured with the ARM template snippet shown. You need to ensure that read-only queries are routed to the secondary region when the primary is healthy. What should you modify?

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

✓

Set the readOnlyEndpoint failoverPolicy to Enabled.

The readOnlyEndpoint failoverPolicy must be set to Enabled to route read-only queries to the secondary region when the primary is healthy. Option A is incorrect because the readWriteEndpoint failoverPolicy being Manual does not affect read-only routing; it controls failover initiation. Option C is incorrect because adding databases to the partnerServers array is unrelated to read-only routing. Option D is incorrect because changing the failoverGracePeriodMinutes to 0 does not enable read-only endpoint routing.

Answer analysis

Option-by-option breakdown

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

✗
Set the readWriteEndpoint failoverPolicy to Manual.
Why it's wrong here
This changes failover behavior, not read-only routing.
✓
Set the readOnlyEndpoint failoverPolicy to Enabled.
Why this is correct
Enabling the read-only endpoint allows routing read-only queries to the secondary.
✗
Add the database to the partnerServers array.
Why it's wrong here
Databases are already specified in the databases array.
✗
Change the failoverGracePeriodMinutes to 0.
Why it's wrong here
This affects automatic failover timing, not read-only routing.

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