SnowPro Core Certification — Question 1103

Which command is used to determine the file name of each row of data from a staged file?

Answer options

• A. SHOW FILE FORMATS
• B. SELECT METADATA$FILE_CONTENT_KEY
• C. SELECT METADATA$FILE_ROW_NUMBER
• D. SELECT METADATA$FILENAME

Correct answer: D

Explanation

The correct answer, D, is used to retrieve the file name associated with each row of data in a staged file. Options A, B, and C do not provide the file name; instead, they deal with file formats and other metadata related to the content and row number.