Google Professional Cloud Database Engineer Question 120
Select 4Google Cloud PlatformYou are a database engineer managing a Cloud SQL for PostgreSQL instance. Recently, users have reported performance degradation during peak usage hours. You suspect a resource bottleneck. Which combination of monitoring tools should you use to identify the root cause of the issue?
- A
Use the Metrics Explorer in Google Cloud Monitoring to analyze CPU and memory utilization trends over time.
- B
Check Cloud Logging for query execution logs to identify long-running or resource-intensive queries.
- C
Enable the 'Storage Usage' metric in Cloud Monitoring to track disk utilization and IOPS patterns.
- D
Use the Query Insights feature in Cloud SQL to analyze query performance and detect potential bottlenecks.
- E
Inspect the Cloud IAM permissions for the database instance to ensure proper access control.
Show answer and explanation
Correct answers: A, B, C, D
Explanation
To diagnose performance degradation in a Cloud SQL instance, you need to monitor database vitals such as CPU, memory, storage, and query performance. Tools like Metrics Explorer, Cloud Logging, and Query Insights provide the necessary insights to identify resource bottlenecks or inefficient queries, while storage metrics help detect issues with disk performance. Cloud IAM permissions are unrelated to performance issues in this case.
- A. Correct.
Correct: Metrics Explorer in Google Cloud Monitoring is a critical tool to monitor CPU and memory utilization trends, helping you identify resource constraints.
- B. Correct.
Correct: Cloud Logging provides detailed query execution logs, which can help you pinpoint specific queries that may be causing performance issues.
- C. Correct.
Correct: Monitoring storage utilization and IOPS through Cloud Monitoring can help you determine if disk performance is contributing to the degradation.
- D. Correct.
Correct: Query Insights in Cloud SQL is specifically designed to analyze query performance and identify slow or problematic queries.
- E. Incorrect.
Incorrect: While inspecting Cloud IAM permissions is important for security, it is not directly relevant to diagnosing performance bottlenecks in this scenario.