PCD Integrating Google Cloud services Practice Question

Your company uses Cloud SQL for MySQL to store transactional data. You need to perform a point-in-time recovery (PITR) to recover from a logical error that occurred 30 minutes ago. Which two prerequisites must be met? (Choose TWO.)

⚠ Common exam trap

Google Cloud often tests the misconception that high availability or read replicas are required for point-in-time recovery, when in fact only binary logging and automated backups are necessary.

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

✓

Binary logging is enabled.

Point-in-time recovery (PITR) for Cloud SQL for MySQL relies on binary logs to replay transactions up to a specific timestamp. Binary logging must be enabled because it records all changes to the database, allowing you to restore to any point within the retention period. Automated backups are also required because PITR uses the most recent full backup as a base, then applies binary logs from that backup to the target time. Without automated backups, there is no base image to start the recovery process.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

✗
High availability (HA) is configured.
Why it's wrong here
HA is not required.
✓
Binary logging is enabled.
Why this is correct
Binary logs enable PITR.
✓
Automated backups are enabled.
Why this is correct
Backups are the base for PITR.
✗
The backup window is set to a time before the incident.
Why it's wrong here
Backup window does not affect PITR capability.
✗
A read replica is configured.
Why it's wrong here
Read replicas are not needed.

Go deeper

PCD Integrating Google Cloud services Practice Question

Why each option matters

Option-by-option breakdown

Related to this question