Question 25

Question

You plan to use Database Migration Service to migrate data from a PostgreSQL on-premises instance
to Cloud SQL. You need to identify the prerequisites for creating and automating the task. What
should you do? (Choose two.)

Accepted Answer

Ensure that all PostgreSQL tables have a primary key.

Sam R. · Answer

C or E. Similar question showed up in a practice test, and the official guide covers both as required for DMS with PostgreSQL.

Priya Q. · Answer

C and E tbh. Primary keys and pglogical are both needed for DMS with PostgreSQL according to docs.

Taylor G. · Answer

Why is B picked over E though? I thought pglogical is required for logical replication but not disabling foreign keys.

Nathan C. · Answer

My vote is it's C and E. You need primary keys for DMS to track changes, and pglogical has to be there for logical replication migrations with PostgreSQL. Disabling users or constraints isn't actually required, and you definitely don't have to shut down the source DB for DMS. Correct me if I'm off here.

Hannah S. · Answer

C and E tbh. Had something like this in a mock exam, those are the required steps for DMS with PostgreSQL.

Google Professional Cloud Database Engineer Real Exam Questions [October 2026 Update] Quiz

You plan to use Database Migration Service to migrate data from a PostgreSQL on-premises instance to Cloud SQL. You need to identify the prerequisites for creating and automating the task. What should you do? (Choose two.)

Premium Access Includes