ExamGecko
Question list
Search
Search

Question 537 - SnowPro Core discussion

Report
Export

Which command is used to lake away staged files from a Snowflake stage after a successful data ingestion?

A.

DELETE

Answers
A.

DELETE

B.

DROP

Answers
B.

DROP

C.

REMOVE

Answers
C.

REMOVE

D.

TRUNCATE

Answers
D.

TRUNCATE

Suggested answer: C

Explanation:

The REMOVE command is used in Snowflake to delete files from a stage after they have been successfully ingested into Snowflake tables. This command helps manage storage by allowing users to clean up staged files that are no longer needed, ensuring that the stage does not accumulate unnecessary data over time. Unlike DELETE, DROP, or TRUNCATE commands, which are used for managing data within Snowflake tables or dropping objects, REMOVE specifically targets the management of files in stages.

Reference: Snowflake Documentation on Stages and File Management

asked 29/10/2024
mohammed rafiuddin
38 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first