2Ingest and Transform Data

• 2.1Data Ingestion (Pipelines, Dataflows, Copy)

  Understand ways to ingest data into Fabric—data pipelines (orchestration), Dataflows Gen2 (no-code transform with Power Query), the Copy activity, and shortcuts—and when to use each.

• 2.2Data Transformation (Spark, Notebooks, T-SQL)

  Understand transformation in Fabric—Spark notebooks (PySpark/Spark SQL), Dataflows Gen2, T-SQL (Warehouse)—and the medallion architecture (bronze/silver/gold) for staged refinement.