PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #170
PROFESSIONAL-CLOUD-DATABASE-ENGINEER Question #170: Real Exam Question with Answer & Explanation
The correct answer is C: Create a new HA instance in the same zone as the primary.. Cloud SQL HA is only supported on primary instances (which are configured with a regional failover replica), not on read replicas. To give your analytics workloads HA at minimal extra cost, spin up a new Cloud SQL MySQL instance in HA mode in the same region (and therefore same z
Question
You currently have a MySQL database running on Cloud SQL with a read replica in a different zone for non-mission critical analytics workloads. You want to enable high availability (HA) for the analytic workloads while keeping costs low. What should you do-
Options
- AIncrease the size of the read replica instance and enable HA.
- BEnable HA on the current read replica.
- CCreate a new HA instance in the same zone as the primary.
- DCreate a new HA instance in a different region than the primary.
Explanation
Cloud SQL HA is only supported on primary instances (which are configured with a regional failover replica), not on read replicas. To give your analytics workloads HA at minimal extra cost, spin up a new Cloud SQL MySQL instance in HA mode in the same region (and therefore same zone locality) as your primary. This gives you automatic failover for analytics without incurring the higher networking and egress charges of a cross-region deployment.
Topics
Community Discussion
No community discussion yet for this question.