Google Professional Data Engineer Question 278
Select 3Google Cloud PlatformYour organization is running a Cloud SQL MySQL instance to support a critical application. To ensure high availability and disaster recovery, you are tasked with setting up data replication and failover. Which of the following steps should you take to achieve this?
- A
Enable a read replica for the Cloud SQL instance.
- B
Set up a failover replica for the Cloud SQL instance.
- C
Configure automated backups for the primary Cloud SQL instance.
- D
Manually replicate data to another region using export and import.
- E
Enable point-in-time recovery for the Cloud SQL instance.
Show answer and explanation
Correct answers: B, C, E
Explanation
To ensure high availability and disaster recovery for a Cloud SQL instance, it is necessary to set up a failover replica for automatic failover, configure automated backups to restore data in case of failure, and enable point-in-time recovery for precise data recovery. While a read replica improves performance, it does not contribute to failover capabilities. Manual data replication is not practical or reliable for such scenarios.
- A. Incorrect.
Enabling a read replica provides performance benefits for read-heavy workloads, but it does not support automatic failover.
- B. Correct.
Setting up a failover replica ensures high availability by automatically promoting the replica to the primary instance in the event of a failure.
- C. Correct.
Configuring automated backups is essential for disaster recovery, as it ensures data can be restored in case of failure or corruption.
- D. Incorrect.
Manually replicating data is not an effective or automated solution for high availability and failover in Cloud SQL.
- E. Correct.
Enabling point-in-time recovery allows you to recover data to a specific point in time, which is a critical disaster recovery feature.