Design innovative, scalable, and highly available cloud database solutions →mediumMultiple ChoiceObjective-mapped
PCDE Practice Question: Design innovative, scalable, and highly available cloud database solutions
A team is migrating a large on-premise Oracle database to Cloud SQL for PostgreSQL. They need to minimize downtime and ensure data consistency. Which migration approach is recommended?
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
✓
Use Database Migration Service with continuous replication
Using Database Migration Service (DMS) with continuous replication provides near-zero downtime and maintains consistency.
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 pg_dump and pg_restore
Why it's wrong here
pg_dump and pg_restore require significant downtime for large databases and do not support continuous replication.
- ✓
Use Database Migration Service with continuous replication
Why this is correct
Database Migration Service (DMS) supports heterogeneous migrations such as Oracle to Cloud SQL for PostgreSQL. With continuous replication, it provides near-zero downtime and ensures data consistency.
- ✗
Export data as CSV, import to Cloud SQL
Why it's wrong here
Exporting as CSV and importing is a manual batch process that requires significant downtime and does not provide continuous replication.
- ✗
Create a Cloud SQL read replica from on-premise
Why it's wrong here
Cloud SQL read replicas can only be created from Cloud SQL instances, not directly from on-premise databases.
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.