Which option would you use to load data into a Fabric data warehouse via SQL?

Which option would you use to load data into a Fabric data warehouse via SQL?

• A. Data pipelines
• B. COPY (Transact-SQL) statement
• C. Dataflows
• D. Cross-warehouse

Answer: (B)

Loading data into a Fabric data warehouse using SQL is best done with a SQL bulk-load command. The COPY (Transact-SQL) statement is built for this purpose: it takes data from external sources (like files or stages) and inserts it into a target table using SQL, with options to control the format, error handling, and parallel loading for speed and reliability. This makes it the direct, efficient method for in-warehouse data ingestion via SQL. The other options are more about moving or preparing data at a higher level—data pipelines and dataflows are orchestration or transformation tools, not the in-SQL load command, while cross-warehouse refers to accessing data across different warehouses rather than performing a SQL-based load.

Loading data into a Fabric data warehouse using SQL is best done with a SQL bulk-load command. The COPY (Transact-SQL) statement is built for this purpose: it takes data from external sources (like files or stages) and inserts it into a target table using SQL, with options to control the format, error handling, and parallel loading for speed and reliability. This makes it the direct, efficient method for in-warehouse data ingestion via SQL.

The other options are more about moving or preparing data at a higher level—data pipelines and dataflows are orchestration or transformation tools, not the in-SQL load command, while cross-warehouse refers to accessing data across different warehouses rather than performing a SQL-based load.