Google Cloud Professional Cloud Database Engineer — Question 147

You are designing the backup and recovery strategy of a Cloud SQL for MySQL database that serves a write heavy application. You need to be able to restore the database to any point in time within the past five days while minimizing the performance impact of database backups. What should you do?

Answer options

• A. Enable automatic backup and point in time recovery. Configure the backup window during periods of low database traffic. Set backup and transaction log retention to at least five days.
• B. Schedule hourly on-demand backups and enable point in time recovery. Delete any delete backups that were taken over five days ago.
• C. Schedule a database export job to run every hour from a read replica instance. Retain the export dumps for at least five days.
• D. Schedule a database export job to run every hour. Use serverless export. Retain the export dumps for at least five days.

Correct answer: A

Explanation

The correct answer is A because enabling automatic backups along with point in time recovery allows for efficient backups with minimal performance impact, and configuring the backup window during low traffic ensures that the database performance is not adversely affected. The other options either do not provide a continuous backup solution or do not effectively minimize performance impact during backups.