Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Google Professional Cloud Database Engineer Exam - Topic 8 Question 67 Discussion

You have a large Cloud SQL for PostgreSQL instance. The database instance is not mission-critical, and you want to minimize operational costs. What should you do to lower the cost of backups in this environment?
D) Reduce the number of automated backups that are retained to two (2).
A) Set the automated backups to occur every other day to lower the frequency of backups.
B) Change the storage tier of the automated backups from solid-state drive (SSD) to hard disk drive (HDD).
C) Select a different region to store your backups.

Google Professional Cloud Database Engineer Exam - Topic 8 Question 67 Discussion

Actual exam question for Google's Professional Cloud Database Engineer exam
Question #: 67
Topic #: 8
[All Professional Cloud Database Engineer Questions]

You have a large Cloud SQL for PostgreSQL instance. The database instance is not mission-critical, and you want to minimize operational costs. What should you do to lower the cost of backups in this environment?

Show Suggested Answer Hide Answer
Suggested Answer: D

By default, for each instance, Cloud SQL retains seven automated backups, in addition to on-demand backups. You can configure how many automated backups to retain (from 1 to 365). We charge a lower rate for backup storage than for other types of instances. https://cloud.google.com/sql/docs/mysql/backup-recovery/backups


Contribute your Thoughts:

0/2000 characters
Von
9 hours ago
I prefer option B. HDD is cheaper than SSD for backups.
upvoted 0 times
...
Breana
6 days ago
I think option A is smart. Less frequent backups save costs.
upvoted 0 times
...
Yaeko
11 days ago
D) sounds smart, less clutter and cheaper!
upvoted 0 times
...
Malcolm
16 days ago
C) could lead to higher latency, not worth it.
upvoted 0 times
...
Gracia
2 months ago
Surprised that reducing retention to two backups is even an option!
upvoted 0 times
...
Vannessa
2 months ago
I disagree, B) might save more in the long run.
upvoted 0 times
...
Maryann
2 months ago
A) is a good option to save costs!
upvoted 0 times
...
Aide
3 months ago
D) sounds smart, less clutter and cheaper!
upvoted 0 times
...
Shayne
3 months ago
C) could lead to higher latency, not worth it.
upvoted 0 times
...
Gracie
3 months ago
Surprised that reducing retention to two backups is even an option!
upvoted 0 times
...
Daryl
3 months ago
I disagree, B) might save more in the long run.
upvoted 0 times
...
Aracelis
3 months ago
A) is a good option to save costs!
upvoted 0 times
...
Bettyann
3 months ago
I recall a practice question about backup regions, but I’m not convinced that option C would actually lower costs significantly.
upvoted 0 times
...
Hillary
4 months ago
I think reducing the number of backups retained in option D makes sense for cost savings, but I’m not clear on how that impacts recovery time.
upvoted 0 times
...
Timothy
4 months ago
I feel like changing the storage tier to HDD in option B might save money, but I wonder if it affects performance too much.
upvoted 0 times
...
Pansy
4 months ago
I remember we discussed backup frequency in class, and I think option A could help reduce costs, but I'm not sure if every other day is enough.
upvoted 0 times
...

Save Cancel