Google Professional Cloud Database Engineer Question 157
Single answerGoogle Cloud PlatformYour company is running a mission-critical application on Google Cloud that uses Cloud SQL for its database. The application needs to meet a Recovery Time Objective (RTO) of 5 minutes and a Recovery Point Objective (RPO) of 10 minutes. Which configuration should you implement to meet these requirements?
- A
Enable automated backups and set a retention period of 7 days.
- B
Configure point-in-time recovery and enable binary logging.
- C
Replicate the database to a read replica in another region.
- D
Set up high availability (HA) for the Cloud SQL instance.
Show answer and explanation
Correct answer: B
Explanation
To meet the specified RTO of 5 minutes and RPO of 10 minutes, you need a solution that allows granular recovery to a specific point in time. Configuring point-in-time recovery with binary logging enables you to recover the database to within seconds or minutes of a failure. This satisfies both the RTO and RPO requirements for the mission-critical application.
- A. Incorrect.
Automated backups are useful for data recovery, but they do not provide the granularity required to meet an RPO of 10 minutes. They are typically used for daily backups, which cannot meet the specified RPO.
- B. Correct.
Point-in-time recovery with binary logging allows you to recover the database to a very specific point in time within a few minutes, effectively meeting the RPO of 10 minutes and RTO of 5 minutes.
- C. Incorrect.
Read replicas are primarily used for scaling read operations and can provide disaster recovery for certain scenarios, but they do not support write operations and cannot independently meet the RPO and RTO requirements.
- D. Incorrect.
High availability ensures minimal downtime in case of instance failure, which is helpful for meeting RTO. However, it does not address data recovery requirements (RPO).