nerdexam
Google

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.

Monitoring and Troubleshooting Database Performance

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)
  • A
    5% (1)
  • B
    74% (14)
  • C
    16% (3)
  • D
    5% (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.

AUse Logs Explorer to analyze log data.

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.

BUse Cloud Monitoring to monitor CPU, memory, and storage utilization metrics.Correct

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.

CUse Error Reporting to count, analyze, and aggregate the data.

Error Reporting aggregates application-level errors and exceptions; it is not designed to analyze database performance metrics or resource utilization.

DUse Cloud Debugger to inspect the state of an application.

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

#Cloud SQL#Performance Monitoring#Troubleshooting#Cloud Monitoring

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-CLOUD-DATABASE-ENGINEER Practice