You want to restore a Cloud SQL instance prod-db to a previous state using a backup from June 1, 2024. Which sequence of steps correctly achieves this with minimal downtime?
hard📝 Best Practice Q15 of 15
GCP - Cloud SQL and Databases
You want to restore a Cloud SQL instance prod-db to a previous state using a backup from June 1, 2024. Which sequence of steps correctly achieves this with minimal downtime?
ARestore the backup directly to the current instance while it is serving traffic
BDelete the current instance, then restore the backup to the same instance name immediately
CExport the backup to Cloud Storage, then import it back to the instance
DCreate a new instance from the backup, then switch your application to use the new instance
Step-by-Step Solution
Solution:
Step 1: Understand restore options for minimal downtime
Restoring directly to a live instance causes downtime; better to create a new instance.
Step 2: Create new instance from backup and switch traffic
Create a new instance restored from backup, then update your app to use it, minimizing downtime.
Final Answer:
Create a new instance from the backup, then switch your application to use the new instance -> Option D
Quick Check:
New instance restore + switch = minimal downtime [OK]
Quick Trick:Restore to new instance, then switch app to avoid downtime [OK]
Common Mistakes:
Deleting instance before restore causing data loss
Restoring live instance causing service interruption
Using export/import which is slower and more complex
Master "Cloud SQL and Databases" in GCP
9 interactive learning modes - each teaches the same concept differently
