Google Cloud Professional Cloud Database Engineer PCDBE — Topic 1 Question 26

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

Correct answer: C, E. The correct answer is C, E. Option C: Ensure that all PostgreSQL tables have a primary key. Option E: Ensure that pglogical is installed on the source PostgreSQL database.

Google Cloud Professional Cloud Database Engineer PCDBE — Question 26