COF-C02 Question 60

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose A1

  When you recreate a pipe using the CREATE OR REPLACE PIPE command, Snowflake drops the old pipe object and replaces it with a new one in a single atomic transaction. Because the load history (metadata tracking which files have been processed) is stored directly in the metadata of the pipe object itself, recreating the pipe resets the load history to empty. Why B and C are incorrect/misleading: Statement B is incorrect because REFRESH is a command parameter/operation used in an ALTER PIPE statement rather than a setting automatically forced to TRUE inside a CREATE definition. Statement C is technically a downstream side-effect rather than a direct parameter configuration—because the load history is wiped clean, any files sitting in the stage will be treated as new if a refresh or new notification occurs, but files aren't inherently "ignored"; rather, the new pipe lacks the historical record of them.

• Chose D3

  Answer is D.

• Chose A2

  Snowflake Docs: Managing Pipes — Recreate Pipes The load history for Snowpipe operations is stored in the metadata of the pipe object. When a pipe is recreated, the load history is dropped. Snowflake Docs: ALTER PIPE