StudyByteLearn
← AZ-305: Azure Infrastructure Solutions
AZ-305 · Relational data

Practice question 115 of 400 · medium

A serverless SQL database has almost no user CPU activity but never pauses. It has active geo-replication and persistent open sessions. What best explains the behavior?

Choose the single best answer.

  1. A.Geo-replication always pauses both replicas together without restriction
  2. B.The vCore purchasing model disables every autoscaling capability
  3. C.Both the geographic replication feature and open sessions can prevent auto-pause
  4. D.Auto-pause must occur whenever CPU is near zero, so the platform is necessarily faulty
Show the answer and explanation

✓ Correct answer

  • Both the geographic replication feature and open sessions can prevent auto-pause

Auto-pause has feature and session conditions, so inactivity alone is insufficient. Geo-replication is listed as preventing pause, not forcing synchronized pause. The vCore model does not categorically disable autoscaling. Source guide: PDF page 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.

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.