All external tables include the following columns: VALUE

• A. VALUE
• B. False
• C. METADATA$FILENAME
• D. METADATA$FILE_ROW_NUMBER

Answer: (A)

In an external table, the data from the file is exposed as a data column. For a file that has one value per line, Snowflake uses a single data column named VALUE to hold that content. This column is the primary data carrier for the rows you read from the external source, which is why it’s present by default in this common case. Metadata columns like METADATA$FILENAME and METADATA$FILE_ROW_NUMBER exist to give access to the file name and the row’s position within the file, but they aren’t the main data column and aren’t required for every external table. If the file has multiple fields per row, you’d define additional data columns with your own names instead of relying on VALUE.