What is the primary purpose of a directory table in Snowflake?

The correct answer is D. To store file-level metadata about data files in a stage. A directory table in Snowflake is used to store file-level metadata about the data files in a stage. It is conceptually similar to an external table and provides information such as file size, last modified timestamp, and file URL.

Data Loading and Unloading

Question

Options

ATo store actual data from external stages
BTo automatically expire file URLs for security
CTo manage user privileges and access control
DTo store file-level metadata about data files in a stage

How the community answered

(26 responses)

A
4% (1)
C
4% (1)
D
92% (24)

Explanation

A directory table in Snowflake is used to store file-level metadata about the data files in a stage. It is conceptually similar to an external table and provides information such as file size, last modified timestamp, and file URL.

Topics

#Directory tables#External stages#File metadata#Data loading

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice