What are the four data ingestion options available in Microsoft Fabric for loading data into a data warehouse?

• A. COPY (Transact-SQL) statement, data pipelines, dataflows, and cross-warehouse.
• B. COPY (Transact-SQL) statement, data pipelines, dataflows, and Data Wrangler.
• C. COPY (Transact-SQL) statement, data pipelines, dataflows, and cross-platform ingestion.
• D. COPY (Transact-SQL) statement, data pipelines, cross-platform ingestion, cross-warehouse.

Answer: (A)

Loading data into a Fabric data warehouse can be done through four built‑in ingestion paths: the COPY (Transact-SQL) statement, data pipelines, dataflows, and cross-warehouse ingestion. The COPY statement lets you perform bulk loads directly into a target table from external sources using Transact-SQL, which is ideal for fast, large‑scale imports. Data pipelines provide end‑to‑end orchestration for moving data from source systems into the warehouse, with scheduling, dependencies, and incremental loads. Dataflows handle data preparation and transformation in a low‑code way, enabling you to shape and cleanse data before it lands in the warehouse. Cross‑warehouse ingestion enables moving data across Fabric warehouses or from external sources into the target warehouse, supporting data sharing and replication across environments. Other tools mentioned, like Data Wrangler or a generic cross‑platform ingestion concept, are not the recognized ingestion paths for loading into the Fabric data warehouse in this context.