Which command is used to lake away staged files from a Snowflake stage after a successful data ingestion?
Suggested Answer: C
Get Premium COF-C02 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
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. References: Snowflake Documentation on Stages and File Management
9 comments · newest first
SH
Sharee
4 days ago
REMOVE makes the most sense after ingestion!
DA
Dannie
9 days ago
Wait, are you sure? I thought TRUNCATE was for this.
TA
Talia
14 days ago
Yeah, REMOVE is the right one!
AS
Ashton
19 days ago
I thought it was A) DELETE at first.
ME
Merilyn
25 days ago
It's definitely C) REMOVE.
JA
Jacquelyne
30 days ago
I definitely remember that DROP is used for dropping objects, but I’m confused about whether REMOVE is the right one for staged files.
HE
Hermila
1 month ago
I feel like TRUNCATE is more about tables, not stages. I think it might be REMOVE, but I need to double-check.
CI
Ciara
1 month ago
I remember practicing a question about deleting files, but I can't recall if it was DELETE or something else.
JI
Jimmie
2 months ago
I think the command to remove files from a Snowflake stage is something like REMOVE, but I'm not entirely sure.