Question 270
A Cloud SQL database needs recurring managed backups for recovery from data corruption. The team wants scheduled backup retention instead of relying on application CSV dumps. What should they enable?
Explanation
Correct Answer
Automated backups generate managed recovery points on schedule, subject to engine and instance configuration.
Incorrect Answers
A single ad hoc backup is a point-in-time artifact, not a configured recurring backup schedule and retention policy.
CPU limits do not create database recovery copies.
IAM authorization alone does not schedule or retain database backups.