DP-900 Practice Question: Identify considerations for relational data on Azure
A company is migrating a 500 GB financial database to Azure. The database requires low read/write latency, supports a high number of concurrent transactions, and must have a Recovery Point Objective (RPO) of less than 5 seconds and a Recovery Time Objective (RTO) of less than 30 minutes. The company is willing to pay more for these guarantees. Which Azure SQL Database service tier should they choose?
⚠ Common exam trap
Many candidates choose Hyperscale because it supports large databases and fast scaling, but they overlook that its RPO is not as tight as Business Critical's synchronous replication, and its read/write latency can be higher due to the page server architecture.
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
✓
Business Critical
Business Critical is the correct choice because it provides the lowest read/write latency through always-on secondary replicas and uses local SSD storage, which is essential for high-concurrency transactional workloads. It also guarantees an RPO of less than 5 seconds via synchronous data replication and an RTO of under 30 minutes, meeting the strict recovery requirements.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
General Purpose
Why it's wrong here
General Purpose isolates compute from storage by placing database files on Azure Premium Storage and replicating them asynchronously rather than maintaining synchronous database replicas. If the primary compute node fails, the failover process reattaches that remote storage to a new compute instance, but committed transactions that had not yet been flushed to the replicated blob can be lost, yielding an RPO of up to one hour. Therefore, even a 500 GB database that fits comfortably in this tier cannot meet a sub-5-second RPO and is the wrong choice for a financial workload.
When this WOULD be correct
A company migrating a 500 GB database that requires cost-effective storage with acceptable latency for most workloads, an RPO of up to 10 seconds, and an RTO of up to 12 hours, and does not need the highest performance or availability guarantees.
- ✓
Business Critical
Why this is correct
Business Critical provides a local, synchronous Always On Availability Group replica set within the cluster, so every committed transaction is acknowledged on multiple replicas before commit, giving an RPO near zero (SLA of less than 5 seconds) and automatic failover typically around 30 minutes. For a 500 GB financial database, the tier's SSD-backed local storage and high IOPS also minimize latency during normal operations. This combination is exactly why it satisfies the stated RPO/RTO requirements.
- ✗
Hyperscale
Why it's wrong here
Hyperscale is designed for databases larger than 4 TB and offers fast scaling but has a slightly higher RPO (typically up to 1 minute) and is not primarily focused on the aggressive RPO/RTO needed here.
When this WOULD be correct
A company needs to migrate a 10 TB database with high scalability requirements and can tolerate an RPO of up to 5 minutes and an RTO of up to 10 minutes. They prioritize storage size and read scale-out over the lowest possible RPO/RTO.
- ✗
Serverless (General Purpose)
Why it's wrong here
Serverless is a compute deployment model inside the General Purpose tier that automatically scales CPU and memory up or down and can pause the compute when idle; it does not alter the underlying high-availability or data-replication design. Because it inherits General Purpose's remote, asynchronously replicated storage and its failover behavior, the RPO remains up to one hour and RTO is not improved to a 30-minute target. Auto-pause can also add cold-start delays for the first connection, but the bigger issue is that no service tier adjustment is made, so the financial database would still fail the RPO requirement.
When this WOULD be correct
A company is migrating a small, intermittent-use database (e.g., a development or reporting database) that can tolerate up to 1-hour data loss and 1-hour recovery time, and wants to minimize costs by paying only for active compute.
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.
✓Business CriticalCorrect answer▾
Why this is correct
Business Critical provides a local, synchronous Always On Availability Group replica set within the cluster, so every committed transaction is acknowledged on multiple replicas before commit, giving an RPO near zero (SLA of less than 5 seconds) and automatic failover typically around 30 minutes. For a 500 GB financial database, the tier's SSD-backed local storage and high IOPS also minimize latency during normal operations. This combination is exactly why it satisfies the stated RPO/RTO requirements.
✗General PurposeWrong answer — click to see why▾
Why this is wrong here
General Purpose tier has higher read/write latency and an RPO of up to 10 seconds, which does not meet the requirement of less than 5 seconds RPO and low latency for high concurrency.
★ When this WOULD be the correct answer
A company migrating a 500 GB database that requires cost-effective storage with acceptable latency for most workloads, an RPO of up to 10 seconds, and an RTO of up to 12 hours, and does not need the highest performance or availability guarantees.
Why candidates choose this
Candidates may assume General Purpose is sufficient for most databases and overlook the strict latency and RPO requirements, or they may not fully understand the performance differences between service tiers.
✗HyperscaleWrong answer — click to see why▾
Why this is wrong here
Hyperscale is designed for large databases (up to 100 TB) and high scalability, but its RPO is up to 5 minutes and RTO is up to 10 minutes, which does not meet the requirement of RPO < 5 seconds and RTO < 30 minutes.
★ When this WOULD be the correct answer
A company needs to migrate a 10 TB database with high scalability requirements and can tolerate an RPO of up to 5 minutes and an RTO of up to 10 minutes. They prioritize storage size and read scale-out over the lowest possible RPO/RTO.
Why candidates choose this
Candidates may assume Hyperscale offers the best performance for large databases, overlooking that Business Critical provides lower latency and faster recovery due to its in-memory technologies and synchronous replicas.
✗Serverless (General Purpose)Wrong answer — click to see why▾
Why this is wrong here
Serverless (General Purpose) does not guarantee an RPO of less than 5 seconds or an RTO of less than 30 minutes; it offers up to 1-hour RPO and auto-pause delays that conflict with low-latency, high-concurrency requirements.
★ When this WOULD be the correct answer
A company is migrating a small, intermittent-use database (e.g., a development or reporting database) that can tolerate up to 1-hour data loss and 1-hour recovery time, and wants to minimize costs by paying only for active compute.
Why candidates choose this
Candidates may think 'serverless' implies high availability and low latency, or they confuse the cost-saving auto-scaling feature with performance guarantees, overlooking the strict RPO/RTO and concurrency needs.
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.