Professional Cloud Database Engineer Postgresql Practice Questions

You need to migrate a 1 TB PostgreSQL database from a Compute Engine VM to Cloud SQL for PostgreSQL. You want to ensure that there is minimal downtime during the migration. What should you do?

• AA. Export the data from the existing database, and load the data into a new Cloud SQL database.
• BB. Use Migrate for Compute Engine to complete the migration.
• CC. Use Datastream to complete the migration.
• DD. Use Database Migration Service to complete the migration.

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

Select 2 answers.

• AA. Drop or disable all users except database administration users.
• BB. Disable all foreign key constraints on the source PostgreSQL database.
• CC. Ensure that all PostgreSQL tables have a primary key.
• DD. Shut down the database before the Data Migration Service task is started.
• EE. Ensure that pglogical is installed on the source PostgreSQL database.