SnowPro Core Certification — Question 609

Which columns are available in the output of a Snowflake directory table? (Choose two.)

Answer options

• A. CATALOG_NAME
• B. FILE_NAME
• C. LAST_MODIFIED
• D. RELATIVE_PATH
• E. STAGE_NAME

Correct answer: C, D

Explanation

The correct options, LAST_MODIFIED and RELATIVE_PATH, are both included in the Snowflake directory table output. CATALOG_NAME, FILE_NAME, and STAGE_NAME are not part of the directory table's output columns, which is why they are incorrect.