nerdexam
SnowflakeSnowflake

COF-C02 · Question #607

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

The correct answer is B: REMOVE. The REMOVE command in Snowflake is used to delete files from either external cloud storage locations or internal stages. This command helps manage staged files by removing them when they are no longer needed, which is useful for maintaining organization and managing storage

Data Loading and Unloading

Question

Which command is used to remove files from either external cloud storage or an internal staged

Options

  • ADELETE
  • BREMOVE
  • CTRUNCATE
  • DDROP

Explanation

The REMOVE command in Snowflake is used to delete files from either external cloud storage locations or internal stages. This command helps manage staged files by removing them when they are no longer needed, which is useful for maintaining organization and managing storage

Topics

#REMOVE command#Staged files#File management#Data unloading

Community Discussion

No community discussion yet for this question.

Full COF-C02 PracticeBrowse All COF-C02 Questions