A company is designing a disaster recovery plan for their Cloud SQL for PostgreSQL instance. They want to ensure that the database can be recovered in another region within minutes with minimal data loss. Which three actions should they take? (Choose three.)
Trap 1: Configure a failover replica in a different zone within the same…
Only protects against zone failure, not regional disaster.
Trap 2: Enable automated backups with a retention period of 30 days
Backups are for within-region, not for quick cross-region recovery.
- A
Enable point-in-time recovery
Allows recovery to a specific point in time, minimizing data loss.
- B
Regularly test the failover procedure
Ensures the DR plan works when needed.
- C
Configure a failover replica in a different zone within the same region
Why wrong: Only protects against zone failure, not regional disaster.
- D
Enable cross-region replication using Cloud SQL's replica feature
Provides a readable replica in another region for failover.
- E
Enable automated backups with a retention period of 30 days
Why wrong: Backups are for within-region, not for quick cross-region recovery.