Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)

Question

Options

• AA directory table is a separate database object.
• BDirectory tables store data file metadata.
• CA directory table will be automatically added to a stage.
• DDirectory tables do not have their own grantable privileges.
• EDirectory table data can not be refreshed manually.

• A
  3% (1)
• B
  90% (35)
• C
  5% (2)
• E
  3% (1)

Explanation

Directory tables in Snowflake are used to store metadata about data files in a stage. They are not separate database objects but are conceptually similar to external tables. Directory tables do not have grantable privileges of their own.

No community discussion yet for this question.