Google Associate Cloud Engineer Question 250
Select 2Google Cloud PlatformYou are managing a MySQL database instance on Google Cloud SQL. The database is critical for your application's daily operations and you need to ensure minimal data loss in case of a failure. Which of the following steps should you perform to achieve this objective?
- A
Enable automated backups for the Cloud SQL instance.
- B
Manually export the database to a Cloud Storage bucket every day.
- C
Enable binary logging and configure point-in-time recovery.
- D
Use Google Cloud's built-in network firewall to secure the database.
- E
Increase the storage size of the database instance.
Show answer and explanation
Correct answers: A, C
Explanation
To ensure minimal data loss for your critical MySQL database on Google Cloud SQL, enabling automated backups and configuring point-in-time recovery are essential. Automated backups provide regular, reliable snapshots of your database, while point-in-time recovery allows you to restore your database to a precise state before a failure, minimizing data loss.
- A. Correct.
Enabling automated backups ensures that regular backups are taken without manual intervention, reducing the risk of human error and providing a reliable recovery point.
- B. Incorrect.
While exporting the database to Cloud Storage is a valid backup strategy, relying solely on manual exports can introduce human error and is not the most efficient method for ensuring minimal data loss.
- C. Correct.
Enabling binary logging allows you to perform point-in-time recovery, which is crucial for minimizing data loss in case of a failure by allowing you to restore the database to a specific point in time before the failure occurred.
- D. Incorrect.
Using network firewalls is important for securing your database, but it does not contribute directly to backup and restore processes.
- E. Incorrect.
Increasing the storage size of the database instance helps with capacity but is unrelated to backup and restore functionalities.