Notifications
Clear all
Topic starter
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.
Suggested Answer: C, E
Posted : 10/11/2022 3:03 am