Google Professional Cloud DevOps Engineer Question 258
Select 3Google Cloud PlatformYour team manages a web application hosted on Google Cloud that is experiencing intermittent high latency issues during peak traffic hours. The application uses a managed instance group (MIG) with autoscaling, and the backend communicates with a Cloud SQL instance. After analyzing the logs, you notice that the latency spikes occur when the database query response times increase significantly. What actions should you take to address the performance and latency issues?
- A
Implement read replicas for the Cloud SQL instance to distribute the read load.
- B
Increase the maximum number of instances in the managed instance group (MIG).
- C
Enable query caching in Cloud SQL to reduce repeated query execution times.
- D
Migrate the database to a more powerful machine type to handle the increased load.
- E
Configure a global HTTP(S) load balancer to distribute traffic across multiple regions.
Show answer and explanation
Correct answers: A, C, D
Explanation
The performance and latency issues are rooted in the database query response times, so the solutions must focus on optimizing the Cloud SQL instance. Implementing read replicas, enabling query caching, and upgrading the database machine type are the most effective actions for addressing the root cause of the problem. Adjusting the MIG or adding a global load balancer addresses other concerns but does not directly resolve database performance issues.
- A. Correct.
Read replicas help reduce the load on the primary database by distributing read queries, which can significantly improve performance during peak traffic.
- B. Incorrect.
Increasing the maximum number of instances in the MIG addresses application layer scaling but does not directly resolve database latency issues caused by slow query execution.
- C. Correct.
Enabling query caching can significantly improve response times for repeated queries by avoiding redundant processing, which directly addresses database performance issues.
- D. Correct.
Migrating the database to a more powerful machine type increases its capacity to handle a higher workload and can reduce latency caused by resource constraints.
- E. Incorrect.
Configuring a global HTTP(S) load balancer improves application availability and traffic distribution across regions but does not address database query latency issues.