Answer-first summary for fast verification
Answer: Performing updates using the SQL UPDATE command
The correct answer is E: Performing updates using the SQL UPDATE command. Reason: The UPDATE command is used to change data that already exists in a table. It does not bring in new data from files or other sources, so it is not considered a method for loading data into Snowflake. Why the others are valid: A: Bulk copy from an External Stage – This loads data from locations like AWS S3, Azure Blob, or Google Cloud using the COPY INTO command. B: Continuous load using Snowpipe REST API – This allows near real-time loading of data automatically as files arrive. C: Snowflake Web Interface wizard – This lets you upload small files (up to 50 MB) directly through the Snowflake UI. D: Bulk copy from an Internal Stage – This loads data stored inside Snowflake’s own staging area.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Which of the following is NOT a valid method for loading data into a Snowflake table?
A
Bulk copy from an External Stage
B
Continuous load using Snowpipe REST API
C
The Snowflake Web Interface (UI) data loading wizard
D
Bulk copy from an Internal Stage
E
Performing updates using the SQL UPDATE command