QuestionQ103

VerifiedDeploy scalable and highly available databases in Google Cloud

You manage a small Cloud SQL instance that developers use for testing. The instance is noncritical and has a recovery point objective (RPO) of several days. You want to reduce this instance's ongoing costs as much as possible. What should you do?

Explanation

Automated backups provide recoverable backup points that can be retained for the required period, satisfying an RPO measured in days. Transaction-log retention is used for point-in-time recovery, which is not needed for that RPO and incurs additional resource and storage cost. On-demand backups are retained until manually deleted, so relying on a daily manual backup adds management overhead and can create unnecessary continuing storage cost.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!