Google Cloud Associate Data Practitioner — Question 31

You manage a web application that stores data in a Cloud SQL database. You need to improve the read performance of the application by offloading read traffic from the primary database instance. You want to implement a solution that minimizes effort and cost. What should you do?

Answer options

• A. Use Cloud CDN to cache frequently accessed data.
• B. Store frequently accessed data in a Memorystore instance.
• C. Migrate the database to a larger Cloud SQL instance.
• D. Enable automatic backups, and create a read replica of the Cloud SQL instance.

Correct answer: D

Explanation

The correct answer is D because creating a read replica allows you to offload read traffic from the primary instance, improving performance without significant effort or cost. Options A and B do not specifically address the need to offload read traffic from the primary database, while C would increase costs without necessarily improving read performance.