nerdexam
Snowflake

COF-R02 · Question #35

When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

The correct answer is A. The Pipe load history is reset to empty. https://docs.snowflake.com/en/user-guide/data-load-snowpipe-manage.html#load-history "When a pipe is recreated, the load history is dropped."

Data Loading and Unloading

Question

When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

Options

  • AThe Pipe load history is reset to empty
  • BThe REFRESH parameter is set to TRUE
  • CPreviously loaded files will be ignored
  • DAll of the above

How the community answered

(15 responses)
  • A
    80% (12)
  • B
    13% (2)
  • C
    7% (1)

Explanation

https://docs.snowflake.com/en/user-guide/data-load-snowpipe-manage.html#load-history "When a pipe is recreated, the load history is dropped."

Topics

#Snowpipe#pipe load history#CREATE OR REPLACE PIPE

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full COF-R02 Practice