Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Question 24 of 51
Free Preview · 51 of 170 · questions 1–51 of 170 are free. Sign up free to sync your progress across devices.
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
https://www.pgbouncer.org/faq.html says pgbouncer cannot handle multi-host configs, so B is out. C is out because there's nothing involving HTTP, D is out because the auth proxy does not provide connection pooling.
Cloud SQL doesn't provide load balancing between replicas. You can choose to implement load balancing for your Cloud SQL instance. You can also use connection pooling to distribute queries across replicas with your load balancing setup for better performance. https://cloud.google.com/sql/docs/postgres/replication#:~:text=Cloud%20SQL%20doesn't%20provide,balancing%20setup%20for%20better%20performance.&text=You%20can't%20configure%20maintenance%20windows%20on%20a%20read%20replica.
Should be A. Pgbouncer needs a load balancer or DNS roundrobin in front of it to operate. It can't route the traffic to multiple hosts without it. C, D are wrong.