Google Professional Cloud Database Engineer Question 142
Select 3Google Cloud PlatformYour company uses Cloud SQL for MySQL to store critical business data. To ensure minimal downtime and data loss in case of a regional failure, you need to design a backup and recovery solution. The solution must include automated backups, point-in-time recovery, and the ability to failover to another region if needed. Which combination of actions will meet these requirements?
- A
Enable automated backups for the Cloud SQL instance.
- B
Configure binary log (binlog) replication for point-in-time recovery.
- C
Set up a read replica in another region and promote it to a standalone instance during failure.
- D
Manually export the database to Cloud Storage on a daily basis.
- E
Create a Cloud SQL instance in another region and schedule daily SQL dumps to it.
Show answer and explanation
Correct answers: A, B, C
Explanation
To design an effective backup and recovery solution for Cloud SQL with minimal downtime, you need to enable automated backups for regular snapshots, configure binary log replication for point-in-time recovery, and set up a read replica in another region for high availability. These actions ensure a resilient, automated, and reliable recovery process in case of a failure.
- A. Correct.
Enabling automated backups is essential for ensuring that regular backups are created, allowing you to restore data to a specific point in time.
- B. Correct.
Binary log replication is required for point-in-time recovery, as it allows the database to replay transactions up to a specific moment.
- C. Correct.
Setting up a read replica in another region provides a near-real-time copy of the database, and promoting it to a standalone instance ensures high availability during a regional failure.
- D. Incorrect.
Manually exporting the database to Cloud Storage is a valid backup method but does not support point-in-time recovery or automated failover.
- E. Incorrect.
Creating a Cloud SQL instance in another region and using daily SQL dumps is inefficient and does not meet the requirements for minimal downtime or point-in-time recovery.