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.
Option C is correct because the Hyperscale service tier is designed to scale storage up to 100 TB (and beyond in some configurations), far exceeding the limits of General Purpose and Business Critical tiers, which is a core benefit of its architecture that separates compute from storage. Option D is correct because Hyperscale uses a page-server and log-service architecture that allows additional read replicas to be provisioned quickly and independently of the primary compute, enabling rapid scale-out for read workloads. Option A is incorrect because built-in in-memory OLTP is a feature of the Business Critical tier, not Hyperscale. Option B is incorrect because zone-redundant configuration is not enabled by default in Hyperscale; it is an optional configuration choice. Option E is incorrect because no Azure SQL tier guarantees zero data loss in all scenarios; Hyperscale provides high durability but not an absolute zero-data-loss guarantee across every failure scenario.
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
Hyperscale's architecture separates compute from page-blob storage; in-memory OLTP is a Business Critical and Premium tier feature. It tempts because Hyperscale targets high performance, but its gains come from rapid scale-out and snapshot backups, not memory-optimised tables.
- ✗
Zone-redundant configuration by default.
Why it's wrong here
Zone redundancy is an optional configuration available across tiers, not a Hyperscale default; enabling it requires explicit selection. It tempts because Hyperscale's replicated page servers suggest inherent resilience, yet its default replicas are local, and zone redundancy would be the answer if the stem asked about configurable high availability.
- ✓
Up to 100 TB of database storage.
Why this is correct
Hyperscale's architecture separates compute from a log-based storage layer that scales to 100 TB, far exceeding the 4 TB limit of General Purpose and Business Critical. This satisfies the large-storage benefit the question asks about.
- ✓
Fast provisioning of additional read replicas.
Why this is correct
Hyperscale provisions named read replicas in minutes by attaching them to the same page servers and log service, rather than copying data. This satisfies the stem's requirement for rapid scale-out of read workloads, unlike other tiers where replica creation depends on seeding a full database copy.
- ✗
Zero data loss in all scenarios.
Why it's wrong here
Hyperscale offers no zero-data-loss guarantee in every scenario; asynchronous replication to page servers permits some loss during failover. It tempts because Business Critical's local synchronous replicas do provide that, so it would be correct if the question concerned Business Critical rather than Hyperscale.
Go deeper
Related to this question
Learn chapter
Securing Data at Rest and in Transit
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 — 574 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.