You want to migrate your PostgreSQL database from another cloud provider to Cloud SQL. You plan on using Database Migration Service and need to assess the impact of any known limitations. What…

Question

Options

• AIdentify whether the database has over 512 tables.
• BIdentify all tables that do not have a primary key.
• CIdentity all tables that do not have at least one foreign key.
• DIdentify whether the source database is encrypted using pgcrypto extension.
• EIdentify whether the source database uses customer-managed encryption keys (CMEK).

• A
  17% (9)
• B
  70% (38)
• C
  4% (2)
• D
  9% (5)

Explanation

Option B is correct: Database Migration Service for PostgreSQL uses logical replication (pglogical) for continuous CDC. Tables without a primary key (or replica identity) cannot be replicated via logical replication - rows cannot be uniquely identified for UPDATE and DELETE operations, so this is a hard blocker that must be identified and resolved before migration. Option E is correct: If the source database uses customer-managed encryption keys (CMEK), the DMS service account must have permission to use those keys to read the encrypted data; failing to assess this will cause the migration to fail. Foreign keys (option C) and table count (option A) are not known DMS blockers. pgcrypto (option D) encrypts column values at the application level, not the storage level, so DMS reads the ciphertext as normal data.

No community discussion yet for this question.