PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #190
Your company has implemented a multi-regional, highly available (HA) PostgreSQL database cluster on Google Cloud by using Cloud SQL and regional persistent disks. You need to assess the…
The correct answer is A. Promote the cross-region replica and verify that the application can still access the database. Promoting a cross-region replica simulates a full regional outage and exercises your cross-region failover path. By switching your application over to the promoted replica and verifying connectivity, you confirm that your DR plan works end to end without relying solely on…
Question
Your company has implemented a multi-regional, highly available (HA) PostgreSQL database cluster on Google Cloud by using Cloud SQL and regional persistent disks. You need to assess the effectiveness of your disaster recovery plan and validate the system's ability to recover from a regional outage. What should you do-
Options
- APromote the cross-region replica and verify that the application can still access the database.
- BInitiate a failover test to the HA standby instance and verify that the application can still access the
- CCreate a backup of the database and restore it to a new Cloud SQL instance in a different region
- DConduct a chaos engineering experiment by randomly terminating virtual machines in the primary
How the community answered
(53 responses)- A57% (30)
- B8% (4)
- C9% (5)
- D26% (14)
Explanation
Promoting a cross-region replica simulates a full regional outage and exercises your cross-region failover path. By switching your application over to the promoted replica and verifying connectivity, you confirm that your DR plan works end to end without relying solely on in-region HA failover or manual restore processes.
Topics
Community Discussion
No community discussion yet for this question.