SnowflakeSnowflake
COF-C02 · Question #185
COF-C02 Question #185: Real Exam Question with Answer & Explanation
The correct answer is B: Directory tables store data file metadata.. 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.
Snowflake Cloud Data Platform Features and Architecture
Question
Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)
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.
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.
Topics
#Directory Tables#Unstructured Data#Stage Permissions#Metadata Storage
Community Discussion
No community discussion yet for this question.