Google Cloud Professional Cloud Database Engineer — Question 105

You are configuring a brand new Cloud SQL for PostgreSQL database instance in Google Cloud. Your application team wants you to deploy one primary instance, one standby instance, and one read replica instance. You need to ensure that you are following Google-recommended practices for high availability. What should you do?

Answer options

• A. Configure the primary instance in zone A, the standby instance in zone C, and the read replica in zone B, all in the same region.
• B. Configure the primary and standby instances in zone A and the read replica in zone B, all in the same region.
• C. Configure the primary instance in one region, the standby instance in a second region, and the read replica in a third region.
• D. Configure the primary, standby, and read replica instances in zone A, all in the same region.

Correct answer: A

Explanation

The correct answer is A because it ensures that the primary instance is protected against failure by having the standby instance in a different zone, which is a Google-recommended practice for high availability. Options B and D do not provide zone redundancy for the standby instance, and option C unnecessarily spreads instances across multiple regions, which can introduce latency and complexity.