SnowPro Advanced: Architect — Question 72

Which columns can be included in an external table schema? (Choose three.)

Answer options

• A. VALUE
• B. METADATA$ROW_ID
• C. METADATA$ISUPDATE
• D. METADATA$FILENAME
• E. METADATA$FILE_ROW_NUMBER
• F. METADATA$EXTERNAL_TABLE_PARTITION

Correct answer: A, D, E

Explanation

The correct answer includes VALUE, METADATA$FILENAME, and METADATA$FILE_ROW_NUMBER, which are all valid columns in an external table schema. The other options, such as METADATA$ROW_ID and METADATA$ISUPDATE, are not typically included as they relate to internal metadata rather than external data structure.