Question 370
A pipeline checks whether a matching staged filename exists before loading. Which command returns the file list?
Explanation
Correct Answer
Correct: LIST of stage contents. LIST enumerates files present in a specified stage location.
Incorrect Answers
Incorrect in this scenario: PUT uploads local files to a supported internal Snowflake stage; it does not provide LIST of stage contents.
Incorrect in this scenario: GET downloads staged internal files to a client environment through supported interfaces; it does not provide LIST of stage contents.
Incorrect in this scenario: REMOVE deletes selected files from a named or internal stage location; it does not provide LIST of stage contents.