GCP - Cloud SQL and Databases
You want to create a highly available Cloud SQL instance with PostgreSQL 13 in region us-central1. Which command correctly sets up a primary instance with high availability enabled?
You want to create a highly available Cloud SQL instance with PostgreSQL 13 in region us-central1. Which command correctly sets up a primary instance with high availability enabled?
hard📝 Application Q15 of 15
Step-by-Step Solution
Solution:
Step 1: Identify flag for high availability
The correct flag to enable high availability in Cloud SQL is--availability-type=REGIONAL.Step 2: Confirm other parameters
Database version POSTGRES_13 and region us-central1 are valid. The command uses correct syntax for creating a highly available instance.Final Answer:
gcloud sql instances create ha-instance --database-version=POSTGRES_13 --region=us-central1 --availability-type=REGIONAL -> Option AQuick Check:
Use --availability-type=REGIONAL for HA [OK]
Quick Trick: Use --availability-type=REGIONAL to enable high availability [OK]
Common Mistakes:
- Using non-existent flags like --high-availability
- Confusing replica-type with availability
- Using incorrect availability flag names
Master "Cloud SQL and Databases" in GCP
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore GCP Quizzes