Google Cloud Professional Cloud Database Engineer PCDBE — Topic 1 Question 153

Question

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?

Accepted Answer

Correct answer: A. The correct answer is A. Option 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.

Google Cloud Professional Cloud Database Engineer PCDBE — Question 153