COF-C02 Question #15: Real Exam Question with Answer & Explanation

The correct answer is A: list @file__stage. 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 dat

Data Loading and Unloading

Question

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?

Options

Alist @file__stage
Bshow @file__stage
Cview @file__stage
Dverify @file__stage

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

Topics

#Snowflake stages#Data unloading#LIST command#File management

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice Browse All COF-C02 Questions