Bird
0
0

You need to run a Cloud SQL instance that supports JSONB data type and advanced indexing. Which engine should you select?

hard📝 Application Q9 of 15
GCP - Cloud SQL and Databases
You need to run a Cloud SQL instance that supports JSONB data type and advanced indexing. Which engine should you select?
AMySQL 5.7
BSQL Server 2017
CPostgreSQL 13
DMySQL 8.0
Step-by-Step Solution
Solution:

  1. Step 1: Identify engine supporting JSONB and advanced indexing

    PostgreSQL supports JSONB data type and advanced indexing features.

  2. Step 2: Compare with other engines

    MySQL supports JSON but not JSONB; SQL Server does not support JSONB natively.

  3. Final Answer:

    PostgreSQL 13 -> Option C

  4. Quick Check:

    JSONB support = C [OK]
Quick Trick: Use PostgreSQL for JSONB and advanced indexing support [OK]
Common Mistakes:
  • Confusing JSON and JSONB support
  • Choosing MySQL for JSONB

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