nerdexam
Snowflake

COF-R02 · Question #127

What happens when an external or an internal stage is dropped? (Select TWO).

The correct answer is A. When dropping an external stage, the files are not removed and only the stage is dropped C. When dropping an internal stage, the files are deleted with the stage and the files are recoverable. See the full explanation below for the reasoning.

Question

What happens when an external or an internal stage is dropped? (Select TWO).

Options

  • AWhen dropping an external stage, the files are not removed and only the stage is dropped
  • BWhen dropping an external stage, both the stage and the files within the stage are removed
  • CWhen dropping an internal stage, the files are deleted with the stage and the files are recoverable
  • DWhen dropping an internal stage, the files are deleted with the stage and the files are not
  • EWhen dropping an internal stage, only selected files are deleted with the stage and are not

How the community answered

(20 responses)
  • A
    75% (15)
  • B
    15% (3)
  • D
    5% (1)
  • E
    5% (1)

Community Discussion

No community discussion yet for this question.

Full COF-R02 Practice