Google Professional Cloud Database Engineer Question 141
Select 3Google Cloud PlatformYou are designing a backup and recovery solution for a mission-critical PostgreSQL database running on Google Cloud. The database requires point-in-time recovery and needs to ensure minimal downtime in case of failures. Which combination of strategies should you implement to meet these requirements?
- A
Enable automated backups for the database instance with a sufficient retention period.
- B
Configure binary logging to capture data changes for point-in-time recovery.
- C
Manually trigger backups every day during off-peak hours to avoid performance impact.
- D
Set up a read replica in a different region and configure replication logs for disaster recovery.
- E
Design a Cloud Function to archive backups to Cloud Storage after each automated backup.
Show answer and explanation
Correct answers: A, B, D
Explanation
To ensure point-in-time recovery and minimal downtime, you need to enable automated backups and binary logging to capture incremental changes. Additionally, setting up a read replica in a different region provides disaster recovery capabilities, ensuring the database is resilient to regional outages. These strategies together form a robust backup and recovery solution.
- A. Correct.
Automated backups with a sufficient retention period are critical for ensuring database recovery from data loss or corruption.
- B. Correct.
Binary logging is necessary for point-in-time recovery as it captures incremental changes, allowing restoration to a specific moment.
- C. Incorrect.
Manually triggering backups daily introduces operational overhead and does not meet the needs of continuous recovery or automation.
- D. Correct.
A read replica in a different region provides disaster recovery options and ensures minimal downtime in case of regional failures.
- E. Incorrect.
While archiving backups to Cloud Storage can provide additional durability, it is not a direct requirement for point-in-time recovery or minimal downtime.