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…

Question

Options

• ASet the automated backups to occur every other day to lower the frequency of backups.
• BChange the storage tier of the automated backups from solid-state drive (SSD) to hard disk drive
• CSelect a different region to store your backups.
• DReduce the number of automated backups that are retained to two (2).

• A
  4% (2)
• B
  9% (4)
• C
  6% (3)
• D
  81% (38)

Explanation

Reducing the number of retained automated backups to two is the most direct and effective way to lower backup storage costs. Cloud SQL charges for the storage consumed by retained backups; fewer retained backups means less storage consumed. The default retention is 7 backups, so reducing to 2 can cut backup storage costs by more than 70%. Option A is invalid because Cloud SQL does not allow configuring automated backup frequency (backups occur once per day automatically). Option B is invalid because Cloud SQL manages backup storage internally and does not expose an SSD vs. HDD tier choice for backup storage. Option C (selecting a different region) could incur inter-region data transfer costs and would not produce meaningful savings.

No community discussion yet for this question.