Best load for small data or specific connector.

Best load for small data or specific connector.

• A. Dataflows
• B. Copy tool in pipelines
• C. Notebooks
• D. Tool in Tabular Editor

Answer: (A)

Dataflows are a lightweight, self-service ETL layer that connects directly to many data sources with built-in connectors, lets you shape data using Power Query, and loads it into the data lake so it can be reused by reports and pipelines. This makes them ideal for small data loads or when you’re targeting a specific connector, because you can set up the ingestion quickly without coding and publish the result as a lake-ready entity. The copy tool in pipelines is more about moving data between storages or performing straightforward transfers and isn’t as convenient for quick, small-scale ingestion from a specific source. Notebooks are great for exploration and experimentation, not for production-style data loading into the lake. The Tool in Tabular Editor focuses on refining the data model rather than bringing data into the lake.

Dataflows are a lightweight, self-service ETL layer that connects directly to many data sources with built-in connectors, lets you shape data using Power Query, and loads it into the data lake so it can be reused by reports and pipelines. This makes them ideal for small data loads or when you’re targeting a specific connector, because you can set up the ingestion quickly without coding and publish the result as a lake-ready entity.

The copy tool in pipelines is more about moving data between storages or performing straightforward transfers and isn’t as convenient for quick, small-scale ingestion from a specific source. Notebooks are great for exploration and experimentation, not for production-style data loading into the lake. The Tool in Tabular Editor focuses on refining the data model rather than bringing data into the lake.