Google Professional Cloud Database Engineer Question 123
Select 3Google Cloud PlatformYour organization runs a PostgreSQL database on Cloud SQL. Recently, users have reported slow query performance. You suspect that the issue may be caused by resource bottlenecks. To investigate and monitor the database vitals, such as RAM usage, CPU utilization, disk I/O, and storage, which steps should you take?
- A
Enable and review Cloud Monitoring metrics for the database instance to analyze CPU, memory, and storage utilization.
- B
Use the Query Insights feature in Cloud SQL to identify slow-running queries and their resource consumption trends.
- C
Review the Cloud Logging logs for the database instance to identify potential errors and warnings related to resource usage.
- D
Manually SSH into the database instance and run operating system commands to monitor resource utilization.
- E
Configure a custom monitoring solution outside of Google Cloud to analyze resource metrics for the database.
Show answer and explanation
Correct answers: A, B, C
Explanation
To monitor and investigate database vitals on Cloud SQL, you should leverage Google Cloud's native tools such as Cloud Monitoring, Query Insights, and Cloud Logging. These tools provide detailed insights into resource usage, query performance, and potential errors without requiring manual intervention or external solutions. Using these services ensures you follow best practices and make efficient use of Google Cloud's capabilities.
- A. Correct.
Correct: Cloud Monitoring provides built-in metrics for database instances, such as CPU, memory, and storage utilization, which are essential for diagnosing performance bottlenecks.
- B. Correct.
Correct: Query Insights is a native feature of Cloud SQL that helps identify slow queries and their resource consumption, making it a valuable tool for investigating performance issues.
- C. Correct.
Correct: Cloud Logging captures detailed logs for database instances, which can include error and warning messages related to resource usage, providing actionable insights.
- D. Incorrect.
Incorrect: Cloud SQL is a managed service, and direct SSH access to the underlying instance is not allowed. Resource monitoring must be done using the provided tools and services.
- E. Incorrect.
Incorrect: While you could use an external monitoring solution, Google Cloud's native tools like Cloud Monitoring and Query Insights are optimized for Cloud SQL and provide sufficient insights for most scenarios.