Bird
0
0

You create a Cloud SQL instance with engine set to POSTGRES_14. What is the expected behavior when connecting with a PostgreSQL client?

medium📝 service behavior Q4 of 15
GCP - Cloud SQL and Databases
You create a Cloud SQL instance with engine set to POSTGRES_14. What is the expected behavior when connecting with a PostgreSQL client?
AConnection succeeds with PostgreSQL 14 features available
BConnection fails because POSTGRES_14 is unsupported
CConnection succeeds but only PostgreSQL 9 features are available
DConnection succeeds but only MySQL features are available
Step-by-Step Solution
Solution:

  1. Step 1: Understand engine version support

    Cloud SQL supports PostgreSQL 14, so the instance runs that version.

  2. Step 2: Predict client connection behavior

    Connecting with a PostgreSQL client to a PostgreSQL 14 instance succeeds with full PostgreSQL 14 features.

  3. Final Answer:

    Connection succeeds with PostgreSQL 14 features available -> Option A

  4. Quick Check:

    PostgreSQL 14 engine = B [OK]
Quick Trick: Use matching client for Cloud SQL engine version [OK]
Common Mistakes:
  • Assuming unsupported version
  • Confusing engine features across versions

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More GCP Quizzes
Cloud Firestore and Bigtable - Firestore queries and indexes - Quiz 9hard Cloud Firestore and Bigtable - Bigtable for time-series data - Quiz 12easy Cloud Functions - Why serverless functions matter - Quiz 10hard Cloud Load Balancing - Health checks configuration - Quiz 6medium Cloud Load Balancing - TCP/UDP Load Balancer (Layer 4) - Quiz 9hard Cloud Load Balancing - URL maps for routing - Quiz 8hard Cloud Run - Request-based auto scaling - Quiz 5medium Cloud Run - Cloud Run jobs for batch work - Quiz 5medium Cloud SQL and Databases - Why managed databases matter - Quiz 2easy Cloud SQL and Databases - Cloud SQL pricing - Quiz 5medium