Exam Professional Cloud Database Engineer topic 1 question 44 discussion

A is correct. We only have 8000 tables. More than 1 HA env is only required beyond 50000 tables If you have 50,000 or more database tables on a single instance, it could result in the instance becoming unresponsive or unable to perform maintenance operations, and the instance is not covered by the SLA.

A. B and D do not mention HA, so eliminate those. That leaves A and C. C talks about 4 instances with HA which presumably means 2 primaries each with an HA standby. Oddly, there are 4 zones in us-central1. The killer is having a read replica also in us-central1 which would mean the same zone would have a read replica and either a primary or HA standby. Not a good idea. Option A is the best choice. A primary and an HA standby in us-central1 (different zones) and then read replicas in us-east1 and us-west1.

The question said to minimize read AND write latency, and that doesn't occur obviously with Read Replicas. The only solution that minimizes both R&W latency AND covers the regions is C. Answer A is invalid for that.

as I focus on low latency

The answer is C. you need a instance for a read replica not 2 per read replica.

Answer C is wrong because the question suggests low-latency and replication for 4 region INCREASE latency. Answer A is correct because attend the two requirements high availability and low latency. The Key for this question is low latency.

The correct answer is == C. Deploy 4 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-central1, us-east1, and us-west1.

This option provides high availability with four instances in the primary region, ensuring redundancy and fault tolerance. By creating read replicas in us-central1, us-east1, and us-west1, read operations can be distributed across multiple regions, reducing latency for applications in those regions. This design allows for efficient and low-latency read operations while maintaining high availability. Option C is the recommended choice as it combines HA with multiple read replicas in different regions, providing both high availability and low-latency read operations for your multi-region application setup.

Why not " C" is an answer

A: Deploy 2 Cloud SQL instances in the us-central1 region ***** with HA enabled, and create read replicas in us-east1 and us-west1.

We only need options with HA enabled and 4 databases with 3 read replicas (each?) seems overkill to me.