Google Cloud SQL - Cross-region replication in Cloud SQL MCQ

Google Cloud SQL – 36 – Cross-region replication in Cloud SQL MCQ

1 / 17

1. What is Cross-Region Replication in Google Cloud SQL?

A query optimization method

Replicating data to secondary instances in different regions

A database compression technique

A data transfer process between different databases

2 / 17

2. What is the primary benefit of Cross-Region Replication?

Increasing query performance

Enhancing data availability and disaster recovery

Automating backup scheduling

Reducing storage costs

3 / 17

3. What are secondary instances created through Cross-Region Replication called?

Primary replicas

Read-only replicas

Read replicas

Backup instances

4 / 17

4. How do read replicas in Cross-Region Replication stay synchronized with the primary instance?

By using separate databases

They don't need synchronization

Through manual data transfers

Through automated data replication

5 / 17

5. What role do read replicas play in Cross-Region Replication?

Compressing data for storage efficiency

Distributing read traffic, improving query performance

Automating backups for the primary instance

Distributing write traffic to the primary instance

6 / 17

6. Which feature can enhance disaster recovery in Cross-Region Replication?

Reducing replication lag

Automated failover

Data compression

Scaling the primary instance

7 / 17

7. How can you create a read replica in a different region in Google Cloud SQL?

By enabling cross-region sync in the primary instance

By exporting the database to a local file

By manually copying the database

By creating a new instance in a different region

8 / 17

8. What is the purpose of enabling automatic failover in Cross-Region Replication?

Minimizing downtime in case of primary instance failure

Automating backup scheduling

Optimizing query performance

Reducing storage costs

9 / 17

9. What is replication lag in the context of Cross-Region Replication?

The frequency of backups

The delay between data changes on the primary instance and the read replica

The time it takes to compress data

The time it takes to create a read replica

10 / 17

10. Why is regional selection important in Cross-Region Replication?

To optimize database performance

To select the most powerful instance type

To reduce data transfer costs

To align with target audience and disaster recovery needs

11 / 17

11. How can you monitor the replication lag of a read replica in Google Cloud SQL?

By running SQL queries

By checking the instance's hardware status

Through the Google Cloud SQL Console

By exporting logs to Google Cloud Storage

12 / 17

12. What does “eventual consistency” mean in the context of Cross-Region Replication?

Data consistency is always guaranteed

Data consistency is ensured by regular audits

Data consistency is irrelevant

Data consistency may not be immediately guaranteed

13 / 17

13. What is the significance of scaling read replicas in Cross-Region Replication?

To increase storage efficiency

To handle increased read traffic

To automate data compression

To minimize replication lag

14 / 17

14. Which practice is NOT recommended for managing Cross-Region Replication effectively?

Enabling automatic failover for critical applications

Adjusting configuration based on workload changes

Reducing the number of read replicas

Regularly monitoring replication lag

15 / 17

15. What’s the primary focus of SSL/TLS encryption in the context of Cross-Region Replication?

Data storage optimization

Data compression

Data security during transfer

Data format conversion

16 / 17

16. Which Google Cloud service is often used alongside Cross-Region Replication for data analysis?

Google Cloud Functions

Google Cloud Storage

Google Cloud Pub/Sub

Google BigQuery

17 / 17

17. What is the role of a retry strategy in the context of Cross-Region Replication?

To automate data compression

To reduce replication lag

To handle errors and recover from failures

To ensure data consistency

Your score is

Google Cloud SQL – Cross-region replication in Cloud SQL MCQ