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
Refer to the exhibit.
```
{
"sku": {
"name": "BusinessCritical",
"tier": "BusinessCritical",
"family": "Gen5",
"capacity": 8
},
"properties": {
"zoneRedundant": true,
"highAvailabilityReplicaCount": 2,
"readScale": "Enabled"
}
}
```You are deploying an Azure SQL Database with the above ARM template snippet. How many readable replicas will be available for read-only queries?
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
✓
2
(2). The highAvailabilityReplicaCount property in the ARM template is set to 2, which creates two readable replicas in addition to the primary. With read scale-out enabled, both replicas are available for read-only queries. Option A (3) is incorrect because it counts the primary as a readable replica, but the primary is not used for read-only queries in read scale-out. Option C (1) is incorrect because it underestimates the number of replicas. Option D (4) is incorrect because the value in the template is 2, not 4.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
3
Why it's wrong here
(3) is incorrect because it counts the primary as a readable replica, but the primary is not used for read-only queries in read scale-out. The highAvailabilityReplicaCount is set to 2, so only 2 readable replicas are created.
- ✓
2
Why this is correct
(2) is correct. The highAvailabilityReplicaCount property in the ARM template is set to 2, which creates two readable secondary replicas. With read scale-out enabled, both are available for read-only queries. This is not related to failover groups; it is about Hyperscale read scale-out.
- ✗
1
Why it's wrong here
(1) is incorrect because it underestimates the number of replicas. The template specifies 2 replicas.
- ✗
4
Why it's wrong here
(4) is incorrect because the value in the template is 2, not 4.
Go deeper
Related to this question
Learn chapter
Overview of Azure Data Platform Options
Key term
Azure SQL Performance Tuning
Azure SQL Performance Tuning is the process of optimizing the speed and efficiency of queries and database operations in Microsoft Azure SQL Database or SQL Managed Instance to reduce latency and improve throughput.
About these practice questions
Courseiva writes every DP-300 question from scratch — 906 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DP-300 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-300 exam.