Answer-first summary for fast verification
Answer: Change the storage tier of the automated backups from solid-state drive (SSD) to hard disk drive (HDD).
To minimize operational costs for backups in a non-mission-critical Cloud SQL for PostgreSQL instance, the most effective strategies would involve reducing the frequency or the cost of storage for backups. Option A suggests reducing the frequency of backups, which would lower costs but also reduce the recovery point objective (RPO). Option B recommends changing the storage tier from SSD to HDD for backups, which is a cost-effective solution since HDD storage is cheaper than SSD, and the performance difference is negligible for backup storage. Option C, selecting a different region for backups, might affect costs slightly due to regional pricing differences, but it's not as directly impactful as changing the storage tier. Option D suggests reducing the number of retained backups, which would save on storage costs but could limit recovery options. The most straightforward and effective method to lower backup costs without significantly impacting the backup strategy is to change the storage tier to HDD (Option B). Therefore, the correct answer is B.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How can you reduce the cost of backups for a non-mission-critical, large Cloud SQL for PostgreSQL instance while minimizing operational expenses?
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).
No comments yet.