- A
Add the database to an auto-failover group and use the readable secondary for reporting
Why wrong: Correct. Auto-failover groups provide a readable secondary that can be used to offload reporting queries, reducing load on the primary database.
- B
Create a database snapshot and use it for reporting
Why wrong: Incorrect. A database snapshot is a point-in-time static copy and does not reflect ongoing changes, making it unsuitable for continuous reporting offloading.
- C
Configure a geo-replica and use it for reporting
Why wrong: Incorrect. Geo-replication creates a secondary replica in a different region for disaster recovery, but it is not optimized for local read offloading and typically has higher latency.
- D
Enable read scale-out on the database by adding a secondary replica
Incorrect. While read scale-out adds a local read-only replica, it is only available on Business Critical or Hyperscale tiers and is not the default solution for all Azure SQL Databases. The question's correct answer is the auto-failover group, which is more broadly applicable.
DP-300 Auto-failover group Practice Question
This DP-300 practice question tests your understanding of plan and implement data platform resources. This is a configuration task: choose the command set that satisfies every stated requirement. Small differences — like 'secret' vs 'password' or 'transport input ssh' vs 'all' — change whether the answer is correct. A key principle to apply: auto-failover group. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.
You have an Azure SQL Database that experiences performance degradation due to high concurrency and blocking. You need to implement a solution that offloads reporting queries to a read-only copy of the database without impacting the primary workload. What should you configure?
Clue words in this question
Noticing these words before you look at the options changes how you read each choice.
Clue:
"primary"Why it matters: Asks for the main purpose or function, not a secondary benefit. Eliminate answers that describe side-effects or partial functions.
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
Enable read scale-out on the database by adding a secondary replica
Option A is correct because adding the database to an auto-failover group creates a readable secondary replica that can offload read-only reporting queries without affecting the primary. The secondary is kept in sync via asynchronous replication (or synchronous if within the same region for Premium/Business Critical tiers), providing a read-only copy suitable for reporting. This approach works across all service tiers and does not require upgrading. While read scale-out (Option D) is ideal for read offloading in Business Critical or Hyperscale tiers, auto-failover groups offer a comparable solution that is always available.
Key principle: Auto-failover group
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Add the database to an auto-failover group and use the readable secondary for reporting
Why it's wrong here
Correct. Auto-failover groups provide a readable secondary that can be used to offload reporting queries, reducing load on the primary database.
- ✗
Create a database snapshot and use it for reporting
Why it's wrong here
Incorrect. A database snapshot is a point-in-time static copy and does not reflect ongoing changes, making it unsuitable for continuous reporting offloading.
- ✗
Configure a geo-replica and use it for reporting
Why it's wrong here
Incorrect. Geo-replication creates a secondary replica in a different region for disaster recovery, but it is not optimized for local read offloading and typically has higher latency.
- ✓
Enable read scale-out on the database by adding a secondary replica
Why this is correct
Incorrect. While read scale-out adds a local read-only replica, it is only available on Business Critical or Hyperscale tiers and is not the default solution for all Azure SQL Databases. The question's correct answer is the auto-failover group, which is more broadly applicable.
Clue confirmation
The clue word "primary" in the question point toward this answer.
Related concept
Auto-failover group
Common exam traps
Common exam trap: answer the scenario, not the keyword
Candidates often confuse geo-replication (Option C) with the readable secondary in an auto-failover group. Geo-replication also provides a readable secondary but is designed for cross-region disaster recovery and typically has higher latency. Additionally, read scale-out (Option D) is only available in certain service tiers. The auto-failover group secondary is a versatile solution that provides a readable copy regardless of tier, but its latency depends on the replication mode and region configuration. The key pitfall is assuming that read scale-out is the only way to offload reads, when in fact auto-failover groups can serve that purpose effectively.
Detailed technical explanation
How to think about this question
Under the hood, Azure SQL Database uses Always On availability group technology to maintain a synchronized secondary replica. When you configure an auto-failover group, the secondary replica is automatically created in the same region (or a paired region) and exposes a read-only endpoint via the 'DatabaseName.secondary.database.windows.net' FQDN. This allows reporting queries to use snapshot isolation or read-committed snapshot isolation without blocking the primary, and the replication lag is typically sub-second, making it suitable for near-real-time analytics.
KKey Concepts to Remember
- Auto-failover group
- Readable secondary
- Asynchronous replication
TExam Day Tips
- Watch for words such as best, first, most likely and least administrative effort.
- Review why wrong options are wrong, not only why the correct option is correct.
Key takeaway
Auto-failover group
Real-world example
How this comes up in practice
A media company stores terabytes of video archives that are accessed once a year for audit purposes. Moving these objects to a cold storage tier (Azure Archive, S3 Glacier, or Google Nearline) costs a fraction of hot storage. Questions like this test whether you understand storage tiers, access frequency tradeoffs, and retrieval latency requirements.
What to study next
Got this wrong? Here's your next step.
Review auto-failover group, then practise related DP-300 questions on the same topic to reinforce the concept.
- →
Plan and implement data platform resources — study guide chapter
Learn the concepts, then practise the questions
- →
Plan and implement data platform resources practice questions
Targeted practice on this topic area only
- →
All DP-300 questions
963 questions across all exam domains
- →
Microsoft Azure Database Administrator Associate DP-300 study guide
Full concept coverage aligned to exam objectives
- →
DP-300 practice test guide
How to use practice tests most effectively before exam day
Related practice questions
Related DP-300 practice-question pages
Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.
Plan and configure a high availability and disaster recovery environment practice questions
Practise DP-300 questions linked to Plan and configure a high availability and disaster recovery environment.
Plan and implement data platform resources practice questions
Practise DP-300 questions linked to Plan and implement data platform resources.
Monitor, configure, and optimize database resources practice questions
Practise DP-300 questions linked to Monitor, configure, and optimize database resources.
Configure and manage automation of tasks practice questions
Practise DP-300 questions linked to Configure and manage automation of tasks.
Plan and configure high availability and disaster recovery practice questions
Practise DP-300 questions linked to Plan and configure high availability and disaster recovery.
Implement a secure environment practice questions
Practise DP-300 questions linked to Implement a secure environment.
DP-300 fundamentals practice questions
Practise DP-300 questions linked to DP-300 fundamentals.
DP-300 scenario practice questions
Practise DP-300 questions linked to DP-300 scenario.
DP-300 troubleshooting practice questions
Practise DP-300 questions linked to DP-300 troubleshooting.
Practice this exam
Start a free DP-300 practice session
Short sessions build daily habit. Longer sessions build exam-day stamina. Try a timed session to simulate real conditions.
FAQ
Questions learners often ask
What does this DP-300 question test?
Plan and implement data platform resources — This question tests Plan and implement data platform resources — Auto-failover group.
What is the correct answer to this question?
The correct answer is: Enable read scale-out on the database by adding a secondary replica — Option A is correct because adding the database to an auto-failover group creates a readable secondary replica that can offload read-only reporting queries without affecting the primary. The secondary is kept in sync via asynchronous replication (or synchronous if within the same region for Premium/Business Critical tiers), providing a read-only copy suitable for reporting. This approach works across all service tiers and does not require upgrading. While read scale-out (Option D) is ideal for read offloading in Business Critical or Hyperscale tiers, auto-failover groups offer a comparable solution that is always available.
What should I do if I get this DP-300 question wrong?
Review auto-failover group, then practise related DP-300 questions on the same topic to reinforce the concept.
Are there clue words in this question I should notice?
Yes — watch for: "primary". Asks for the main purpose or function, not a secondary benefit. Eliminate answers that describe side-effects or partial functions.
What is the key concept behind this question?
Auto-failover group
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
Keep practising
More DP-300 practice questions
- A DBA needs to create a new Azure SQL Database and wants to ensure that the database automatically fails over to a secon…
- A company uses Azure SQL Managed Instance for its line-of-business applications. They need to ensure that backups are re…
- Refer to the exhibit. A DBA is creating an Azure SQL Managed Instance using the ARM template snippet shown. The DBA need…
- A company is planning to migrate their on-premises SQL Server databases to Azure SQL Managed Instance. They have a datab…
- A company has an Azure SQL Database with a large table that is frequently updated. They notice performance degradation d…
- Which THREE of the following are valid options for migrating an on-premises SQL Server database to Azure SQL Database?
Last reviewed: Jun 24, 2026
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.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.