Google Associate Cloud Engineer Question 251
Select 3Google Cloud PlatformYou are managing a MySQL database instance on Google Cloud SQL for your company's e-commerce application. To ensure data safety, you need to set up a backup and restore strategy. Which of the following steps should you take to configure automated backups and be able to restore the database to a specific point in time?
- A
Enable automated backups in the Cloud SQL instance settings.
- B
Configure binary logging for the Cloud SQL instance.
- C
Manually create SQL dump files and upload them to Cloud Storage.
- D
Use Cloud SQL Export feature to regularly export data to Cloud Storage.
- E
Set retention settings to retain backups for at least 7 days.
Show answer and explanation
Correct answers: A, B, E
Explanation
To effectively back up and restore a Cloud SQL database, enabling automated backups and configuring binary logging are essential steps. Automated backups provide daily snapshots of the database, while binary logging is necessary for point-in-time recovery. Additionally, setting appropriate retention policies ensures that backups are available for a required duration, providing flexibility in restoring data.
- A. Correct.
Enabling automated backups ensures that daily backups are created for the Cloud SQL instance, allowing you to restore the database to the most recent backup.
- B. Correct.
Configuring binary logging is necessary to enable point-in-time recovery, allowing you to restore the database to a specific state at any time.
- C. Incorrect.
Manually creating SQL dump files is a manual process and does not integrate with Cloud SQL's automated backup features, making it less suitable for automated backup and restore strategies.
- D. Incorrect.
Using the Cloud SQL Export feature is useful for exporting data but does not provide point-in-time recovery capabilities.
- E. Correct.
Setting retention settings ensures that backups are stored for a sufficient period, allowing you to restore from an older backup if necessary.