GCP Associate Cloud Engineer Practice Question

Your retail analytics platform currently runs on a self-managed PostgreSQL 12 cluster that supports both high-volume order processing and daily ad-hoc analytical queries. As you migrate to Google Cloud, you need a fully managed service that:

Remains fully compatible with PostgreSQL and its extensions, so the application code and queries require minimal changes.
Delivers a 99.95 % availability SLA in a regional high-availability configuration.
Can automatically create low-latency, highly scalable read pools to serve analytical traffic.
Provides up to a 4× increase in throughput compared with standard PostgreSQL.

Which Google Cloud product best meets these requirements?

AlloyDB for PostgreSQL
Cloud SQL for PostgreSQL with high availability
Spanner with the PostgreSQL interface
BigQuery

Report Issue

Answer Description

AlloyDB for PostgreSQL is a fully managed, PostgreSQL-compatible database designed for high-performance transactional and analytical workloads. Configured for regional high availability, it offers a 99.95 % availability SLA and can automatically create scalable read pools. Benchmarks show up to 4× higher throughput than standard PostgreSQL, all while maintaining wire-protocol and extension compatibility, allowing applications to migrate with minimal changes.

Cloud SQL for PostgreSQL is also fully managed and PostgreSQL-compatible, but its high-availability SLA is 99.95 % without the same performance gains or automatic read pools. Spanner with the PostgreSQL interface provides higher availability (up to 99.999 %) and horizontal scale but usually requires schema or SQL adjustments. BigQuery is optimized for OLAP analytics rather than the mixed OLTP/OLAP workload described and is not a direct replacement for PostgreSQL.

Ask Bash

Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.