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?
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.
D.
Reduce the number of automated backups that are retained to two (2).
D.
A is wrong - you can’t do that. Automated backups are either on or off. You only get to choose the 4 hour window and if the backups are stored in a single or multi-region. B is wrong for the same reason. C wouldn’t lower the cost, but reducing the number of backups retained would. The default is 7. This can be verified using the Google Pricing Calculator.
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
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.
dynamic_dba
Highly Voted 7Â months, 2Â weeks agoPrtkKA
Highly Voted 7Â months, 4Â weeks agochelbsik
Most Recent 10Â months, 1Â week agopk349
10Â months, 1Â week ago