PCDE Practice Question: Deploy scalable and highly available databases in Google Cloud
A company uses Cloud SQL for MySQL and wants to define backup retention policies for compliance. Which TWO statements about Cloud SQL backup retention are correct? (Choose 2)
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
✓
The maximum retention period for automated backups is 365 days.
Cloud SQL supports up to 365 automated backups and allows setting retention days up to 365. Point-in-time recovery also has a configurable retention.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
The maximum retention period for automated backups is 365 days.
Why this is correct
Correct: you can set retention days up to 365.
- ✗
Point-in-time recovery logs are retained for a maximum of 7 days.
Why it's wrong here
PITR log retention can be set up to 365 days.
- ✗
Automated backups are retained for a minimum of 7 days.
Why it's wrong here
Minimum retention is 1 day.
- ✓
The maximum number of automated backups retained is 365.
Why this is correct
Correct: Cloud SQL retains up to 365 automated backups.
- ✗
Backups are always stored in the same region as the database.
Why it's wrong here
Backups can be copied to another region.
Go deeper
Related to this question
About these practice questions
Courseiva writes every PCDE question from scratch — 1,446 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This PCDE practice question is part of Courseiva's free Google Cloud certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PCDE exam.