PCDE Migrate data solutions Practice Question
During a cutover from an on-premises Oracle database to Cloud SQL for PostgreSQL, the team needs to minimize downtime. They have set up continuous replication using a custom tool. Which sequence of steps should they follow to perform the cutover with minimal data loss?
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, verify lag is 0, promote destination, update connection strings, verify application.
The correct sequence: quiesce writes to source (stop application writes), verify replication lag is zero (all changes replicated), promote destination (make it writable), update connection strings, then verify the application. Rolling back involves keeping source read-only.
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, promote destination, verify lag, update connection strings.
Why it's wrong here
Must verify lag before promoting, else risk data loss.
- ✓
Quiesce writes, verify lag is 0, promote destination, update connection strings, verify application.
Why this is correct
Correct order: stop writes, ensure all changes replicated, then promote and switch.
- ✗
Promote destination, quiesce writes, verify lag, update connection strings, verify application.
Why it's wrong here
Promoting before quiescing may cause data loss if there is un-replicated lag.
- ✗
Update connection strings, quiesce writes, verify lag, promote destination.
Why it's wrong here
Changing connection strings before promotion would point to read-only destination.
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.