Google Professional Cloud Database Engineer Question 122
Select 3Google Cloud PlatformYou are managing a Cloud SQL database for a critical application, and users report degraded performance during peak usage hours. To diagnose and resolve the issue, you decide to monitor database vitals using Google Cloud's tools. Which actions should you prioritize to identify the root cause of the performance degradation?
- A
Review CPU utilization metrics on the Cloud Monitoring dashboard to check for high CPU usage during peak times.
- B
Analyze Cloud Logging for slow query logs to identify queries causing bottlenecks.
- C
Inspect storage utilization trends to determine if the database is nearing its storage limit.
- D
Check network bandwidth usage to see if excessive data transfer is causing the slowdown.
- E
Monitor I/O performance metrics to identify potential disk throughput or latency issues.
Show answer and explanation
Correct answers: A, B, E
Explanation
To diagnose database performance issues, it is crucial to monitor key metrics correlated with processing capacity (CPU), query execution (slow logs), and data access speed (I/O). These metrics help pinpoint whether the issue is due to server overload, inefficient queries, or disk bottlenecks. While storage and network metrics are useful, they are less likely to be the primary cause of the reported performance issue in this specific scenario.
- A. Correct.
High CPU utilization could indicate that the database server is overloaded during peak times, which is a common cause of performance degradation.
- B. Correct.
Slow query logs provide critical insights into queries that may be taking too long to execute, which can contribute to poor performance.
- C. Incorrect.
While storage utilization is important, nearing the storage limit would typically cause errors or data issues rather than immediate performance degradation.
- D. Incorrect.
Network bandwidth usage is more relevant for distributed systems or data replication issues, but it is less likely to directly impact database performance during peak usage in this scenario.
- E. Correct.
I/O performance metrics are essential for identifying disk-related bottlenecks, such as slow read or write operations, which can significantly impact database performance.