What is the recommended method to ingest preformatted forecast data into a Fabric lakehouse with minimal development effort and cost?

What is the recommended method to ingest preformatted forecast data into a Fabric lakehouse with minimal development effort and cost?

• A. Copy activity in a pipeline
• B. Dataflow Gen2
• C. Spark job
• D. Manual upload

Answer: (A)

Ingesting preformatted forecast data with minimal development effort and cost relies on a data movement option that doesn’t require coding or heavy processing. The Copy activity in a pipeline is built for exactly that: it copies data from a source to a lakehouse sink with optional simple schema mapping, handling common formats (CSV, Parquet, etc.) and preserving structure. It uses managed connectors, so you can point to the source location and the lakehouse destination, set a schedule or trigger, and let the platform move the files with little development. Because there’s no need to build Spark jobs or sophisticated dataflows, this approach minimizes both effort and ongoing cost. In contrast, Dataflow Gen2 or Spark jobs are designed for transformations and require more setup and compute, while manual uploads are not scalable or repeatable.

Ingesting preformatted forecast data with minimal development effort and cost relies on a data movement option that doesn’t require coding or heavy processing. The Copy activity in a pipeline is built for exactly that: it copies data from a source to a lakehouse sink with optional simple schema mapping, handling common formats (CSV, Parquet, etc.) and preserving structure. It uses managed connectors, so you can point to the source location and the lakehouse destination, set a schedule or trigger, and let the platform move the files with little development. Because there’s no need to build Spark jobs or sophisticated dataflows, this approach minimizes both effort and ongoing cost. In contrast, Dataflow Gen2 or Spark jobs are designed for transformations and require more setup and compute, while manual uploads are not scalable or repeatable.