nerdexam
Google

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.

Submitted by ngozi_ng· Mar 30, 2026Ensuring solution and operations reliability

Question

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 replication lag below 60 seconds. What are the correct steps to meet your requirements?

Options

  • A
    1. Enable automatic storage increase for the instance.
  • B
    1. Enable automatic storage increase for the instance.
  • C
    1. Create a Stackdriver alert when storage exceeds 75%, and increase the available storage on
  • D
    1. Create a Stackdriver alert when storage exceeds 75%, and increase the available storage on

How the community answered

(44 responses)
  • A
    77% (34)
  • B
    7% (3)
  • C
    14% (6)
  • D
    2% (1)

Why each option

Cloud SQL automatic storage increase handles unbounded storage growth, while Stackdriver (Cloud Monitoring) alerts on CPU and replication lag thresholds.

A1. Enable automatic storage increase for the instance.Correct

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.

B1. Enable automatic storage increase for the instance.

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.

C1. Create a Stackdriver alert when storage exceeds 75%, and increase the available storage on

Manually increasing storage via an alert-triggered workflow does not prevent outages during the alert-response window the way automatic storage increase does.

D1. Create a Stackdriver alert when storage exceeds 75%, and increase the available storage on

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

#Cloud SQL#automatic storage increase#CPU monitoring#replication lag

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-CLOUD-ARCHITECT Practice