Exam SnowPro Core topic 1 question 30 discussion

I believe the correct answer is A. REFRESH is a parameter for ALTER PIPE https://docs.snowflake.com/en/sql-reference/sql/alter-pipe.html It is NOT a parameter for CREATE [OR REPLACE] Pipe. https://docs.snowflake.com/en/sql-reference/sql/create-pipe.html Further recreating a pipe resets history: https://docs.snowflake.com/en/user-guide/data-load-snowpipe-manage.html#label-snowpipe-management-recreate-pipes "Load History 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. In general, this condition only affects users if they subsequently execute an ALTER PIPE … REFRESH statement on the pipe. Doing so could load duplicate data from staged files in the storage location for the pipe if the data was already loaded successfully and the files were not deleted subsequently."

Answer is A The pipe load history is set to empty. 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.In general, this condition only affects users if they subsequently execute an ALTER PIPE … REFRESH statement on the pipe. Doing so could load duplicate data from staged files in the storage location for the pipe if the data was already loaded successfully and the files were not deleted subsequently.

when recreating a pipe with CREATE OR REPLACE PIPE, all these behaviors apply, making D. All of the above the correct answer

D is correct here

The correct answer is D. All of the above. When a Pipe is recreated using the CREATE OR REPLACE PIPE command: The Pipe load history is reset to empty (A is true) The REFRESH parameter is automatically set to TRUE (B is true) Previously loaded files will be ignored (C is true) Therefore, since all three statements (A, B, and C) are true, D "All of the above" is the correct answer. This is important to understand because recreating a pipe effectively gives you a fresh start - clearing history, refreshing the pipe, and ignoring previously processed files.

D - All options (A,B,C) is correct

Refresh is used with alter pipe

the answer is A

correct answer: A

A Is correct Answer

Correct answer:A

A. The Pipe load history is reset to empty When you recreate a pipe using CREATE OR REPLACE PIPE, the load history for the pipe is reset, which means Snowflake will no longer have a record of the files that were previously processed by that pipe. This can affect how subsequent loads are handled, but the REFRESH parameter and handling of previously loaded files are not automatically impacted in the ways described by options B and C.

a is correct

The correct answer is A https://docs.snowflake.com/en/user-guide/data-load-snowpipe-manage

A is the correct ans. Load History 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. In general, this condition only affects users if they subsequently execute an ALTER PIPE … REFRESH statement on the pipe. Doing so could load duplicate data from staged files in the storage location for the pipe if the data was already loaded successfully and the files were not deleted subsequently.

Answer is A. Ref: https://docs.snowflake.com/en/user-guide/data-load-snowpipe-manage

D When a Pipe is recreated using the CREATE OR REPLACE PIPE command, the load history is reset, the REFRESH parameter is set to TRUE, and previously loaded files are ignored.