You have a Fabric tenant that contains a warehouse named Warehouse1. You have a large 1 TB dataset in an external data source. You need to recommend a method to ingest the dataset into Warehouse1…

The Copy data activity in Fabric pipelines is specifically engineered for high-throughput, scalable data ingestion between various sources and destinations, including external sources to a Fabric Warehouse. It provides a low-code/no-code experience through a guided wizard, making it ideal for moving large volumes of data efficiently with minimal development effort.

Dataflow Gen2 is excellent for data ingestion and transformation using Power Query, but for pure high-throughput data movement without complex transformations, the Copy data activity typically offers better performance and simplicity.

Using a Spark notebook requires coding skills and significant development effort, which contradicts the low-code/no-code requirement.

A Shortcut is a way to reference data from external sources or other Fabric items without physically copying it, thus it's not a method for *ingesting* data into the Warehouse.