Answer-first summary for fast verification
Answer: Ensure that all PostgreSQL tables have a primary key., Ensure that pglogical is installed on the source PostgreSQL database.
To successfully migrate data from a PostgreSQL on-premises instance to Cloud SQL using Database Migration Service, certain prerequisites must be met. Option E is correct because pglogical is a PostgreSQL extension that provides logical replication and is required for the Database Migration Service to replicate data from the source to the target. Option C is also correct as having primary keys on all tables is crucial for ensuring data integrity and avoiding issues during the migration process. Dropping or disabling users (Option A) is not a prerequisite but a security measure that might be considered. Disabling foreign key constraints (Option B) is not recommended as it can lead to data integrity issues. Shutting down the database (Option D) is not necessary and would cause downtime, which is against the purpose of using a migration service for minimal downtime migrations.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What are two prerequisites for setting up and automating a Database Migration Service task to move data from an on-premises PostgreSQL instance to Cloud SQL?
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.
No comments yet.