Google Cloud Professional Cloud Database Engineer — Question 152

Your company’s rapidly growing ecommerce application uses Cloud SQL for MySQL. Performance issues are surfacing during peak traffic periods. You need to ensure that the database can handle the load while minimizing downtime. What should you do?

Answer options

• A. Use read replicas for query offloading, configure automatic failover, and test failover procedures regularly.
• B. Vertically scale the primary instance by significantly increasing compute resources, such as vCPUs and memory.
• C. Increase storage size on the existing instance and implement client-side caching for frequently accessed data.
• D. Migrate to a Cloud SQL for PostgreSQL database for better performance during high load.

Correct answer: A

Explanation

The correct answer is A because using read replicas helps distribute the query load and configuring automatic failover increases reliability during traffic spikes. Option B, while it can improve performance, does not address query load distribution or downtime. Option C may help with storage but does not effectively manage peak load scenarios. Option D suggests changing database types, which may not necessarily resolve the immediate performance issues effectively.