Google Professional Cloud Database Engineer Exam - Topic 5 Question 79 Discussion

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.)

Wynell · Accepted Answer

C) Ensure that all PostgreSQL tables have a primary key. and E) Ensure that pglogical is installed on the source PostgreSQL database.

Wynell · Answer

A) Drop or disable all users except database administration users.

Wynell · Answer

B) Disable all foreign key constraints on the source PostgreSQL database.

Wynell · Answer

D) Shut down the database before the Data Migration Service task is started.