PCDE Migrate data solutions Practice Question
A company is migrating their on-premises MySQL database to Cloud SQL using Database Migration Service (DMS). The source database is MySQL 5.7, and the target is a Cloud SQL MySQL 8.0 instance. The migration job is set to continuous, but after the full dump phase, the CDC phase keeps failing with the error 'binary log not found'. What is the most likely cause?
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
✓
The source MySQL binary logs have been purged before DMS could replicate them.
DMS continuous migration requires binary logging enabled on the source with row-based format, and the binary log files must be retained until they are consumed. If the source binary logs are purged before DMS reads them, CDC fails.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Cloud SQL Auth Proxy is not configured on the source.
Why it's wrong here
Cloud SQL Auth Proxy is for connecting to Cloud SQL, not for source MySQL.
- ✗
The Cloud SQL instance does not have binary logging enabled.
Why it's wrong here
Cloud SQL is the target; binary logging is not required on the target for DMS.
- ✗
The DMS migration job uses the wrong source connection profile.
Why it's wrong here
A wrong connection profile would cause failure earlier, not specifically a missing binlog error.
- ✓
The source MySQL binary logs have been purged before DMS could replicate them.
Why this is correct
If source binary logs are purged (e.g., due to low retention), DMS cannot find them and CDC fails.
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 →
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. A team is migrating a MySQL database to Cloud SQL using DMS. They need to configure the source database for binary logging. Which TWO parameters must be set correctly?
medium- A.expire_logs_days = 0
- B.binlog_format = STATEMENT
- C.server_id = 1
- ✓ D.binlog_format = ROW
- ✓ E.log_bin = ON
Why D: For MySQL binary logging to work with DMS, log_bin must be ON and binlog_format must be ROW (or MIXED). ROW-level logging ensures all changes are captured.
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.