Google Cloud Professional Cloud Database Engineer — Question 164

Your application uses a Cloud SQL for MySQL instance. Recently, you have noticed performance degradation during peak hours, leading to slow response times and frustrated users. You suspect that inefficient queries might be contributing to these issues. You want to pinpoint and analyze these problematic queries and pass them to the application team for optimizations. What should you do?

Answer options

• A. Use the underprovisioned instance recommender.
• B. Increase the Cloud SQL instance read_buffer_size flag.
• C. Enable and use Query Insights.
• D. Create a Cloud Monitoring alert based on the database/mysql/queries metric.

Correct answer: C

Explanation

The correct answer is C, as Query Insights provides detailed analysis and monitoring of query performance, allowing you to identify inefficient queries directly. Options A and B may help with performance but won't specifically target query inefficiencies. Option D can alert you to issues but does not provide the deep insights needed to analyze and optimize the queries themselves.