DP-900 Practice Question: Identify considerations for relational data on Azure
A global e-commerce company uses Azure SQL Database for its product catalog. The application experiences high read traffic for product detail pages, often running the same queries for popular items. The database’s write workload is moderate. The company wants to improve read performance without increasing the cost of the primary database tier and without changing the application code. Which Azure SQL Database feature should they implement?
⚠ Common exam trap
Test-takers frequently confuse Active geo-replication with read scale-out, assuming geo-replication can also offload reads, but geo-replication requires explicit connection string changes and does not provide automatic read routing like read scale-out does.
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
✓
Read scale-out
Read scale-out (A) is correct because it offloads read-only queries to a secondary replica of the Azure SQL Database without changing the application code. By setting `ApplicationIntent=ReadOnly` in the connection string, the database routes read queries to a read-only replica, improving performance for high-read workloads like product detail pages while keeping the primary tier unchanged and avoiding additional cost for a higher tier.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Read scale-out
Why this is correct
Read scale-out is correct because Azure SQL Database automatically provisions a read-only replica in the Premium, Business Critical, or Hyperscale service tiers, and you can route reporting queries to that replica by adding `ApplicationIntent=ReadOnly` to the connection string. This offloads read-only workloads from the primary replica, preserving its performance for OLTP traffic, and it operates within the same region as the primary. This is the simplest architectural solution because it requires no separate database, manual copying, or cross-region setup—just a connection string change to enable read-only routing.
- ✗
Active geo-replication
Why it's wrong here
Incorrect. Active geo-replication provides readable secondary replicas in different regions for disaster recovery, but it is primarily for high availability and can incur higher cost. It is not the simplest solution for offloading reads within the same region.
When this WOULD be correct
A company needs to ensure business continuity and disaster recovery across Azure regions, with the ability to fail over to a secondary database in another region in case of an outage. The question would specify a requirement for high availability and regional redundancy.
- ✗
Azure SQL Database elastic pool
Why it's wrong here
An Azure SQL Database elastic pool is a resource-sharing and cost-management construct that allows multiple single databases to share a fixed set of eDTUs or vCores, so databases can absorb usage spikes without individually over-provisioning. It does not create any read-only replica or secondary copy of a database; it merely multiplexes compute and storage resources across databases. Therefore, it cannot offload reporting queries away from any single database's primary replica, making it irrelevant to the goal of isolating read traffic in this scenario.
When this WOULD be correct
A company has multiple Azure SQL databases with varying and unpredictable usage patterns, and wants to optimize cost while ensuring each database gets resources when needed, without changing the application code.
- ✗
Query Performance Insight
Why it's wrong here
Query Performance Insight is an Azure SQL Database diagnostic tool that tracks query-level metrics such as CPU, duration, execution count, and waits, and it recommends index changes or query tuning to reduce resource consumption. It is purely observability and analytics—it does not create replicas, alter connection routing, or shift any read workload away from the primary replica. While it can help you identify which queries to tune, it cannot by itself offload any read traffic, so it fails the requirement of reducing load on the primary.
When this WOULD be correct
A company wants to identify the most resource-intensive and frequently run queries in their Azure SQL Database to optimize performance. They need a tool that provides query-level metrics, wait statistics, and recommendations for indexing or query tuning.
Option-by-option analysis
Why each answer is right or wrong
Understanding why wrong answers are wrong — and when they would be correct — is what separates a 750 score from a 900. The DP-900 exam frequently reuses these exact scenarios with slightly different constraints.
✓Read scale-outCorrect answer▾
Why this is correct
Read scale-out is correct because Azure SQL Database automatically provisions a read-only replica in the Premium, Business Critical, or Hyperscale service tiers, and you can route reporting queries to that replica by adding `ApplicationIntent=ReadOnly` to the connection string. This offloads read-only workloads from the primary replica, preserving its performance for OLTP traffic, and it operates within the same region as the primary. This is the simplest architectural solution because it requires no separate database, manual copying, or cross-region setup—just a connection string change to enable read-only routing.
✗Active geo-replicationWrong answer — click to see why▾
Why this is wrong here
Active geo-replication is designed for disaster recovery and regional failover, not for offloading read-only queries to a secondary replica. It does not improve read performance for the same queries without changing application code.
★ When this WOULD be the correct answer
A company needs to ensure business continuity and disaster recovery across Azure regions, with the ability to fail over to a secondary database in another region in case of an outage. The question would specify a requirement for high availability and regional redundancy.
Why candidates choose this
Candidates may confuse 'read scale-out' with 'geo-replication' because both involve replicas, but geo-replication's primary purpose is disaster recovery, not read performance improvement.
✗Azure SQL Database elastic poolWrong answer — click to see why▾
Why this is wrong here
Elastic pools are designed to manage and share resources among multiple databases to optimize cost, not to improve read performance for a single database without increasing its tier.
★ When this WOULD be the correct answer
A company has multiple Azure SQL databases with varying and unpredictable usage patterns, and wants to optimize cost while ensuring each database gets resources when needed, without changing the application code.
Why candidates choose this
Candidates may confuse elastic pools with a performance-boosting feature because pools can provide more resources to databases, but they don't specifically address read-heavy workloads on a single database.
✗Query Performance InsightWrong answer — click to see why▾
Why this is wrong here
Query Performance Insight is a diagnostic tool for analyzing query performance, not a feature to improve read performance. It does not offload read traffic or reduce load on the primary database.
★ When this WOULD be the correct answer
A company wants to identify the most resource-intensive and frequently run queries in their Azure SQL Database to optimize performance. They need a tool that provides query-level metrics, wait statistics, and recommendations for indexing or query tuning.
Why candidates choose this
Candidates may confuse performance monitoring with performance improvement, thinking that analyzing queries will directly speed up reads, but it only provides insights without automatically enhancing throughput.
Analysis generated from the official DP-900blueprint and verified against question context. The “when correct” sections are what AI assistants cite when candidates ask “what’s the difference between these options?”
Go deeper
Related to this question
About these practice questions
This DP-900 question is part of Courseiva's 820-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam 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-900 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-900 exam.