Courseiva
Migrate data solutionsmediumMultiple ChoiceObjective-mapped

PCDE Migrate data solutions Practice Question

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?

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

Stop the application that writes to the source, then confirm DMS lag is zero before promoting.

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.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • Adjust the DMS job to ignore further changes.

    Why it's wrong here

    DMS cannot ignore changes; it must be stopped after writes cease.

  • Promote the destination again; this will force a stop of writes.

    Why it's wrong here

    Promoting again does not stop writes on the source.

  • Stop the application that writes to the source, then confirm DMS lag is zero before promoting.

    Why this is correct

    Proper cutover sequence: quiesce writes, verify lag is zero, promote destination, then update connection strings.

  • Delete the source database to force the cutover.

    Why it's wrong here

    Deleting the source is dangerous and not part of standard cutover procedure.

About these practice questions

Courseiva writes every PCDE question from scratch — 1,446 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

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.