Which SQL command should be used to validate which data was loaded into the stage?

A user has unloaded data from Snowflake to a stage

Which SQL command should be used to validate which data was loaded into the stage?
A . list @file__stage
B . show @file__stage
C . view @file__stage
D . verify @file__stage

View Answer

Answer: A

Explanation:

The list command in Snowflake is used to validate and display the list of files in a specified stage. When a user has unloaded data to a stage, running the list @file__stage command will show all the files that have been uploaded to that stage, allowing the user to verify the data that was unloaded.

Reference: Snowflake Documentation on Stages

SnowPro® Core Certification Study Guide