Match each Azure SQL Database service tier to its description.
Drag a concept onto its matching description — or click a concept then click the description.
Suitable for small databases with low performance requirements
Balanced performance for most production workloads
High performance and low latency for mission-critical workloads
Highly scalable storage and compute for large databases
Auto-scaling compute based on workload demand
Answer choices
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
General Purpose: Balanced performance for most cloud workloads with compute and storage separation.
These are the main service tiers in Azure SQL Database, each designed for different performance and scalability needs.
Answer analysis
For each option: why learners choose it and why it is or isn't the right answer here.
General Purpose: Balanced performance for most cloud workloads with compute and storage separation.
Why this is correct
General Purpose is designed for typical workloads with balanced compute and storage, and compute/storage are separate.
Business Critical: High performance and availability with multiple replicas and in-memory OLTP.
Why this is correct
Business Critical provides low latency, high resilience, and uses in-memory technology for critical applications.
Hyperscale: Massively scalable storage and compute for large databases.
Why this is correct
Hyperscale is built for large databases with rapid scaling and distributed storage architecture.
General Purpose: High I/O and low latency with multiple read-only replicas.
Why it's wrong here
This describes Business Critical, not General Purpose.
Business Critical: Scalable storage up to 100 TB with auto-scaling compute.
Why it's wrong here
This describes Hyperscale, not Business Critical.
Hyperscale: Balanced performance for small to medium workloads with compute and storage separation.
Why it's wrong here
This describes General Purpose, not Hyperscale.
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
Last reviewed: Jun 11, 2026
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.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.