PCDE Migrate data solutions Practice Question
A company is migrating a 5 TB Oracle database to Cloud SQL for PostgreSQL using DMS with continuous migration. They need to minimize downtime and have a rollback plan. Which TWO actions should they include in their migration plan? (Choose TWO.)
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
✓
Test the application against the destination Cloud SQL instance before cutover.
A rollback plan involves keeping the source available in read-only mode for a validation window. Testing the application against the destination also validates the migration before 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.
- ✗
Use a one-time migration job instead of continuous.
Why it's wrong here
Continuous migration reduces downtime.
- ✓
Test the application against the destination Cloud SQL instance before cutover.
Why this is correct
Validates functionality before final switch.
- ✗
Delete the source database immediately after promoting the destination.
Why it's wrong here
Eliminates rollback capability.
- ✗
Skip schema conversion and use raw Oracle SQL.
Why it's wrong here
Incompatible; must convert schema.
- ✓
Keep the source database running in read-only mode for a period after cutover.
Why this is correct
Allows rollback if issues are found.
Go deeper
Related to this question
About these practice questions
One of 1,446 original PCDE practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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.