What is a directory table in Snowflake?

The correct answer is B. An object layered on a stage that is used to store file-level metadata. A directory table in Snowflake is an object layered on a stage that is used to store file-level metadata. It is not a separate database object but is conceptually similar to an external table because it stores metadata about the data files in the stage.

Data Loading and Unloading

Question

Options

AA separate database object that is used to store file-level metadata
BAn object layered on a stage that is used to store file-level metadata
CA database object with grantable privileges for unstructured data tasks
DA Snowflake table specifically designed for storing unstructured files

How the community answered

(17 responses)

B
94% (16)
C
6% (1)

Explanation

A directory table in Snowflake is an object layered on a stage that is used to store file-level metadata. It is not a separate database object but is conceptually similar to an external table because it stores metadata about the data files in the stage.

Topics

#Directory Table#Stages#File Metadata#Unstructured Data

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice