PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #174
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 correct answer is A. Enable automatic backup and point in time recovery. Configure the backup window during periods. Enabling automated backups with point-in-time recovery lets Cloud-SQL capture full backups plus binary logs so you can restore to any second in the last five days. Scheduling the daily snapshot during off-peak hours keeps backup I/O from impacting your write-heavy workload, and…
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-
Options
- AEnable automatic backup and point in time recovery. Configure the backup window during periods
- BSchedule hourly on-demand backups and enable point in time recovery. Delete any delete
- CSchedule a database export job to run every hour from a read replica instance. Retain the export
- DSchedule a database export job to run every hour. Use serverless export. Retain the export dumps
How the community answered
(27 responses)- A78% (21)
- B7% (2)
- C11% (3)
- D4% (1)
Explanation
Enabling automated backups with point-in-time recovery lets Cloud-SQL capture full backups plus binary logs so you can restore to any second in the last five days. Scheduling the daily snapshot during off-peak hours keeps backup I/O from impacting your write-heavy workload, and setting both backup and log retention to five days meets your recovery window.
Topics
Community Discussion
No community discussion yet for this question.