PROFESSIONAL-CLOUD-ARCHITECT · Question #128
You are using Cloud SQL as the database backend for a large CRM deployment. You want to scale as usage increases and ensure that you don't run out of storage, maintain 75% CPU usage cores, and keep re
The correct answer is A. 1. Enable automatic storage increase for the instance.. Cloud SQL automatic storage increase handles unbounded storage growth, while Stackdriver (Cloud Monitoring) alerts on CPU and replication lag thresholds.
Question
Options
- A
- Enable automatic storage increase for the instance.
- B
- Enable automatic storage increase for the instance.
- C
- Create a Stackdriver alert when storage exceeds 75%, and increase the available storage on
- D
- Create a Stackdriver alert when storage exceeds 75%, and increase the available storage on
How the community answered
(44 responses)- A77% (34)
- B7% (3)
- C14% (6)
- D2% (1)
Why each option
Cloud SQL automatic storage increase handles unbounded storage growth, while Stackdriver (Cloud Monitoring) alerts on CPU and replication lag thresholds.
Enabling automatic storage increase on a Cloud SQL instance prevents storage exhaustion without manual intervention; creating Stackdriver alerting policies on CPU utilization and replication lag metrics then ensures the 75% CPU and 60-second replication lag SLOs are monitored proactively and actioned before they breach thresholds.
This option likely involves a manual storage-expansion workflow instead of automatic increase, which introduces operational risk for a large CRM deployment requiring continuous availability.
Manually increasing storage via an alert-triggered workflow does not prevent outages during the alert-response window the way automatic storage increase does.
This option combines manual storage management with incomplete monitoring, failing to provide the automated storage scaling required by the stated requirements.
Concept tested: Cloud SQL automatic storage increase and monitoring
Source: https://cloud.google.com/sql/docs/mysql/instance-settings#automatic-storage-increase
Topics
Community Discussion
No community discussion yet for this question.