When a Pipe is recreated using the CREATE OR REPLACE PIPE command:
When a Pipe is recreated using the CREATE OR REPLACE PIPE command:
When the CREATE OR REPLACE PIPE command is used to recreate a pipe in Snowflake, the load history of the pipe is reset to empty. This means that the metadata of the pipe, which contains records of previously processed files, is cleared. This action can potentially result in the reloading of files if there are no other mechanisms in place to prevent it. The REFRESH parameter is not automatically set to TRUE upon recreating a pipe, and there are no inherent mechanisms to ignore previously loaded files as suggested in other options.
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."
"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." correct answer is A.
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-manage.html#load-history "When a pipe is recreated, the load history is dropped."
should be A
Was on exam Dec 31st, 2022
Correct is A
REFRESH is a parameter for ALTER PIPE
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.
a is correct
correct answer: A
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.
I believe the correct answer is A.
A should be correct
I you recreate a pipe and then do a refresh you will see that the list of files previously loaded are still here.
it is A
A is the answer.
B is correct https://docs.snowflake.com/en/user-guide/data-load-snowpipe-manage.html#recreating-pipes-for-automated-data-loads before recreating pipe Pause the pipe (using ALTER PIPE … SET PIPE_EXECUTION_PAUSED = true) is set and subsequent effect of this is " When a pipe is recreated, the load history is dropped."
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. https://docs.snowflake.com/en/user-guide/data-load-snowpipe-manage.html#recreating-pipes-for-automated-data-loads
A is correct
A is correct
A is correct. 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. https://docs.snowflake.com/en/user-guide/data-load-snowpipe-manage.html#recreating-pipes
B is correct
B is the answer
correct option is A https://docs.snowflake.com/en/user-guide/data-load-snowpipe-manage check load history topic
D is correct Recreating Pipes - Load History:(As per documentation) 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. https://docs.snowflake.com/en/user-guide/data-load-snowpipe-manage#label-snowpipe-management-recreate-pipes
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.
Answer is A. Ref: https://docs.snowflake.com/en/user-guide/data-load-snowpipe-manage
The correct answer is A https://docs.snowflake.com/en/user-guide/data-load-snowpipe-manage
It literally lists all the options on this link,.but scattered throughout text so you have to find them. So D.
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.
Correct answer:A
A Is correct Answer
the answer is A
Refresh is used with alter pipe
D - All options (A,B,C) is correct
D is correct here
when recreating a pipe with CREATE OR REPLACE PIPE, all these behaviors apply, making D. All of the above the correct answer
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.
Correct answer is A,C
A is correct
D Snowflake clears the load history for the pipe. Setting REFRESH = TRUE tells Snowflake to re-evaluate the staged files. Snowpipe uses the new pipe definition and skips previously processed files,