Exam Professional Cloud Database Engineer topic 1 question 30 discussion

Actual exam question from Google's Professional Cloud Database Engineer

Question #: 30
Topic #: 1

[All Professional Cloud Database Engineer Questions]

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?

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.

Show Suggested Answer

Suggested Answer: C 🗳️

by Kloudgeek at Dec. 20, 2022, 9:43 p.m.

Comments

Submit Cancel

Kloudgeek

Highly Voted 1 year, 1 month ago

Correct answer is C: https://cloud.google.com/sql/docs/mysql/using-ood-recommender#apply_recommendations

upvoted 6 times

...

dynamic_dba

Highly Voted 10 months, 3 weeks ago

C. A is wrong since modifying the schemas to 3NF would use more disk. D is nonsense. B sounds vague at best and probably not supported at the database level. C is the best answer. The link provided by Kloudgeek is spot on.

upvoted 6 times

...