Which statement correctly lists the four data ingestion options available for Microsoft Fabric data warehousing?

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

Answer: (B)

Microsoft Fabric data warehousing supports four main ingestion pathways. The COPY (Transact-SQL) statement lets you bulk-load data directly into the warehouse from external sources or staging areas using a SQL command, which is quick for large, straightforward imports. Data pipelines provide orchestrated, end-to-end ingestion from various sources into Fabric, with scheduling and monitoring built in. Dataflows offer a visual, transformation-enabled route to connect to sources, shape data, and load it into the warehouse, useful for preparatory cleansing and mapping. Cross-warehouse ingestion enables moving or sharing data between Fabric warehouses within the same ecosystem, supporting consistency and data reuse across warehouses. Tools like Data Wrangler exist for data preparation but aren’t considered the standard ingestion pathways, and cross-platform ingestion isn’t listed as a separate ingestion channel here. So the correct set is the COPY statement, data pipelines, dataflows, and cross-warehouse ingestion.