DP-700 Ingest and Transform Data Practice Question
You are building a Dataflow Gen2 to ingest a 50 GB CSV file from an Azure Storage account into a Fabric Lakehouse. You want to ensure the ingestion uses the 'Fast Copy' feature. What must you do?
⚠ Common exam trap
Many candidates believe applying Power Query transformations enhances data readiness, forgetting that any transformations force row-by-row processing and disable the Fast Copy optimization.
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
✓
Ensure no transformations are used in the Power Query steps.
Fast Copy in Dataflows Gen2 allows for high-throughput data movement by bypassing the Power Query mashup engine for the data movement phase. It requires that the source connector supports it and that no complex transformations are applied within the Power Query steps that would force the engine to process rows individually.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Enable the 'Allow Schema Evolution' setting in the destination.
Why it's wrong here
Schema evolution determines how the destination table handles changes in the source schema over time. It does not influence the underlying data movement engine or trigger the Fast Copy optimization, which is specifically focused on the efficiency and speed of the initial or incremental data transfer process.
- ✓
Ensure no transformations are used in the Power Query steps.
Why this is correct
Fast Copy requires a simple 'straight-through' data movement. While basic column renaming is sometimes allowed, applying complex transformations like merges or custom functions forces the Dataflow to use the standard Mashup Engine instead of the optimized Spark-based backend required for the high-performance Fast Copy path.
- ✗
Use a Managed Private Endpoint for the connection.
Why it's wrong here
Managed Private Endpoints provide secure connectivity to data sources by keeping traffic within the Azure backbone. While they enhance security and can improve network reliability, they are a networking configuration and do not directly enable the Fast Copy optimization within the Dataflow Gen2 execution logic.
- ✗
Set the destination to 'Append' instead of 'Replace'.
Why it's wrong here
The destination write mode (Append or Replace) affects how data is added to the target table but does not dictate whether the Fast Copy mechanism is used. Fast Copy can function with either write mode as long as the source and transformation criteria for optimization are met.
About these practice questions
This DP-700 question is part of Courseiva's 152-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 →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Microsoft exam blueprint
This DP-700 practice question is part of Courseiva's free Microsoft 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 DP-700 exam.