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

Choose your answer, then check it against the explanation.

View Mode

Question number

Answer options

Correct Answer:

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.

Question 3 of 30

Keep practicing

Take the free SOL-C01 practice test

Ten exam-style questions with answers and explanations, plus the exam facts and study guides.

~~$57.00~~ Original price was: $57.00.$25.00Current price is: $25.00.