Bird
0
0

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
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?
ARead replicas for reporting only
BManual backups scheduled daily
CHigh availability with automatic failover
DCustom machine types for performance tuning
Step-by-Step Solution
Solution:
  1. Step 1: Identify the feature for automatic recovery

    High availability with automatic failover ensures the database switches to a standby instance if hardware fails.
  2. 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.
  3. Final Answer:

    High availability with automatic failover -> Option C
  4. Quick 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

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More GCP Quizzes