Q26 PostgreSQL Domain 2 · 25–30% of exam

A team needs to read-scale a write-heavy PostgreSQL database by routing SELECT queries to replicas. Which feature enables this?

  1. A Zone-redundant HA standby
  2. B Read replicas (up to 5 per primary) (correct answer)
  3. C Citus sharding
  4. D Connection pooling

Shortcut: Read replicas are asynchronous copies that can serve read workloads. Applications route read queries to replica endpoints, offloading the primary for writes.