Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Google Associate Cloud Engineer Exam - Topic 1 Question 126 Discussion

Your company plans to migrate its on-premises PostgreSQL database to Google Cloud. The workloads are demanding, requiring fast transactional and analytical performance. You need to select a fully managed database service on Google Cloud. Your solution must also be able to synchronously replicate and optimize the storage layer. What should you do?
B) Migrate the database to AlloyDB for PostgreSQL by using Database Migration Service.
A) Use the psql client installed on a Compute Engine Instance. Connect to the Cloud SQL instance to perform the database migration.
C) Migrate the database to Cloud SQL for PostgreSQL by using Database Migration Service.
D) Create a Compute Engine instance. Install and configure PostgreSQL on the instance, and migrate the database.

Google Associate Cloud Engineer Exam - Topic 1 Question 126 Discussion

Actual exam question for Google's Associate Cloud Engineer exam
Question #: 126
Topic #: 1
[All Associate Cloud Engineer Questions]

Your company plans to migrate its on-premises PostgreSQL database to Google Cloud. The workloads are demanding, requiring fast transactional and analytical performance. You need to select a fully managed database service on Google Cloud. Your solution must also be able to synchronously replicate and optimize the storage layer. What should you do?

Show Suggested Answer Hide Answer
Suggested Answer: B

Comprehensive and Detailed Explanation From Exact Extract:

The requirements point to the highest performance tier for a managed PostgreSQL-compatible database, specifically citing demands for transactional and analytical performance, synchronous replication, and storage optimization.

AlloyDB for PostgreSQL is Google Cloud's highly specialized, fully managed database that is optimized for demanding enterprise workloads. It is superior to standard Cloud SQL for performance and architectural features like synchronous replication and an optimized storage layer, directly matching all the stated requirements.

Database Migration Service (DMS) is the recommended tool for performing the migration itself.


'AlloyDB for PostgreSQL is a fully managed PostgreSQL-compatible database service that is designed for demanding enterprise workloads... [It] delivers high availability and synchronous replication for better data protection and faster failover.'

'Database Migration Service (DMS) simplifies your database migrations to Cloud SQL and AlloyDB.'

by Lai at Aug 14, 2026, 11:23 PM

Limited Time Offer

25%

Off

Get Premium Associate Cloud Engineer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel

Currently there are no comments in this discussion, be the first to comment!


Save Cancel