DP-900 Practice Question: Identify considerations for relational data on Azure
A company uses Azure SQL Database for its e-commerce platform. The reporting team runs complex, long-running queries that join multiple tables and would degrade performance of the transactional workload if executed on the primary database. Which Azure SQL Database feature should the company enable to isolate the reporting queries while ensuring read-only access to the most current data?
⚠ Common exam trap
Test-takers frequently confuse Geo-replication (which also provides readable secondaries) with read scale-out, but Geo-replication is primarily for disaster recovery and involves asynchronous replication, whereas read scale-out is designed for read workload isolation within the same region with synchronous consistency.
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-only replicas)
Read scale-out (read-only replicas) allows you to offload reporting queries to a read-only replica of the Azure SQL Database, ensuring that complex, long-running queries do not degrade the performance of the primary transactional workload. The replica provides access to the most current data because it uses snapshot isolation and is transactionally consistent with the primary database.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Automatic tuning
Why it's wrong here
Automatic tuning continuously monitors query execution and uses machine learning to force query plans, recommend indexes, or drop unused indexes; those actions improve the performance of queries that run on the same primary database. It never provisions a separate read-only replica, so the read workload is not redirected to another compute/storage instance. Automatic tuning reduces the impact of inefficient queries but does not offload read workload to a replica.
When this WOULD be correct
A company experiences performance degradation due to suboptimal query plans and wants Azure to automatically identify and fix performance issues without manual intervention. In that scenario, enabling automatic tuning would be the correct answer.
- ✗
Geo-replication
Why it's wrong here
Geo-replication asynchronously copies the database to a secondary server in a different Azure region, and that secondary can be read to support geographically distributed applications or disaster recovery. It is not intended to provide a low-latency, same-region read replica for this e-commerce platform's reporting workload. A geo-secondary is primarily a failover target, and read traffic directed there crosses regions and may be stale by seconds or minutes.
When this WOULD be correct
A company needs to ensure business continuity and disaster recovery for its Azure SQL Database, with the ability to fail over to a secondary region in case of an outage. The question would specify a requirement for cross-region read-only access to a near-real-time copy of the database for reporting during normal operations.
- ✓
Read scale-out (read-only replicas)
Why this is correct
Azure SQL Database's read scale-out uses a built-in read-only replica in the same region as the primary; when clients set ApplicationIntent=ReadOnly, read-only queries are routed to that replica. This offloads reporting/BI/analytics queries from the primary replica, preventing them from competing for CPU, I/O, and memory with the e-commerce transaction workload. The replica is continuously updated and is intended for exactly this same-region read offload scenario.
- ✗
Elastic query
Why it's wrong here
Elastic query is an Azure SQL Database feature that lets you write a T-SQL query across multiple databases, treating them as a single logical data source. It uses external tables and data sources to federate data, but it does not introduce a second replica of any database. It therefore cannot create a read-only copy to absorb reporting load from the primary database.
When this WOULD be correct
A company has data spread across multiple Azure SQL databases in different regions and needs to run cross-database queries for consolidated reporting without moving data. Elastic query would allow querying these distributed databases as a single source.
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-out (read-only replicas)Correct answer▾
Why this is correct
Azure SQL Database's read scale-out uses a built-in read-only replica in the same region as the primary; when clients set ApplicationIntent=ReadOnly, read-only queries are routed to that replica. This offloads reporting/BI/analytics queries from the primary replica, preventing them from competing for CPU, I/O, and memory with the e-commerce transaction workload. The replica is continuously updated and is intended for exactly this same-region read offload scenario.
✗Automatic tuningWrong answer — click to see why▾
Why this is wrong here
Automatic tuning automatically adjusts query performance based on workload patterns, but it does not create a separate read-only replica to isolate reporting queries from the transactional workload.
★ When this WOULD be the correct answer
A company experiences performance degradation due to suboptimal query plans and wants Azure to automatically identify and fix performance issues without manual intervention. In that scenario, enabling automatic tuning would be the correct answer.
Why candidates choose this
Candidates may think 'tuning' implies optimizing performance for reporting queries, but they overlook that the question specifically requires isolating queries via a separate read-only replica, not just tuning the existing database.
✗Geo-replicationWrong answer — click to see why▾
Why this is wrong here
Geo-replication provides disaster recovery and read-only access to a secondary replica in a different region, but it does not guarantee the most current data due to asynchronous replication lag, and it is not designed for offloading reporting queries within the same region.
★ When this WOULD be the correct answer
A company needs to ensure business continuity and disaster recovery for its Azure SQL Database, with the ability to fail over to a secondary region in case of an outage. The question would specify a requirement for cross-region read-only access to a near-real-time copy of the database for reporting during normal operations.
Why candidates choose this
Candidates may confuse geo-replication's read-only secondary with read scale-out replicas, assuming both provide read-only access to current data for reporting, without understanding the synchronous vs. asynchronous replication and regional scope differences.
✗Elastic queryWrong answer — click to see why▾
Why this is wrong here
Elastic query enables querying across multiple Azure SQL databases, but it does not provide isolated read-only replicas for offloading reporting workloads from the primary database.
★ When this WOULD be the correct answer
A company has data spread across multiple Azure SQL databases in different regions and needs to run cross-database queries for consolidated reporting without moving data. Elastic query would allow querying these distributed databases as a single source.
Why candidates choose this
Candidates may confuse 'elastic' with scalability or offloading, and think it can distribute query load, but it is designed for cross-database queries, not read-only replicas.
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
Learn chapter
Data Roles and Core Concepts
Key term
Azure SQL Database
Azure SQL Database is a fully managed relational database-as-a-service (DBaaS) in Microsoft Azure, based on the SQL Server engine, that handles scaling, backups, patching, and high availability automatically.
Key term
Data
Data is raw, unprocessed information, like numbers, words, or measurements, that can be stored, processed, and analyzed by computers.
About these practice questions
One of 820 original DP-900 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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.