Google Professional Cloud Database Engineer Question 111
Select 3Google Cloud PlatformYou are a Professional Cloud Database Engineer managing a Cloud SQL instance running PostgreSQL for a business-critical application. Recently, users have reported performance degradation during peak hours. You need to set up monitoring to identify the root cause and troubleshoot the issue. Which steps should you take to configure effective database monitoring and troubleshooting?
- A
Enable Query Insights to analyze query performance and identify slow-running queries.
- B
Use Cloud Monitoring to create custom dashboards and set up alerts for high CPU or memory usage.
- C
Enable binary logging to capture all SQL statements executed on the database instance.
- D
Enable the PostgreSQL slow query log and configure an appropriate query execution time threshold.
- E
Set up a daily export of Cloud SQL logs to BigQuery for long-term analysis and reporting.
Show answer and explanation
Correct answers: A, B, D
Explanation
To effectively monitor and troubleshoot performance issues in a Cloud SQL instance, it is essential to use tools like Query Insights for query analysis, Cloud Monitoring for resource utilization metrics, and slow query logs for identifying problematic queries. These approaches provide actionable insights into the root causes of performance degradation. Binary logging and log exports to BigQuery are useful for other purposes but do not directly address real-time performance monitoring or troubleshooting.
- A. Correct.
Correct. Query Insights is a powerful tool for Cloud SQL that provides detailed insights into query performance, making it easier to identify and troubleshoot slow queries.
- B. Correct.
Correct. Cloud Monitoring allows you to monitor metrics like CPU, memory, and storage usage and create alerts, which are critical for identifying performance bottlenecks during peak periods.
- C. Incorrect.
Incorrect. Binary logging is primarily used for replication and point-in-time recovery, not for monitoring or troubleshooting performance issues.
- D. Correct.
Correct. Enabling the PostgreSQL slow query log and setting an appropriate threshold helps capture queries that exceed the specified execution time, aiding in performance troubleshooting.
- E. Incorrect.
Incorrect. Exporting logs to BigQuery is useful for long-term log analysis but is not directly related to real-time monitoring or troubleshooting performance issues.