Google Professional Cloud Database Engineer Question 113
Select 3Google Cloud PlatformYou are managing a Cloud SQL for PostgreSQL instance running in Google Cloud. The database has recently experienced a significant increase in connection latency, and you need to configure monitoring to identify the cause of the issue. Which combination of actions will help you effectively monitor and troubleshoot the problem?
- A
Enable and review Query Insights to analyze query performance and execution statistics.
- B
Set up a Stackdriver (Cloud Monitoring) alert to notify you when CPU utilization exceeds a defined threshold.
- C
Enable the database's general query log to capture all query activity in real time.
- D
Configure a log sink to export database logs to Cloud Storage for long-term analysis.
- E
Activate the slow query log to identify queries that are taking longer than a specific threshold.
Show answer and explanation
Correct answers: A, B, E
Explanation
To effectively troubleshoot increased connection latency in a Cloud SQL for PostgreSQL instance, it is important to use tools like Query Insights and the slow query log to gather insights into query performance, as well as set up monitoring alerts to detect resource utilization issues. These actions collectively provide the data needed to identify and resolve the root cause of performance problems.
- A. Correct.
Enabling and reviewing Query Insights provides detailed query performance metrics, including which queries are consuming the most resources and how they can be optimized. This is a recommended approach for identifying performance bottlenecks.
- B. Correct.
Setting up a Cloud Monitoring alert for CPU utilization ensures that you are notified when the database instance is under heavy load, which could contribute to connection latency.
- C. Incorrect.
Enabling the database's general query log captures all queries in real time, but this can significantly impact performance and is not typically recommended for troubleshooting latency issues in production environments.
- D. Incorrect.
Configuring a log sink for Cloud Storage allows you to store logs long-term, but it does not directly help in diagnosing immediate latency issues.
- E. Correct.
Activating the slow query log helps you focus on identifying queries that are taking longer to execute, which is critical for troubleshooting performance-related problems like increased connection latency.