Google Cloud Professional Cloud Database Engineer PCDBE — Topic 1 Question 24

Question

You are running a mission-critical application on a Cloud SQL for PostgreSQL database with a multi-zonal setup. The primary and read replica instances are in the same region but in different zones. You need to ensure that you split the application load between both instances. What should you do?

Accepted Answer

Correct answer: B. The correct answer is B. Option B: Use PgBouncer to set up database connection pooling between the Cloud SQL primary and read replica instances. Cloud SQL is a managed relational database (MySQL/PostgreSQL/SQL Server) that handles patching, backups, and failover.

Google Cloud Professional Cloud Database Engineer PCDBE — Question 24