ExpertHard1 markMultiple Choice
AZ-305 · Question 17 · Domain 2.1: Relational Data Storage
A retail company is designing a new e-commerce platform. The backend relational database will be hosted on Azure SQL Database.
The database is expected to grow rapidly, reaching 40 TB within the first year. The application requires highly consistent, sub-millisecond latency for reads and writes. Additionally, the architecture must support nearly instantaneous database backups and fast restores, regardless of the database size.
Which Azure SQL Database service tier should you recommend?
A retail company is designing a new e-commerce platform. The backend relational database will be hosted on Azure SQL Database.
The database is expected to grow rapidly, reaching 40 TB within the first year. The application requires highly consistent, sub-millisecond latency for reads and writes. Additionally, the architecture must support nearly instantaneous database backups and fast restores, regardless of the database size.
Which Azure SQL Database service tier should you recommend?
Answer options:
A.
General Purpose
B.
Business Critical
C.
Hyperscale
D.
Serverless
How to approach this question
Identify the storage limits of Azure SQL tiers. Anything over 4TB-8TB requires Hyperscale. Hyperscale also provides snapshot-based instant backups.
Full Answer
C.Hyperscale✓ Correct
Hyperscale
Azure SQL Database Hyperscale is the only service tier that supports databases up to 100 TB. General Purpose and Business Critical are typically limited to 4 TB (or 8 TB depending on compute size). Furthermore, Hyperscale's architecture separates the compute engine from the storage layer. Backups are taken as storage snapshots, meaning backups and restores are nearly instantaneous and do not impact compute performance, regardless of the database size.
Common mistakes
Choosing Business Critical because of the 'sub-millisecond latency' requirement, forgetting that Business Critical cannot scale to 40 TB.
Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 5
55 questions · hints · full answers · grading
More questions from this exam
Q01Contoso Ltd has 50 subscriptions across 3 business units. Each business unit manages its own IT o...EasyQ02You are designing a monitoring solution for a hybrid environment. The environment consists of 200...MediumQ03Your company uses Microsoft Sentinel integrated with a Log Analytics workspace. The workspace ing...HardQ04You are designing an application monitoring strategy using Application Insights. The application ...MediumQ05A highly regulated financial institution is migrating to Microsoft 365 and Azure. They currently ...Hard