SnowPro Core Certification — Question 13

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

Answer options

• A. The Pipe load history is reset to empty
• B. The REFRESH parameter is set to TRUE
• C. Previously loaded files will be ignored
• D. All of the above

Correct answer: A

Explanation

The correct answer is A because recreating the Pipe using the CREATE OR REPLACE PIPE command indeed resets the load history to empty. Options B and C are incorrect as the REFRESH parameter does not automatically set to TRUE, nor does it ignore previously loaded files, making D also incorrect.