Discuss Google Professional Cloud Database Engineer Exam Topic 8 Question 67

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?

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 (HDD).

CSelect a different region to store your backups.

DReduce the number of automated backups that are retained to two (2).

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

Get Premium Professional Cloud Database Engineer Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

26 comments · newest first

Desmond 1 month ago

I’m leaning towards option C. Different regions might have lower rates.

Rusty 1 month ago

Option D makes sense too. Keeping only two backups reduces costs.

Werner 2 months ago

I prefer option B. HDD is cheaper than SSD for backups.

Myrtie 2 months ago

I think option A is a good choice. Less frequent backups save money.

Oretha 2 months ago

I’m leaning towards option C. Different regions might have lower rates.

Vi 2 months ago

Option D makes sense too. Keeping only two backups cuts costs.

Erin 2 months ago

I prefer option B. HDD is cheaper than SSD for backups.

Howard 2 months ago

I think option A is a good choice. Less frequent backups save money.

Gracia 3 months ago

I’m leaning towards option C. Different regions might have lower costs.

Wade 3 months ago

Option D makes sense too. Keeping only two backups is efficient.

Von 3 months ago

I prefer option B. HDD is cheaper than SSD for backups.

Breana 3 months ago

I think option A is smart. Less frequent backups save costs.

Yaeko 3 months ago

D) sounds smart, less clutter and cheaper!

Malcolm 4 months ago

C) could lead to higher latency, not worth it.

Gracia 5 months ago

Surprised that reducing retention to two backups is even an option!

Vannessa 5 months ago

I disagree, B) might save more in the long run.

Maryann 5 months ago

A) is a good option to save costs!

Aide 6 months ago

D) sounds smart, less clutter and cheaper!

Shayne 6 months ago

C) could lead to higher latency, not worth it.

Gracie 6 months ago

Surprised that reducing retention to two backups is even an option!

Daryl 6 months ago

I disagree, B) might save more in the long run.

Aracelis 6 months ago

A) is a good option to save costs!

Bettyann 6 months ago

I recall a practice question about backup regions, but I’m not convinced that option C would actually lower costs significantly.

Hillary 7 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.

Timothy 7 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.

Pansy 7 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.

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