Google Professional Cloud Database Engineer Question 240
Select 3Google Cloud PlatformYour company uses Cloud SQL for a mission-critical application and requires high availability and disaster recovery. You are tasked with testing these strategies to ensure minimal downtime and data integrity during a failure event. Which of the following actions should you take to perform a comprehensive test of high availability and disaster recovery strategies?
- A
Simulate a zonal failure by forcing a failover in Cloud SQL.
- B
Restore the database from a recent backup and validate application connectivity.
- C
Perform a read-only query test on the replica without triggering a failover.
- D
Review the Cloud SQL logs to identify any historical failover events.
- E
Test application behavior during a primary instance restart.
Show answer and explanation
Correct answers: A, B, E
Explanation
Testing high availability and disaster recovery strategies involves simulating real-world failure scenarios, such as forced failovers and database restorations, to ensure the system performs as expected during disruptions. Simulating failovers (zonal failure), restoring backups, and testing application behavior during instance restarts help validate both high availability and disaster recovery mechanisms. Simply reviewing logs or performing basic read-only queries does not actively test these critical strategies.
- A. Correct.
Simulating a zonal failure by forcing a failover in Cloud SQL is a critical test to validate high availability. This ensures the system works as expected during a real zonal failure event.
- B. Correct.
Restoring the database from a recent backup and validating application connectivity is essential for testing disaster recovery. This ensures that backups are valid and usable in a failure scenario.
- C. Incorrect.
While performing a read-only query on a replica can help verify data replication, it does not test high availability or failover mechanisms. It is insufficient for comprehensive testing.
- D. Incorrect.
Reviewing historical failover events in logs is useful for analysis but does not actively test the current high availability or disaster recovery strategies.
- E. Correct.
Testing application behavior during a primary instance restart helps evaluate how the system responds to planned downtime or unexpected restarts, which is part of high availability testing.