PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #111
Your organization is running a MySQL workload in Cloud SQL. Suddenly you see a degradation in database performance. You need to identify the root cause of the performance degradation. What should you
The correct answer is B. Use Cloud Monitoring to monitor CPU, memory, and storage utilization metrics.. Cloud Monitoring provides database-level performance metrics such as CPU utilization, memory usage, disk I/O, and query throughput for Cloud SQL instances, enabling root cause analysis of performance degradation.
Question
Your organization is running a MySQL workload in Cloud SQL. Suddenly you see a degradation in database performance. You need to identify the root cause of the performance degradation. What should you do?
Options
- AUse Logs Explorer to analyze log data.
- BUse Cloud Monitoring to monitor CPU, memory, and storage utilization metrics.
- CUse Error Reporting to count, analyze, and aggregate the data.
- DUse Cloud Debugger to inspect the state of an application.
How the community answered
(19 responses)- A5% (1)
- B74% (14)
- C16% (3)
- D5% (1)
Why each option
Cloud Monitoring provides database-level performance metrics such as CPU utilization, memory usage, disk I/O, and query throughput for Cloud SQL instances, enabling root cause analysis of performance degradation.
Logs Explorer is useful for reviewing database error logs and slow query logs, but it does not provide the time-series performance metrics needed to identify resource-level bottlenecks causing degradation.
Cloud Monitoring collects and displays built-in Cloud SQL metrics including CPU utilization, memory utilization, disk read/write operations, active connections, and queries per second. By analyzing these metrics, a database administrator can pinpoint whether performance degradation is caused by resource saturation such as CPU throttling, memory pressure, or disk I/O bottlenecks, directly identifying the root cause.
Error Reporting aggregates application-level errors and exceptions; it is not designed to analyze database performance metrics or resource utilization.
Cloud Debugger (now deprecated) was used to inspect live application state at specific code lines; it has no capability to diagnose database performance issues.
Concept tested: Cloud Monitoring for Cloud SQL performance analysis
Source: https://cloud.google.com/sql/docs/mysql/monitor-instance
Topics
Community Discussion
No community discussion yet for this question.