COF-C02 Question #596: Real Exam Question with Answer & Explanation

The correct answer is B: Use the purge copy option.. To remove staged files during data loading after they have been successfully loaded, the PURGE copy option is used in Snowflake. PURGE Option: This option automatically deletes files from the stage after they have been successfully copied into the target table. FILE_FORMAT = (typ

Data Loading and Unloading

Question

How can staged files be removed during data loading once the files have loaded successfully?

Options

AUse the DROP command
BUse the purge copy option.
CUse the FORCE = TRUE parameter
DUse the LOAD UNCERTAIN FILES copy option.

Explanation

To remove staged files during data loading after they have been successfully loaded, the PURGE copy option is used in Snowflake. PURGE Option: This option automatically deletes files from the stage after they have been successfully copied into the target table. FILE_FORMAT = (type = 'csv') Snowflake Documentation on COPY INTO

Topics

#Data Loading#Staged Files#COPY INTO command#Purge option

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice Browse All COF-C02 Questions