Google Cloud Professional Cloud Database Engineer — Question 7

You are managing multiple applications connecting to a database on Cloud SQL for PostgreSQL. You need to be able to monitor database performance to easily identify applications with long-running and resource-intensive queries. What should you do?

Answer options

• A. Use log messages produced by Cloud SQL.
• B. Use Query Insights for Cloud SQL.
• C. Use the Cloud Monitoring dashboard with available metrics from Cloud SQL.
• D. Use Cloud SQL instance monitoring in the Google Cloud Console.

Correct answer: B

Explanation

The correct choice is B, as Query Insights for Cloud SQL provides detailed analytics on query performance, allowing you to identify long-running and resource-intensive queries effectively. The other options, while useful for monitoring, do not offer the same level of targeted insights specifically for query performance analysis.