GCP Professional Data Engineer Practice Question

Your on-premises data center hosts a 2-TB PostgreSQL 11 database that serves a high-traffic e-commerce website. The application relies on complex joins, stored procedures, and strict ACID transactions. Management wants the database moved to Google Cloud within three months with minimal code changes. Requirements are: single-region primary, cross-region low-latency read replica for disaster recovery (RPO ≤ 5 minutes, RTO ≤ 1 hour), and as little operational overhead as possible. Which managed Google Cloud service best meets these needs?

Spanner regional instance with a read-only replica in a second region
Cloud SQL for PostgreSQL with an HA primary instance and cross-region read replica
Bigtable multi-cluster instance spread across two regions
BigQuery table partitioned by region with scheduled replication

Report Issue

Answer Description

Cloud SQL for PostgreSQL is a fully managed service that offers native PostgreSQL compatibility, so the existing application and stored procedures work without refactoring. It supports cross-region read replicas created from an HA primary, giving a typical RPO of only a few minutes and an RTO under an hour when promoted. Spanner and Bigtable require rewrites (Spanner lacks stored procedures; Bigtable is NoSQL). BigQuery is an analytical warehouse, not a transactional store. Therefore, Cloud SQL for PostgreSQL satisfies all functional and operational requirements.

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.