exam questions

Exam Professional Cloud Database Engineer All Questions

View all questions & answers for the Professional Cloud Database Engineer exam

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 Hide Answer
Suggested Answer: C 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Kloudgeek
Highly Voted 10 months, 1 week ago
Correct answer is C: https://cloud.google.com/sql/docs/mysql/using-ood-recommender#apply_recommendations
upvoted 6 times
...
dynamic_dba
Highly Voted 7 months, 2 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
...
Pilot50
Most Recent 6 months, 3 weeks ago
Selected Answer: C
out of disk means need for more space
upvoted 1 times
...
pk349
10 months ago
C: Manually or automatically increase the storage capacity.
upvoted 1 times
...
GCP72
10 months ago
Selected Answer: C
C is the correct answer
upvoted 2 times
...
lapeyus
10 months, 1 week ago
Selected Answer: C
https://cloud.google.com/sql/docs/mysql/instance-settings#storage-capacity-2ndgen
upvoted 1 times
...
range9005
10 months, 1 week ago
Selected Answer: C
Manually or automatically increase the storage capacity.
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago