PCDE Migrate data solutions Practice Question
A team is planning a migration from PostgreSQL to Cloud SQL with minimal downtime. They have set up DMS continuous migration. At cutover time, they need to ensure no data loss. What should they verify before promoting the destination?
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 DMS replication lag is 0 seconds
Confirming DMS replication lag is 0 ensures all changes from the source have been applied to the destination. DMS status 'Running' is not enough. Source reads disabled would cause issues. DMS should be in a healthy state, but lag = 0 is the key.
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 DMS job status is 'Running'
Why it's wrong here
Running status doesn't guarantee the lag is zero.
- ✗
The destination has been promoted already
Why it's wrong here
Promoting prematurely could cause data loss if lag is not zero.
- ✗
The source database is still accepting writes
Why it's wrong here
Source should be quiesced (writes stopped) before promotion to avoid data loss.
- ✓
The DMS replication lag is 0 seconds
Why this is correct
This ensures all changes have been replicated and there is no data loss.
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.