You want a single managed database in Google Cloud to run transactional workloads and support analytics without changing the PostgreSQL DBMS, minimizing cost and complexity. Which target do you choose?
Choose an answer
Tap an option to check your answer.
Correct answer: Migrate workloads to AlloyDB for PostgreSQL..
Why this is the answer
AlloyDB for PostgreSQL is the correct choice because it's a fully managed, PostgreSQL-compatible database service designed for demanding transactional and analytical workloads. It offers superior performance and availability compared to standard PostgreSQL, making it ideal for both OLTP and OLAP without requiring a change in the DBMS or application code. This minimizes complexity and cost by consolidating workloads onto a single, high-performance platform. Migrating to Cloud Spanner would involve significant schema and application changes as it's a globally distributed, strongly consistent database, not a direct PostgreSQL replacement. Migrating to BigQuery is incorrect because BigQuery is an analytical data warehouse, not a transactional database, and cannot run OLTP workloads. Migrating to Cloud SQL for PostgreSQL would maintain the DBMS but wouldn't offer the same performance or analytical capabilities as AlloyDB for demanding hybrid workloads.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed