PCDE Migrate data solutions Practice Question
A company is using DMS to migrate a MySQL database to Cloud SQL with continuous replication. During the CDC phase, the replication lag is increasing and not catching up. The source database is heavily used for OLTP workloads. Which action would most likely reduce the replication lag?
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
✓
Reduce the number of concurrent write operations on the source database.
Increasing the source database's binary log retention period does not reduce lag; it retains more logs. Reducing concurrent writes on source directly slows the rate of change, allowing DMS to catch up.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Increase the size of the Cloud SQL destination instance.
Why it's wrong here
Larger instance helps apply changes faster but if source throughput is high, lag may still increase.
- ✗
Increase the binary log retention period on the source.
Why it's wrong here
Retaining more logs does not reduce the rate of change; it only keeps older logs.
- ✗
Enable parallel replication on DMS.
Why it's wrong here
DMS handles parallelism internally; there is no user-configurable parallel replication setting.
- ✓
Reduce the number of concurrent write operations on the source database.
Why this is correct
Fewer writes mean fewer changes to replicate, allowing DMS to catch up.
Go deeper
Related to this question
About these practice questions
This PCDE question is part of Courseiva's 1,446-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. 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.