Which statement is used to load data into the data warehouse in Microsoft Fabric?

• A. COPY (Transact-SQL) statement
• B. SELECT statement
• C. INSERT INTO statement
• D. MERGE statement

Answer: (A)

Loading data into a data warehouse in Fabric is done with the COPY statement. This Transact-SQL command is built for bulk data ingestion, pulling data from external sources or staged files into a target table, and it supports formats, mappings, and parallel loading for high-volume loads. It’s specifically designed for efficiently moving large datasets into the warehouse.

In contrast, a SELECT statement is for retrieving data, not loading it. An INSERT INTO statement can add rows, but it’s typically used for smaller or incremental loads and isn’t as optimized for large bulk ingests. A MERGE statement handles upserts and combines insert/update/delete logic, which is useful for synchronizing datasets but not the primary method for a bulk initial load.