DP-600 Prepare Data Practice Question
You are designing a data ingestion strategy from an on-premises SQL Server to a Microsoft Fabric Lakehouse. You want to utilize the 'Fast Copy' feature in Dataflows Gen2 to maximize throughput. Which TWO conditions must be met to enable this capability? (Select TWO)
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 'Enable staging' option must be selected for the dataflow.
Fast Copy in Dataflows Gen2 allows for high-performance data movement by bypassing the standard Power Query engine for the actual data transfer. To trigger this, the data must not have complex transformations that require the Power Query engine, and staging must be enabled so the Data Factory orchestration engine can handle the movement efficiently.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
The 'Enable staging' option must be selected for the dataflow.
Why this is correct
Fast Copy relies on the Fabric Data Factory orchestration engine to move data directly. This process requires staging to be enabled, allowing the system to land data in a temporary storage area before final delivery, which facilitates the high-speed transfer bypass of the standard Mashup engine.
- ✗
The dataflow must use a Fabric Notebook as a destination.
Why it's wrong here
Notebooks are not valid destinations for Dataflows Gen2; instead, dataflows output to Lakehouses, Warehouses, Azure SQL databases, or KQL Databases. Fast Copy is independent of the final destination type and is focused on the efficiency of the ingestion and transformation path within the Dataflow architecture.
- ✓
The transformation steps must only include supported connectors and basic operations.
Why this is correct
Fast Copy only activates when the transformations are simple enough to be translated into the underlying copy engine's capabilities. If complex M-code functions or transformations are added that require the Power Query Mashup engine, the system will fall back to the slower, standard processing path for ingestion.
- ✗
A Premium Capacity (P1 or higher) must be assigned to the workspace.
Why it's wrong here
While Fabric features require a capacity, Fast Copy is not restricted to specific Premium 'P' SKUs; it is available in Fabric capacities generally. The performance benefit is derived from the architectural bypass and staging settings rather than the specific tier of the capacity assigned to the workspace.
- ✗
The source SQL Server must have the 'V-Order' property enabled.
Why it's wrong here
V-Order is a Microsoft Fabric-specific optimization for Parquet and Delta files within a Lakehouse or Warehouse environment. It is not a feature or setting available on on-premises SQL Server instances, which use different storage engines and formats like B-tree indexes and Columnstore for performance.
About these practice questions
One of 12 original DP-600 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 →
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-600 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-600 exam.