PCDE Migrate data solutions Practice Question
A company is migrating an on-premises PostgreSQL database to Cloud SQL using Database Migration Service with continuous replication. The source database has binary logging enabled and uses the pglogical plugin. The migration job is failing after the full dump phase. Which THREE common issues should the engineer check? (Choose 3 correct answers.)
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
The source database is not configured for logical replication (e.g., wal_level is not logical).
For PostgreSQL CDC migration, DMS uses pglogical. Common issues include: logical replication slot not created or exhausted, insufficient disk space for WAL files, and network connectivity issues (e.g., firewall blocking replication port 5432). Cloud SQL Auth Proxy is not needed for DMS to Cloud SQL connectivity if using private IP/peering. Source database must be PostgreSQL, not MySQL.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
The source database is not configured for logical replication (e.g., wal_level is not logical).
Why this is correct
Logical replication requires wal_level=logical.
- ✓
Insufficient disk space on the source for WAL files.
Why this is correct
CDC generates WAL; if disk fills, replication can stall.
- ✗
Cloud SQL Auth Proxy is not installed on the source.
Why it's wrong here
Auth Proxy is used for client connections, not DMS replication; DMS uses private IP or peering.
- ✓
The replication slot is exhausted or not created.
Why this is correct
pglogical requires a replication slot; if it's full or missing, replication fails.
- ✗
The source database is MySQL.
Why it's wrong here
The scenario specifies PostgreSQL; MySQL would be irrelevant.
Go deeper
Related to this question
About these practice questions
One of 1,446 original PCDE practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This PCDE practice question is part of Courseiva's free Google Cloud certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PCDE exam.