Bird
0
0

You want to optimize read performance for a global user base using Cloud SQL read replicas. Which strategy best achieves low read latency worldwide?

hard📝 Architecture Q8 of 15
GCP - Cloud SQL and Databases

You want to optimize read performance for a global user base using Cloud SQL read replicas. Which strategy best achieves low read latency worldwide?

ADeploy multiple read replicas in regions close to users and configure application routing accordingly
BCreate a single read replica in the same region as the primary instance
CUse only the primary instance and rely on caching at the application layer
DSet up read replicas in random regions without adjusting application routing
Step-by-Step Solution
Solution:

  1. Step 1: Understand read latency reduction

    Placing read replicas geographically closer to users reduces network latency.

  2. Step 2: Application routing

    Routing read queries to the nearest replica ensures users experience lower latency.

  3. Step 3: Evaluate options

    Deploy multiple read replicas in regions close to users and configure application routing accordingly aligns with best practices for global read scaling.

  4. Final Answer:

    Deploy multiple read replicas in regions close to users and configure application routing accordingly -> Option A

  5. Quick Check:

    Multiple regional replicas + routing = low latency reads [OK]
Quick Trick: Place replicas near users and route reads accordingly [OK]
Common Mistakes:
  • Using a single replica in one region for global users
  • Ignoring application routing to replicas
  • Relying solely on caching without replicas

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More GCP Quizzes
Cloud Firestore and Bigtable - Memorystore for Redis caching - Quiz 14medium Cloud Firestore and Bigtable - Real-time updates with listeners - Quiz 1easy Cloud Firestore and Bigtable - Real-time updates with listeners - Quiz 14medium Cloud Functions - Environment variables and secrets - Quiz 12easy Cloud IAM Advanced - IAM deny policies - Quiz 13medium Cloud Pub/Sub - Message ordering - Quiz 4medium Cloud Pub/Sub - Message retention and acknowledgment - Quiz 13medium Cloud SQL and Databases - Creating a Cloud SQL instance - Quiz 2easy Cloud SQL and Databases - Backup and restore - Quiz 11easy Cloud SQL and Databases - Creating a Cloud SQL instance - Quiz 8hard