Answer-first summary for fast verification
Answer: Dataflow
Dataflow is typically the best choice for copying data from a Fabric data source to a lakehouse when dealing with large volumes and frequent updates. Dataflows are designed for scalable data integration and can handle complex transformations efficiently. They also support incremental updates, which can reduce processing time and resource usage. Data pipelines are more suited for orchestrating multiple tasks, and notebooks are better for ad-hoc analysis and transformations. Stored procedures are not typically used for data copying tasks.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
You are tasked with copying data from a Fabric data source to a lakehouse. Considering the volume and frequency of updates, which method would you choose and why? Discuss the pros and cons of using a data pipeline, dataflow, or notebook for this task.
A
Data Pipeline
B
Dataflow
C
Notebook
D
Stored Procedure