To create a highly available Cloud SQL instance with PostgreSQL 13 in the europe-west1 region, which command correctly enables high availability?

hard📝 Best Practice Q8 of 15

GCP - Cloud SQL and Databases

To create a highly available Cloud SQL instance with PostgreSQL 13 in the europe-west1 region, which command correctly enables high availability?

Agcloud sql instances create ha-instance --database-version=POSTGRES_13 --region=europe-west1 --tier=db-n1-standard-2 --availability-type=ZONAL

Bgcloud sql instances create ha-instance --database-version=POSTGRES_13 --region=europe-west1 --tier=db-n1-standard-2 --availability-type=REGIONAL

Cgcloud sql instances create ha-instance --database-version=POSTGRES_13 --region=europe-west1 --tier=db-n1-standard-2

Dgcloud sql instances create ha-instance --zone=europe-west1-b --tier=db-n1-standard-2 --availability-type=REGIONAL

Step-by-Step Solution

Solution:

Step 1: Specify database version
Use POSTGRES_13 for PostgreSQL 13.
Step 2: Set region
Use --region=europe-west1 to specify the region.
Step 3: Enable high availability
Use --availability-type=REGIONAL to enable HA across zones.
Step 4: Choose appropriate tier
db-n1-standard-2 is a valid tier for production.
Final Answer:
gcloud sql instances create ha-instance --database-version=POSTGRES_13 --region=europe-west1 --tier=db-n1-standard-2 --availability-type=REGIONAL -> Option B
Quick Check:
High availability requires --availability-type=REGIONAL [OK]

Quick Trick: Use --availability-type=REGIONAL for high availability [OK]

Common Mistakes:

Master "Cloud SQL and Databases" in GCP

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More GCP Quizzes