Google Cloud Professional Cloud Database Engineer — Question 25

You are managing a small Cloud SQL instance for developers to do testing. The instance is not critical and has a recovery point objective (RPO) of several days. You want to minimize ongoing costs for this instance. What should you do?

Answer options

• A. Take no backups, and turn off transaction log retention.
• B. Take one manual backup per day, and turn off transaction log retention.
• C. Turn on automated backup, and turn off transaction log retention.
• D. Turn on automated backup, and turn on transaction log retention.

Correct answer: C

Explanation

The correct answer is C because enabling automated backups provides a balance between cost and data safety, allowing for recovery within the RPO without incurring high costs. Option A is not advisable as it completely eliminates backups, risking data loss. Option B, while it offers some backup, may not be sufficient for the RPO requirement. Option D increases costs unnecessarily by enabling transaction log retention, which is not needed for an instance with a high RPO.