SnowPro Core Certification — Question 905

What table functions in the Snowflake Information Schema can be queried to retrieve information about directory tables? (Choose two.)

Answer options

• A. AUTO_REFRESH_REGISTRATION_HISTORY
• B. EXTERNAL_TABLE_FILE_REGISTRATION_HISTORY
• C. EXTERNAL_TABLE_FILES
• D. MATERIALIZED_VIEW_REFRESH_HISTORY
• E. STAGE_DIRECTORY_FILE_REGISTRATION_HISTORY

Correct answer: A, E

Explanation

The correct answers are A and E because AUTO_REFRESH_REGISTRATION_HISTORY provides details on automatic refresh operations and STAGE_DIRECTORY_FILE_REGISTRATION_HISTORY gives insights on file registrations in stages, both relevant to directory tables. Options B, C, and D do not pertain specifically to directory tables, making them incorrect choices.