Skip to content
PCA Practice
SQ38

A team migrating a PostgreSQL-heavy workload needs the highest possible performance for mixed transactional and analytical queries, but only within a single region. Which database should they evaluate?

  1. AAlloyDB for PostgreSQL
  2. BCloud Spanner
  3. CBigtable
  4. DCloud SQL for PostgreSQL
Show answer

Answer: A

AlloyDB is a PostgreSQL-compatible, high-performance database designed for demanding transactional and analytical workloads within a single region. It outperforms standard Cloud SQL for PostgreSQL and doesn't require schema changes. Spanner requires migration from PostgreSQL dialect.

← SQ37Practice this topicSQ39 →