DP-300 Plan and implement data platform resources Practice Question
Which TWO benefits does the Hyperscale service tier of Azure SQL Database provide?
⚠ Common exam trap
It's easy for candidates to confuse the Hyperscale tier's storage limit with the Business Critical tier's in-memory OLTP or zone-redundancy features, leading them to select options that are technically correct for other tiers but not for Hyperscale.
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
✓
Up to 100 TB of database storage.
The Hyperscale service tier of Azure SQL Database supports up to 100 TB of database storage, which is significantly larger than the 4 TB limit of the General Purpose tier and the 4 TB limit of the Business Critical tier. This massive storage capacity is achieved through a distributed architecture where data is stored in page servers with a shared disk model, allowing near-instantaneous scaling of storage without downtime.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Built-in in-memory OLTP support.
Why it's wrong here
In-memory OLTP is not a key feature of Hyperscale.
- ✗
Zone-redundant configuration by default.
Why it's wrong here
Zone redundancy is optional, not default.
- ✓
Up to 100 TB of database storage.
Why this is correct
Hyperscale provides large storage capacity.
- ✓
Fast provisioning of additional read replicas.
Why this is correct
Hyperscale can scale out replicas quickly.
- ✗
Zero data loss in all scenarios.
Why it's wrong here
Hyperscale uses asynchronous replication.
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.