PCDE Migrate data solutions Practice Question
Which TWO actions should be performed during cutover planning for a DMS continuous migration to minimize downtime?
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
✓
Quiesce writes to the source database
Quiescing writes to the source ensures no new changes after the last sync. Confirming DMS replication lag is 0 ensures all changes are applied. Creating a DMS job is done earlier. Updating connection strings happens after promotion. Dropping source is not recommended for rollback.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Quiesce writes to the source database
Why this is correct
Stops new changes, ensuring consistency.
- ✗
Drop the source database
Why it's wrong here
Not recommended; keep source for rollback.
- ✓
Confirm DMS replication lag is 0
Why this is correct
Ensures all changes have been replicated.
- ✗
Update application connection strings to the destination
Why it's wrong here
This is done after promotion, not during cutover planning.
- ✗
Create a new DMS migration job
Why it's wrong here
Should be done well before cutover.
Visual reference
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 →
Same concept, more angles
1 more way this is tested on PCDE
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. 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?
medium- A.The DMS job status is 'Running'
- B.The destination has been promoted already
- C.The source database is still accepting writes
- ✓ D.The DMS replication lag is 0 seconds
Why D: 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.
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.