PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #142
PROFESSIONAL-CLOUD-DATABASE-ENGINEER Question #142: Real Exam Question with Answer & Explanation
The correct answer is D: Cloud SQL primary in one zone with same region read replica in another zone. This design keeps all traffic within the primary region so application read and write latency remains low. Placing the replica in a different zone provides resilience to zonal failures which delivers high availability. You can promote the replica quickly if the primary becomes un
Question
In Cloud SQL for MySQL, which deployment achieves high availability and disaster recovery while maintaining low read and write latency in the primary region?
Options
- ASingle zonal Cloud SQL instance
- BCloud SQL primary in one region with cross region read replica
- CAlloyDB for PostgreSQL
- DCloud SQL primary in one zone with same region read replica in another zone
Explanation
This design keeps all traffic within the primary region so application read and write latency remains low. Placing the replica in a different zone provides resilience to zonal failures which delivers high availability. You can promote the replica quickly if the primary becomes unavailable which supports disaster recovery objectives without routing data across regions. Replication is asynchronous which limits write impact on the primary and it also adds local read capacity.
Topics
Community Discussion
No community discussion yet for this question.