Exam SnowPro Core All QuestionsBrowse all questions from this exam
Question 812

What are characteristics of directory tables when used with unstructured data? (Choose two.)

    Correct Answer: C, E

    Directory tables store a catalog of staged files in cloud storage, which makes them well-suited for managing unstructured data. Moreover, a directory table is a separate database object that can be layered explicitly on a stage, allowing for additional flexibility and organization.

Discussion
BobFarOptions: CD

CD is correct! Directory table: 1- its implicit not separate database object 2 - like external table stores file-level metadata about the data files in the stage 3 - has NO grantable privileges of its own https://docs.snowflake.com/en/user-guide/data-load-dirtables#what-is-a-directory-table

HeetecOptions: CD

CD correct - https://docs.snowflake.com/en/user-guide/data-load-dirtables

romega2Options: CD

correct