A PostgreSQL production database is continuously CPU-intensive and also needs supported local HA. Which starting plan is most suitable?

Choose the single best answer.

A.General Purpose or Memory Optimized flexible server sized to demand, with supported HA
B.Treat a cross-region asynchronous read replica as automatic zero-data-loss local HA
C.Burstable solely because CPU credits never run out
D.Use the synchronous HA standby as the main reporting endpoint

Show the answer and explanation

✓ Correct answer

General Purpose or Memory Optimized flexible server sized to demand, with supported HA

General Purpose/Memory Optimized suit sustained production demand and supported HA. Burstable CPU credits can constrain continuous usage. HA standby is not normal read scale; cross-region asynchronous replicas have different promotion/data-loss semantics. Source guide: PDF page 25.

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.