Google Cloud Professional Cloud Database Engineer — Question 98

Your online delivery business that primarily serves retail customers uses Cloud SQL for MySQL for its inventory and scheduling application. The required recovery time objective (RTO) and recovery point objective (RPO) must be in minutes rather than hours as a part of your high availability and disaster recovery design. You need a high availability configuration that can recover without data loss during a zonal or a regional failure. What should you do?

Answer options

• 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.

Correct answer: C

Explanation

Option C is correct because it combines synchronous replication for local read replicas, ensuring no data loss within the region, and asynchronous replication for regional read replicas, providing high availability across regions. Option A fails to meet the RTO/RPO requirements due to its reliance on asynchronous replication across regions. Option B is inadequate because it does not provide redundancy in different regions, risking data loss during a regional failure. Option D incorrectly uses asynchronous replication for local replicas, which could lead to potential data loss.