Google Professional Cloud Database Engineer Question 241
Select 3Google Cloud PlatformYou are a database engineer managing a mission-critical application hosted on Google Cloud using Cloud SQL. To ensure high availability and disaster recovery, you have implemented a failover replica in a different region and scheduled regular failover tests. During a recent disaster recovery test, you observe that the failover process takes longer than expected. What steps should you take to improve the failover performance?
- A
Ensure the primary and failover replicas use the same machine type and configuration.
- B
Reduce the replication lag by optimizing the primary database's write load.
- C
Test failover under simulated load conditions to identify bottlenecks.
- D
Switch from synchronous to asynchronous replication to decrease failover time.
- E
Enable automated backups and point-in-time recovery for the primary database.
Show answer and explanation
Correct answers: A, B, C
Explanation
To improve failover performance, it is crucial to ensure consistency between the primary and failover replicas, minimize replication lag, and test failover under realistic conditions. These steps help identify and address potential issues, ensuring a smoother and faster failover process. Asynchronous replication, while faster, compromises data integrity and is unsuitable for mission-critical environments. Automated backups and point-in-time recovery are essential for disaster recovery but do not directly enhance failover performance.
- A. Correct.
Ensuring that the primary and failover replicas use the same machine type and configuration minimizes discrepancies during failover, improving performance and reliability.
- B. Correct.
Replication lag can significantly impact failover performance. Optimizing the write load on the primary database can help reduce this lag.
- C. Correct.
Testing under simulated load conditions can help identify bottlenecks and performance issues that only occur under real-world scenarios, allowing for more effective troubleshooting.
- D. Incorrect.
Switching to asynchronous replication can reduce latency but increases the risk of data loss during failover, which is not suitable for disaster recovery in mission-critical applications.
- E. Incorrect.
While important for data recovery purposes, enabling automated backups and point-in-time recovery does not directly affect failover performance.