SOL-C01 practice question 3 of 30

Which SQL command is commonly used to load structured data from a stage into a Snowflake table?

Full set: 214 questions
Answer options
A: INSERT INTO
B: COPY INTO Correct answer
C: LOAD DATA
D: IMPORT DATA
Correct Answer:
B. COPY INTO
Explanation

Snowflake’s recommended method for bulk-loading structured data from an internal or external stage into a table is the COPY INTO

SQL command. COPY INTO reads staged files, automatically applies file format options, and inserts the parsed rows into the target table.

Why Incorrect

A. INSERT INTO – Standard DML; cannot directly pull files from a stage.
C. LOAD DATA – Not a valid Snowflake SQL statement.
D. IMPORT DATA – Not a valid Snowflake SQL statement.

References

1. Snowflake Documentation, “COPY INTO

” – SQL Command Reference, section “Usage Notes”, 2024-03-12 edition.

2. Snowflake Documentation, “Loading Data Using the COPY Command”, Data Loading Guide, step 2.

Scroll to Top