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": {
    "readScale": {
      "type": "Boolean",
      "value": "Enabled"
    },
    "zoneRedundant": {
      "type": "Boolean",
      "value": "true"
    },
    "highAvailabilityReplicaCount": {
      "type": "Integer",
      "value": 2
    }
  }
}

Refer to the exhibit. You are reviewing the JSON configuration of an Azure SQL Database in the Business Critical tier. What is the primary benefit of setting highAvailabilityReplicaCount to 2?

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

✓

It provides more read-only replicas to offload read workloads.

Setting highAvailabilityReplicaCount to 2 in Business Critical tier creates two additional readable replicas (total of 3 replicas including primary). This improves read performance by allowing more read-only connections to be offloaded to replicas. Option A (automatic failover) is inherent to Business Critical, not dependent on replica count. Option B (zone redundancy) is determined by the zoneRedundant property, not replica count. Option C (zero data loss) is achieved by synchronous replication, not replica count.

Answer analysis

Option-by-option breakdown

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

✗
It enables automatic failover in case of a node failure.
Why it's wrong here
Automatic failover is provided by the Business Critical tier regardless of replica count.
✗
It enables zone redundancy for the database.
Why it's wrong here
Zone redundancy is controlled by the zoneRedundant property.
✗
It ensures zero data loss during a failover.
Why it's wrong here
Zero data loss is achieved by synchronous replication, not replica count.
✓
It provides more read-only replicas to offload read workloads.
Why this is correct
Additional replicas increase read capacity.

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