Google Associate Cloud Engineer Question 253
Select 2Google Cloud PlatformAs a Google Cloud Associate Cloud Engineer, you need to ensure your Cloud SQL for PostgreSQL database instance is backed up daily and can be restored to any point in time within the last 7 days. Which of the following configurations should you implement to achieve this requirement?
- A
Enable automated backups and set the backup retention period to 7 days.
- B
Configure binary logging and set the point-in-time recovery retention period to 7 days.
- C
Manually create a SQL dump of the database daily using a cron job.
- D
Set up a Google Cloud Function to trigger backups at the end of each day.
Show answer and explanation
Correct answers: A, B
Explanation
To meet the requirement of being able to restore to any point in time within the last 7 days, it's crucial to enable both automated backups and point-in-time recovery. Automated backups ensure that daily backups are taken and retained for the specified period, while binary logging is necessary for point-in-time recovery, allowing you to restore the database to any specific point within the retention period.
- A. Correct.
Enabling automated backups with a retention period of 7 days ensures that you have daily backups retained for the specified duration, which is essential for point-in-time recovery.
- B. Correct.
Configuring binary logging and setting the point-in-time recovery retention period enables you to restore the database to any specific point within the last 7 days.
- C. Incorrect.
Manually creating a SQL dump does not support point-in-time recovery and is more prone to errors and maintenance overhead.
- D. Incorrect.
Using a Google Cloud Function to trigger backups could automate the backup process but does not inherently provide point-in-time recovery or manage retention automatically.