An intermittent development SQL workload can tolerate resume delay, but must minimize idle compute. Which design considerations are correct? Select 2 answers.

Select all that apply. Every correct option and no extras are required for credit in the app.

A.Assume autoscaling automatically guarantees no billed idle compute
B.Evaluate serverless with suitable minimum/maximum compute and eligible auto-pause
C.Expect an open connection pool never to affect pausing
D.Budget storage costs even while compute is paused

Show the answer and explanation

✓ Correct answers

Evaluate serverless with suitable minimum/maximum compute and eligible auto-pause
Budget storage costs even while compute is paused

Serverless and eligible pause can fit intermittent use, but storage remains billed. Open sessions can prevent pause. Autoscaling changes online capacity and does not by itself eliminate idle compute charges. Source guide: PDF page 23-24.

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.