Google Associate Cloud Engineer Question 254
Select 2Google Cloud PlatformYour team is managing a MySQL database instance on Google Cloud SQL that is critical for your business operations. They need to ensure that they can restore the database to a specific point in time in case of data loss or corruption. Which of the following steps should be taken to achieve this goal?
- A
Enable automated backups for the Cloud SQL instance.
- B
Manually create a backup each time before making changes to the database.
- C
Enable point-in-time recovery by ensuring binary logging is enabled.
- D
Set up a daily export of the database to Google Cloud Storage.
Show answer and explanation
Correct answers: A, C
Explanation
To ensure point-in-time recovery in Google Cloud SQL, automated backups must be enabled, and binary logging must be activated. This setup allows you to restore the database to any point within the retention period. Manual backups and exports to Google Cloud Storage are useful for archiving and additional safety but do not support point-in-time recovery.
- A. Correct.
Automated backups are necessary to restore the database to a specific point in time using Cloud SQL.
- B. Incorrect.
While manual backups are useful, they do not allow for point-in-time recovery unless done before every single change.
- C. Correct.
Point-in-time recovery requires binary logging to be enabled, which allows transactions to be replayed to a specific point.
- D. Incorrect.
Daily exports to Google Cloud Storage provide a snapshot but do not support point-in-time recovery.