Question 1

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?

Accepted Answer

Identify the storage limits of Azure SQL tiers. Anything over 4TB-8TB requires Hyperscale. Hyperscale also provides snapshot-based instant backups.

Question 2

What mistakes do candidates make on this AZ-305 question?

Accepted Answer

Choosing Business Critical because of the 'sub-millisecond latency' requirement, forgetting that Business Critical cannot scale to 40 TB.

How to approach this question

Full Answer

Common mistakes

Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 5

More questions from this exam