Answer-first summary for fast verification
Answer: Set up read replicas in different zones of the same region as the primary instance with synchronous replication, and set up read replicas in different regions with asynchronous replication.
To meet the requirement of a recovery time objective (RTO) and recovery point objective (RPO) in minutes and ensure high availability and disaster recovery without data loss during a zonal or regional failure, the best approach is to set up read replicas in different zones of the same region as the primary instance with synchronous replication, and set up read replicas in different regions with asynchronous replication. This configuration ensures that in the event of a zonal failure, the synchronous replication within the same region allows for quick failover with minimal data loss. For a regional failure, the asynchronous replication to a different region ensures that data is preserved, albeit with a potential for some data loss due to the nature of asynchronous replication. This setup balances the need for quick recovery within the same region and data preservation across regions.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How can you configure Cloud SQL for MySQL to meet a high availability and disaster recovery design with an RTO and RPO in minutes, ensuring no data loss during zonal or regional failures for your retail online delivery business?
A
Set up all read replicas in a different region using asynchronous replication.
B
Set up all read replicas in the same region as the primary instance with synchronous replication.
C
Set up read replicas in different zones of the same region as the primary instance with synchronous replication, and set up read replicas in different regions with asynchronous replication.
D
Set up read replicas in different zones of the same region as the primary instance with asynchronous replication, and set up read replicas in different regions with synchronous replication.
No comments yet.