Answer: LAST_MODIFIED, RELATIVE_PATH

According to the Snowflake documentation referenced in the community discussion (https://docs.snowflake.com/en/user-guide/data-load-dirtables-manage#output), the columns available in a Snowflake directory table output are: RELATIVE_PATH, SIZE, LAST_MODIFIED, MD5, ETAG, and FILE_URL. Among the given options, C (LAST_MODIFIED) and D (RELATIVE_PATH) are correct. The community discussion shows 83% consensus for CD, with multiple users citing the official documentation. Option B (FILE_NAME) is incorrect as it's not listed in the official documentation - this appears to be a common misconception, as shown by the 17% who selected BD. Options A (CATALOG_NAME) and E (STAGE_NAME) are not part of the directory table output structure.

Author: LeetQuiz Editorial Team