Google Cloud Professional Cloud Database Engineer — Question 63

Your ecommerce application connecting to your Cloud SQL for SQL Server is expected to have additional traffic due to the holiday weekend. You want to follow Google-recommended practices to set up alerts for CPU and memory metrics so you can be notified by text message at the first sign of potential issues. What should you do?

Answer options

• A. Use a Cloud Function to pull CPU and memory metrics from your Cloud SQL instance and to call a custom service to send alerts.
• B. Use Error Reporting to monitor CPU and memory metrics and to configure SMS notification channels.
• C. Use Cloud Logging to set up a log sink for CPU and memory metrics and to configure a sink destination to send a message to Pub/Sub.
• D. Use Cloud Monitoring to set up an alerting policy for CPU and memory metrics and to configure SMS notification channels.

Correct answer: D

Explanation

The correct answer, D, is appropriate because Cloud Monitoring is specifically designed for establishing alerting policies for metrics like CPU and memory, allowing for immediate SMS notifications. Options A, B, and C do not utilize the recommended service for this purpose, as they either require custom implementations or do not focus on the necessary monitoring capabilities for proactive alerts.