Google Cloud Professional Cloud Database Engineer — Question 90

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?

Answer options

• 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).

Correct answer: D

Explanation

The correct answer is D because reducing the number of automated backups retained directly decreases storage costs associated with those backups. Option A only adjusts the frequency but does not affect the retention cost, while options B and C do not inherently lower the backup costs and may involve other considerations.