Which kind of Snowflake table stores file-level metadata for each file in a stage?

The correct answer is A. Directory. A Directory table (A) is a special table type that can be enabled on an internal or external stage. It automatically maintains a catalog of all staged files, storing file-level metadata such as file name, file URL, size, last modified timestamp, and ETag. This makes it easy to…

Data Loading and Unloading

Question

Options

ADirectory
BExternal
CTemporary
DTransient

How the community answered

(37 responses)

A
92% (34)
C
5% (2)
D
3% (1)

Explanation

A Directory table (A) is a special table type that can be enabled on an internal or external stage. It automatically maintains a catalog of all staged files, storing file-level metadata such as file name, file URL, size, last modified timestamp, and ETag. This makes it easy to query and manage unstructured or semi-structured data files sitting in stages without loading them into regular tables.

Topics

#Directory tables#Stages#Metadata#File management

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice