Google Cloud Professional Cloud Database Engineer — Question 31

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

Answer options

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

Correct answer: C, E

Explanation

The correct answers are C and E because ensuring that all tables have a primary key (C) is vital for the migration process, as it helps maintain data integrity. Additionally, having pglogical installed (E) is necessary for the logical replication required by the Database Migration Service. The other options, while potentially relevant in different contexts, are not prerequisites for this specific migration task.