SnowPro Core Certification — Question 854

From what stage can a Snowflake user omit the FROM clause while loading data into a table?

Answer options

• A. The user stage
• B. The table stage
• C. The internal named stage
• D. The external named stage

Correct answer: B

Explanation

The correct answer is B, as during the table stage, Snowflake allows data loading without specifying the FROM clause, simplifying the process. Options A, C, and D require the FROM clause to specify the source of the data, making them incorrect in this context.