GCP - Cloud SQL and Databases
You want to ensure your managed Cloud SQL database automatically recovers from hardware failures without manual intervention. Which feature should you enable?
You want to ensure your managed Cloud SQL database automatically recovers from hardware failures without manual intervention. Which feature should you enable?
hard📝 Best Practice Q15 of 15
Step-by-Step Solution
Solution:
Step 1: Identify the feature for automatic recovery
High availability with automatic failover ensures the database switches to a standby instance if hardware fails.Step 2: Evaluate other options
Manual backups do not provide automatic recovery; read replicas are for scaling reads; custom machines tune performance but not recovery.Final Answer:
High availability with automatic failover -> Option CQuick Check:
Automatic failover = automatic recovery [OK]
Quick Trick: Enable automatic failover for no-downtime recovery [OK]
Common Mistakes:
- Confusing backups with automatic failover
- Using read replicas for failover
- Thinking custom machines handle 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