Exam SnowPro Advanced Architect All QuestionsBrowse all questions from this exam
Question 56

An Architect runs the following SQL query:

How can this query be interpreted?

    Correct Answer: A

    The SQL query is selecting the metadata, specifically the filename and the file row number, from a CSV file that is staged in a storage location referenced as FILEROWS. Here, FILE_ROW_NUMBER refers to the line number in the staged file, and FILEROWS is a stage where the file Food_Reviews.csv is stored. The file_format=CSV_N specifies the format of the file being read. Therefore, the correct interpretation is that FILEROWS is a stage and FILE_ROW_NUMBER is the line number in the file.

Discussion
hillcat111Option: A

Answer is A and is validated

callipso21Option: A

METADATA$FILE_ROW_NUMBER Row number for each record in the staged data file.