Question 897 of 1,446
PCDE Migrate data solutions Practice Question
A company is using DMS to migrate from MySQL to Cloud SQL. During the full dump phase, the migration is taking longer than expected. Which factor most likely affects the duration of the full dump?
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
✓
Size of the source database
The duration of the full dump phase primarily depends on the size of the database and the network bandwidth. The number of tables has some impact, but size is more significant. CDC lag is relevant during CDC phase, not full dump. Source engine version may affect compatibility but not duration significantly.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Source database engine version
Why it's wrong here
Engine version has minimal impact on dump duration.
- ✓
Size of the source database
Why this is correct
Larger databases take longer to dump and transfer.
- ✗
Number of tables in the source
Why it's wrong here
While many tables can add overhead, database size is the primary factor.
- ✗
Replication lag during CDC
Why it's wrong here
Replication lag applies to the CDC phase, not the full dump.
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. An engineer is migrating a 20 TB PostgreSQL database to AlloyDB using DMS continuous migration. The full dump phase is taking longer than expected. Which THREE factors could affect the duration of the full dump phase? (Choose THREE.)
hard- A.The version of the source PostgreSQL database.
- ✓ B.The number of tables and indexes on the source.
- ✓ C.The CPU and I/O capacity of the source database server.
- D.The choice of SSL or non-SSL connection.
- ✓ E.Network bandwidth between the source and DMS.
Why B: Full dump time depends on data volume, network bandwidth, CPU/memory of the source, and configuration (e.g., parallel workers).
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.