easyMultiple SelectObjective-mapped
PCD Practice Question: A startup is migrating a 100 GB PostgreSQL…
A startup is migrating a 100 GB PostgreSQL database from a self-managed VM to Cloud SQL. They want zero downtime during cutover. Which TWO features of Database Migration Service should they use?
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
✓
Promote the Cloud SQL replica to standalone instance for cutover.
Continuous migration with CDC enables cutover with minimal downtime. Promoting the replica is the final step to make Cloud SQL the primary with zero downtime.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Promote the Cloud SQL replica to standalone instance for cutover.
Why this is correct
Promoting the replica makes it the new primary, completing the cutover with minimal downtime.
- ✗
Use Cloud SQL Auth Proxy for source connectivity.
Why it's wrong here
Auth Proxy is for connecting to Cloud SQL, not for the migration job itself.
- ✓
Continuous migration job with change data capture (CDC).
Why this is correct
Continuous migration with CDC keeps the target in sync with the source for zero-downtime cutover.
- ✗
Use VPC peering to connect source to Cloud SQL.
Why it's wrong here
VPC peering is a connectivity method, not a feature for zero-downtime cutover.
- ✗
One-time migration job.
Why it's wrong here
One-time migration requires downtime during the migration window.
Go deeper
Related to this question
About these practice questions
Courseiva writes every PCD question from scratch — 964 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 →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This PCD 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 PCD exam.