SnowPro Advanced: Data Engineer — Question 90

How can a directory table be used when working with unstructured data? (Choose two.)

Answer options

• A. File access URLs can be shared with collaborators and partners.
• B. Data stored in an external stage can be queried as if the data was inside a table in Snowflake.
• C. All unstructured files on a stage can be queried using the SELECT * FROM DIRECTORY(@); command.
• D. All unstructured files on a stage can be queried using the SELECT * FROM @; command.
• E. A directory table can be joined with other tables to produce a view of unstructured data that combines the file URLs with the file metadata.

Correct answer: C, E

Explanation

The correct answers are C and E because the command SELECT * FROM DIRECTORY(@); allows you to query all unstructured files in a stage, while a directory table can indeed be joined with other tables to integrate file URLs with metadata. Options A and B are not relevant to the query capabilities of directory tables, and option D does not accurately represent how to query unstructured files.