You are configuring a Cloud SQL for PostgreSQL instance for a production application. The application is read-heavy. You need to ensure the database survives a zone failure and that read queries do not impact the performance of write queries. Which THREE configurations should you implement? (Select THREE)

Answer options:

Enable High Availability (HA)

Create a Read Replica

Route read queries to the Read Replica endpoint

Enable automated backups

Increase the CPU of the primary instance

Use Cloud Spanner instead

How to approach this question

Address both requirements: zone failure (HA) and read-heavy performance (Replicas).

Full Answer

Enable High Availability (HA), Create a Read Replica, Route read queries to the Read Replica endpoint

To survive a zone failure, High Availability (HA) must be enabled (which creates a synchronous standby in another zone). To prevent read queries from impacting writes, you must create a Read Replica AND configure your application logic to route SELECT statements to that replica.

Common mistakes

Assuming HA automatically load balances read queries (it does not; the standby is passive).

Question 41 All questions Question 43

Practice the full GCP Professional Cloud Architect Practice Exam 5

50 questions · hints · full answers · grading

More questions from this exam

Q01CASE STUDY: TechStream Gaming Overview: Gaming company, 500 employees, $100M revenue. 200 on-prem...Hard Q02CASE STUDY: TechStream Gaming Overview: Gaming company, 500 employees, $100M revenue. 200 on-prem...Medium Q03CASE STUDY: TechStream Gaming Overview: Gaming company, 500 employees, $100M revenue. 200 on-prem...Medium Q04CASE STUDY: TechStream Gaming Overview: Gaming company, 500 employees, $100M revenue. 200 on-prem...Medium Q05CASE STUDY: TechStream Gaming Overview: Gaming company, 500 employees, $100M revenue. 200 on-prem...Easy

View all 50 questions →