GCP - Cloud SQL and Databases
You need to restore a Cloud SQL instance to a point in time 2 hours ago. Which feature should you use?
You need to restore a Cloud SQL instance to a point in time 2 hours ago. Which feature should you use?
hard📝 Application Q9 of 15
Step-by-Step Solution
Solution:
Step 1: Understand point-in-time recovery
PITR allows restoring a database to a specific time, such as 2 hours ago.Step 2: Differentiate from other backup types
Automated backups restore to backup times, not arbitrary points; snapshots are disk-level; manual export is slower.Final Answer:
Point-in-time recovery (PITR) -> Option AQuick Check:
Restore to specific time = PITR [OK]
Quick Trick: Use PITR for precise time restores [OK]
Common Mistakes:
- Using automated backups for exact time restore
- Confusing disk snapshots with database restore
- Relying on manual export/import for quick recovery
Master "Cloud SQL and Databases" in GCP
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore GCP Quizzes