What should you do?

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.)
A . Drop or disable all users except database administration users.
B . Disable all foreign key constraints on the source PostgreSQL database.
C . Ensure that all PostgreSQL tables have a primary key.
D . Shut down the database before the Data Migration Service task is started.
E . Ensure that pglogical is installed on the source PostgreSQL database.

Answer: C, E

Explanation:

https://cloud.google.com/database-migration/docs/postgres/faq

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments