Snowflake

COF-R02 · Question #174

What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?

The correct answer is B. The REFRESH command is executed. See the full explanation below for the reasoning.

Question

What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?

Options

AThe Pipe load history is reset to empty.
BThe REFRESH command is executed.
CThe stage will be purged.
DThe destination table is truncated.

How the community answered

(34 responses)

A
9% (3)
B
85% (29)
C
3% (1)
D
3% (1)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full COF-R02 Practice