A continuously busy transactional database needs predictable capacity and ordinary storage latency at balanced cost. Which starting configuration best matches?

Choose the single best answer.

A.Hyperscale chosen solely for very large storage when the workload is small and capacity is predictable
B.Azure SQL Database serverless with aggressive pause as the primary saving assumption
C.Business Critical solely because every workload needs local SSD
D.Azure SQL Database General Purpose with provisioned compute

Show the answer and explanation

✓ Correct answer

Azure SQL Database General Purpose with provisioned compute

General Purpose provisioned compute fits sustained ordinary transactional load. Continuous demand defeats pause-based savings. Business Critical's low-latency architecture and Hyperscale's large-scale storage are not justified by the stated requirements; compare total cost and features before using them. 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.