A SQL transactional application has measured storage I/O latency problems and needs eligible read-only replica offload. Cost is secondary. Which tier is the strongest starting point?

Choose the single best answer.

A.DTU Basic
B.Azure SQL Database Business Critical
C.General Purpose serverless with a low compute maximum, assuming pause behavior supplies a low-latency reporting replica
D.General Purpose solely because adding memory always removes storage latency

Show the answer and explanation

✓ Correct answer

Azure SQL Database Business Critical

Business Critical uses local SSD and multiple replicas with supported read scale. Basic targets a different performance class. General Purpose remote storage and extra memory do not automatically resolve measured latency. Serverless pause/compute settings do not create the Business Critical read-scale architecture. Source guide: PDF page 23.

Read the source reference

This item is flagged for content review.

Read and review here, or open the app to practise and save your results on this device.

Practise in the app

Unofficial study aid; not affiliated with or endorsed by Microsoft. Original practice questions are not real examination questions and do not guarantee an exam result.