PCDE Migrate data solutions Practice Question
A team is migrating a MySQL database to Cloud SQL using DMS with continuous CDC. They want to minimize downtime during cutover. Which three actions should they take as part of the cutover plan? (Choose 3)
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 write operations on the source database.
During cutover, the steps are: quiesce writes on source, confirm DMS lag is 0, promote the destination, update application connection strings, and keep the source available for rollback. Disabling binary logging or deleting the source prematurely are not part of a safe cutover.
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 write operations on the source database.
Why this is correct
Stop writes to ensure consistency.
- ✗
Delete the migration job immediately after promotion.
Why it's wrong here
Keep the job for rollback until validation is complete.
- ✓
Promote the destination Cloud SQL instance.
Why this is correct
This makes Cloud SQL the primary.
- ✓
Confirm DMS replication lag is 0.
Why this is correct
Ensure source and target are fully in sync.
- ✗
Disable binary logging on the source.
Why it's wrong here
Not needed; binary logging can stay enabled.
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.