Google Professional Cloud Database Engineer Question 242
Select 3Google Cloud PlatformYour company uses a Cloud SQL instance for its production database. To ensure high availability, the instance is configured with a primary and a failover replica in a different region. Your team wants to test the disaster recovery strategy to validate that the database can recover from a regional outage. Which steps should you take to perform this test effectively?
- A
Simulate a regional outage by manually stopping the primary instance and verify that the failover replica is promoted to primary.
- B
Create a backup of the primary instance and restore it to a new instance to simulate disaster recovery.
- C
Perform a read and write workload test on the failover replica after failover is initiated to verify data consistency.
- D
Reconfigure the failover replica to use a different region during the test, then revert it back after testing.
- E
Verify that the application reconnects automatically to the new primary instance after failover is triggered.
Show answer and explanation
Correct answers: A, C, E
Explanation
Testing high availability and disaster recovery strategies involves simulating realistic failure scenarios, such as stopping the primary instance, to validate the failover process. Key steps include ensuring the failover replica is promoted, verifying data consistency by performing workload tests, and confirming that the application can automatically reconnect to the new primary. These steps collectively ensure that the system can recover effectively from regional outages.
- A. Correct.
Correct: Manually stopping the primary instance simulates a regional outage and allows you to validate that the failover replica is promoted to primary, ensuring high availability.
- B. Incorrect.
Incorrect: Creating a backup and restoring it to a new instance validates backup strategies, not disaster recovery or high availability mechanisms.
- C. Correct.
Correct: Performing read and write tests on the failover replica ensures that it is functioning correctly and data consistency is maintained after failover.
- D. Incorrect.
Incorrect: Reconfiguring the region for the failover replica during the test is unnecessary and can introduce risks. The failover replica should already be in a different region as part of the setup.
- E. Correct.
Correct: Verifying that the application automatically reconnects ensures that high availability is seamless and the application remains operational during failover.