PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #11
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…
The correct answer is C. Manually or automatically increase the storage capacity. When Cloud SQL predicts that an instance will run out of disk space, the direct and correct corrective action is to increase the storage capacity - either manually by resizing the disk, or automatically by enabling the automatic storage increase feature in Cloud SQL, which…
Question
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?
Options
- ANormalize the database to the third normal form.
- BCompress the data using a different compression algorithm.
- CManually or automatically increase the storage capacity.
- DCreate another schema to load older data.
How the community answered
(46 responses)- A2% (1)
- B2% (1)
- C91% (42)
- D4% (2)
Explanation
When Cloud SQL predicts that an instance will run out of disk space, the direct and correct corrective action is to increase the storage capacity - either manually by resizing the disk, or automatically by enabling the automatic storage increase feature in Cloud SQL, which grows storage as needed. Normalizing to third normal form (A) is a schema design activity that reduces data redundancy but does not address an immediate storage shortage. Changing the compression algorithm (B) is not a user-configurable Cloud SQL operation. Creating another schema for older data (D) does not free space on the existing instance unless the data is actually deleted or archived.
Topics
Community Discussion
No community discussion yet for this question.