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…

Question

Options

• ADrop or disable all users except database administration users.
• BDisable all foreign key constraints on the source PostgreSQL database.
• CEnsure that all PostgreSQL tables have a primary key.
• DShut down the database before the Data Migration Service task is started.
• EEnsure that pglogical is installed on the source PostgreSQL database.

• A
  14% (3)
• B
  10% (2)
• C
  71% (15)
• D
  5% (1)

Explanation

Database Migration Service (DMS) for PostgreSQL uses logical replication to continuously sync data. Two prerequisites are required: (C) All tables must have a primary key - DMS relies on primary keys to identify and replicate individual row changes during continuous migration. (E) The pglogical extension must be installed on the source PostgreSQL database - DMS uses pglogical to perform logical replication from the source instance. Dropping users (A) is unnecessary and disruptive. Disabling foreign key constraints (B) is not a DMS prerequisite. Shutting down the database (D) defeats the purpose of DMS, which is specifically designed for minimal-downtime live migrations.

No community discussion yet for this question.