Bird
0
0

What is the main purpose of a read replica in Google Cloud SQL?

easy📝 Conceptual Q11 of 15
GCP - Cloud SQL and Databases

What is the main purpose of a read replica in Google Cloud SQL?

ATo copy the main database and handle read requests to reduce load
BTo store backups of the database for disaster recovery
CTo serve as a primary database for write operations
DTo encrypt data stored in the database
Step-by-Step Solution
Solution:

  1. Step 1: Understand the role of read replicas

    Read replicas copy data from the main database and serve read requests to reduce load on the primary instance.

  2. Step 2: Differentiate from other database roles

    Backups and encryption are different features; read replicas do not handle writes.

  3. Final Answer:

    To copy the main database and handle read requests to reduce load -> Option A

  4. Quick Check:

    Read replica purpose = reduce load by handling reads [OK]
Quick Trick: Read replicas handle reads to reduce main database load [OK]
Common Mistakes:
  • Confusing read replicas with backups
  • Thinking read replicas handle writes
  • Assuming read replicas encrypt data

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