Question 875 of 1,446
PCDE Migrate data solutions Practice Question
A company plans to migrate a MySQL database to Cloud SQL with minimal downtime. They use Database Migration Service with continuous CDC. After starting the migration, the initial full dump completes, and CDC replication begins. The application team needs to cut over during a maintenance window. What must the engineer do just before promoting the destination to ensure no 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 to the source, confirm replication lag is zero, then promote the destination.
Before promoting the destination, the engineer must verify that the replication lag is zero, meaning all changes from the source have been applied to the destination. This ensures no data loss during cutover. After confirming zero lag, the source should be quiesced (writes stopped) to prevent further changes, then the destination can be promoted.
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, confirm replication lag is zero, then promote the destination.
Why this is correct
This is the correct procedure: stop writes, verify zero lag, then promote to cutover cleanly.
- ✗
Promote the destination immediately; replication lag is automatically handled.
Why it's wrong here
Promoting with lag can lose recent changes. Lag must be confirmed zero.
- ✗
Take a manual snapshot of the source with mysqldump and import it to the destination.
Why it's wrong here
This would cause additional downtime and defeat the purpose of using DMS for minimal downtime.
- ✗
Stop the migration job and delete the source database.
Why it's wrong here
Deleting the source before promotion risks data loss if replication is not complete.
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. 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. During cutover of a Database Migration Service continuous migration job, the engineer observes that the source database still receives writes after promoting the destination Cloud SQL instance. What should the engineer do to complete the migration?
medium- A.Adjust the DMS job to ignore further changes.
- B.Promote the destination again; this will force a stop of writes.
- ✓ C.Stop the application that writes to the source, then confirm DMS lag is zero before promoting.
- D.Delete the source database to force the cutover.
Why C: Cutover requires quiescing writes to the source to ensure no new changes are generated. The application should be stopped or switched to read-only first.
Last reviewed: Jul 4, 2026
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.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.