Examkin

Question

Difficulty: MediumManaging Storage and Database Solutions

An organization operates a production Cloud SQL for MySQL instance supporting an online web application. During high-traffic events, database storage usage grows rapidly and risks consuming all remaining disk space. The operations team needs to ensure that database storage expands dynamically as data grows without incurring application downtime or requiring manual operational intervention. Which action should the operations team perform to satisfy this requirement?

  1. Enable the Automatic Storage Increase setting directly on the Cloud SQL instance configuration.Answer
  2. B
    Configure a Managed Instance Group autoscaling policy based on database disk usage metrics.
  3. C
    Migrate transaction tables to a Cloud Bigtable instance to prevent the relational database disk from filling up.
  4. D
    Execute a custom script using gcloud storage buckets update to dynamically expand the attached storage volume.

Answer

Enable the Automatic Storage Increase setting directly on the Cloud SQL instance configuration.
Enabling the Automatic Storage Increase feature in Cloud SQL ensures that Google Cloud automatically adds storage space whenever available capacity drops below a critical threshold (such as 10%). This disk expansion is non-disruptive and takes effect while the database instance remains running and accessible.

Step-by-Step Solution

1
Identify the operational goal and database management requirement.
The goal is to automatically scale storage capacity on a Cloud SQL instance under heavy load without causing downtime.
Cloud SQL manages disk space transparently when appropriate built-in configuration settings are enabled.
2
Evaluate GCP managed database operational features.
Cloud SQL provides a built-in Automatic Storage Increase feature that checks available space and adds storage automatically when free space drops below a threshold (typically 10% of total capacity).
This operation expands disk capacity online without requiring instance restarts or downtime.
3
Select the correct management action.
Enabling Automatic Storage Increase on the Cloud SQL instance configuration meets all operational constraints.
Alternative compute or object storage tools do not manage Cloud SQL relational disk volumes.

Key Concept

Cloud SQL Storage Management & Automatic Storage Increase
Estimated Time:1m 30s
Rate this question

Topics

Managing Storage and Database Solutions