nerdexam
GoogleGoogle

PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #5

PROFESSIONAL-CLOUD-DATABASE-ENGINEER Question #5: Real Exam Question with Answer & Explanation

Sign in or unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to reveal the answer and full explanation for question #5. The question stem and answer options stay visible for context.

Optimizing Database Operations and Performance

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?

Options

  • AUse Cloud Load Balancing for load balancing between the Cloud SQL primary and read replica
  • BUse PgBouncer to set up database connection pooling between the Cloud SQL primary and read
  • CUse HTTP(S) Load Balancing for database connection pooling between the Cloud SQL primary
  • DUse the Cloud SQL Auth proxy for database connection pooling between the Cloud SQL primary

Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to see the answer

You've previewed enough free PROFESSIONAL-CLOUD-DATABASE-ENGINEER questions. Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Cloud SQL#Load Balancing#Read Replicas#Database Scalability
Full PROFESSIONAL-CLOUD-DATABASE-ENGINEER PracticeBrowse All PROFESSIONAL-CLOUD-DATABASE-ENGINEER Questions