Google Cloud SQL - Read replicas in Cloud SQL MCQ

Google Cloud SQL – 12 – Read replicas in Cloud SQL MCQ

1 / 10

1. What is the primary purpose of read replicas in Google Cloud SQL?

Reducing data redundancy

Increasing write performance

Ensuring data consistency

Enhancing read performance

2 / 10

2. Which type of queries are read replicas designed to handle in Google Cloud SQL?

Read queries

Both read and write queries

Write queries

Administrative queries

3 / 10

3. How do read replicas in Google Cloud SQL replicate data from the primary instance?

Synchronously

In real-time

Through binary logging

Asynchronously

4 / 10

4. What is the primary benefit of offloading read traffic to read replicas?

Reduced data redundancy

Enhanced query performance

Reduced resource utilization

Improved write performance

5 / 10

5. In Google Cloud SQL, what happens to the primary instance when you create a read replica?

It remains unchanged

It becomes a failover replica

It becomes a read-only instance

It is automatically scaled up

6 / 10

6. What is replication lag in the context of read replicas in Google Cloud SQL?

The duration of a maintenance window

The delay between changes

The process of promoting a replica

The time it takes to create a replica

7 / 10

7. What is the purpose of monitoring replication lag in Google Cloud SQL?

Reducing database costs

Promoting read replicas

Enhancing write performance

Ensuring data consistency

8 / 10

8. How can you create a read replica in Google Cloud SQL using the Google Cloud Console?

By adjusting the read-write split in your application

By enabling binary logging

By promoting a failover replica

By using the "Create read replica" button

9 / 10

9. What type of operation should you use to promote a read replica to the primary instance in Google Cloud SQL?

Enable binary logging

Execute an SQL query

Use the "Promote" button

Adjust font size in Cloud Console

10 / 10

10. What is the recommended use case for read replicas in Google Cloud SQL?

Write-heavy workloads

Administrative tasks

Read-heavy workloads

Creating failover replicas

Your score is

Google Cloud SQL – Read replicas in Cloud SQL MCQ