Google Professional Cloud Database Engineer Question 137
Select 4Google Cloud PlatformYou are managing a Cloud SQL instance for a critical application and need to set up alerts to monitor errors and performance metrics. The alerts should notify your team when the database experiences high CPU usage, slow query execution, or high connection usage. Which steps should you take to achieve this?
- A
Create alerting policies in Cloud Monitoring and specify conditions for CPU utilization, query latency, and connection count.
- B
Install a custom monitoring agent on the Cloud SQL instance to gather performance metrics.
- C
Enable the Cloud SQL Insights feature and configure it to monitor query performance.
- D
Set up notification channels in Cloud Monitoring to receive alerts via email or other communication tools.
- E
Use Cloud Logging to set up log-based alerts for error logs from the Cloud SQL instance.
Show answer and explanation
Correct answers: A, C, D, E
Explanation
To set up alerts for errors and performance metrics in a Cloud SQL instance, you should leverage Cloud Monitoring to create alerting policies for key metrics like CPU usage, query latency, and connection count. Additionally, enabling Cloud SQL Insights provides query-level performance monitoring. Notification channels ensure that alerts are sent to the appropriate team members, and Cloud Logging can be used to create log-based alerts for errors. Installing a custom monitoring agent is not applicable since Cloud SQL is a managed service.
- A. Correct.
Correct. Cloud Monitoring allows you to create alerting policies for specific metrics such as CPU utilization, query latency, and connection count, which are critical for monitoring performance.
- B. Incorrect.
Incorrect. Cloud SQL is a managed service and does not allow installing custom monitoring agents. Metrics are collected automatically by Google Cloud Monitoring.
- C. Correct.
Correct. Cloud SQL Insights provides detailed query performance monitoring, which can help identify slow queries and optimize database performance.
- D. Correct.
Correct. Notification channels in Cloud Monitoring ensure that alerts are sent to the appropriate recipients via email, SMS, or other tools, enabling timely responses.
- E. Correct.
Correct. Cloud Logging can be used to create log-based alerts for errors and other issues in the Cloud SQL instance. This is crucial for monitoring application health.