Courseiva
← PCDE
Full test
Migrate data solutions →mediumMultiple ChoiceObjective-mapped

PCDE Migrate data solutions Practice Question

A company is using mysqldump to migrate a MySQL database to Cloud SQL. The source database uses InnoDB tables and is running a production workload. They want to ensure a consistent snapshot without locking tables. Which mysqldump flags 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

✓

--single-transaction --skip-lock-tables

--single-transaction uses a transaction to get a consistent snapshot without locking tables (works with InnoDB). --skip-lock-tables prevents explicit table locks. --lock-all-tables would lock tables. --master-data is for binary log coordinates but not required for 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.

  • ✗

    --single-transaction --master-data

    Why it's wrong here

    --master-data adds binary log position info but is not required for consistency.

  • ✗

    --lock-all-tables --flush-logs

    Why it's wrong here

    These would lock all tables, causing downtime.

  • ✓

    --single-transaction --skip-lock-tables

    Why this is correct

    These flags provide a consistent snapshot without locking tables for InnoDB.

  • ✗

    --skip-lock-tables --all-databases

    Why it's wrong here

    Missing --single-transaction; without it, the dump may not be consistent.

About these practice questions

This PCDE question is part of Courseiva's 1,446-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

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.