Google Cloud Professional Cloud Database Engineer — Question 130

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?

Answer options

• A. Increase the size of the read replica instance and enable HA.
• B. Enable HA on the current read replica.
• C. Create a new HA instance in the same zone as the primary.
• D. Create a new HA instance in a different region than the primary.

Correct answer: B

Explanation

The correct answer is B because enabling HA on the current read replica allows for improved availability without incurring additional costs associated with creating a new instance. Option A is incorrect as simply increasing the size of the read replica does not ensure high availability. Options C and D involve creating new HA instances, which would increase costs and are unnecessary since HA can be enabled on the existing replica.