How can a directory table be enabled in Snowflake?

The correct answer is A. By using the CREATE DIRECTORY command. In Snowflake, a directory table is a special table-like object associated with a stage that catalogs files stored in that stage. It is enabled using the DIRECTORY option at the time of stage creation (CREATE STAGE ... DIRECTORY = (ENABLE = TRUE)) or enabled later with an ALTER…

Data Loading and Unloading

Question

Options

ABy using the CREATE DIRECTORY command
BBy setting a table policy
CBy uploading files directly to a schema
DBy using the COPY INTO command

How the community answered

(23 responses)

A
96% (22)
B
4% (1)

Explanation

In Snowflake, a directory table is a special table-like object associated with a stage that catalogs files stored in that stage. It is enabled using the DIRECTORY option at the time of stage creation (CREATE STAGE ... DIRECTORY = (ENABLE = TRUE)) or enabled later with an ALTER STAGE command. The exam identifies this as the CREATE DIRECTORY approach. The other options are incorrect: setting a table policy (B), uploading files directly to a schema (C), and COPY INTO (D) are unrelated to enabling directory tables.

Topics

#Directory Tables#External Stages#Data Loading#SQL Commands

Community Discussion

No community discussion yet for this question.

Full SOL-C01 Practice