ExpertMedium1 markMultiple Choice
AZ-305 · Question 17 · Domain 2.1: Relational Data Storage
An e-commerce company is designing the database architecture for their new product catalog.
The database is expected to grow rapidly and may exceed 50 TB within the first year. The application requires extremely fast storage scaling and the ability to nearly instantaneously scale out read workloads to multiple compute nodes during holiday sales.
Which Azure SQL Database service tier should you recommend?
An e-commerce company is designing the database architecture for their new product catalog.
The database is expected to grow rapidly and may exceed 50 TB within the first year. The application requires extremely fast storage scaling and the ability to nearly instantaneously scale out read workloads to multiple compute nodes during holiday sales.
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 limit constraint (>50 TB) and match it to the only Azure SQL tier that supports it.
Full Answer
C.Hyperscale✓ Correct
Hyperscale
The Hyperscale service tier in Azure SQL Database is designed for very large databases. It separates the compute and storage layers, allowing storage to scale up to 100 TB. It also supports rapid scale-up of compute and the addition of up to four high-availability replicas that can be used for read scale-out.
Common mistakes
Selecting Business Critical because of the 'fast storage' requirement, failing to realize it has a strict 4 TB storage limit.
Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 3
55 questions · hints · full answers · grading
More questions from this exam
Q01Contoso Ltd is a global manufacturing company with 50,000 employees across 30 countries. They cur...MediumQ02Fabrikam Inc. is a Managed Service Provider (MSP) managing Azure environments for 50 different en...HardQ03A financial institution generates 5 TB of telemetry and audit logs daily across its Azure environ...MediumQ04A retail company has recently migrated several workloads to Azure. The IT Director wants a centra...EasyQ05A healthcare organization with 10,000 employees uses on-premises Active Directory. They are migra...Hard