Google Cloud Professional Cloud Database Engineer — Question 18

Your company uses the Cloud SQL out-of-disk recommender to analyze the storage utilization trends of production databases over the last 30 days. Your database operations team uses these recommendations to proactively monitor storage utilization and implement corrective actions. You receive a recommendation that the instance is likely to run out of disk space. What should you do to address this storage alert?

Answer options

• A. Normalize the database to the third normal form.
• B. Compress the data using a different compression algorithm.
• C. Manually or automatically increase the storage capacity.
• D. Create another schema to load older data.

Correct answer: C

Explanation

The correct action is to increase the storage capacity, either manually or automatically, to prevent the instance from running out of disk space. Normalizing the database or creating a new schema does not directly address the immediate storage issue, and changing the compression algorithm may not sufficiently resolve the problem of limited disk space.