What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?
A.
The Pipe load history is reset to empty.
B.
The REFRESH command is executed.
C.
The stage will be purged.
D.
The destination table is truncated.
The Answer Is:
A
This question includes an explanation.
Explanation:
When a pipe is recreated using the CREATE OR REPLACE PIPE command, the load history of the pipe is reset. This means that Snowpipe will consider all files in the stage as new and will attempt to load them, even if they were loaded previously by the old pipe2.
SnowPro-Core PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 60% Discount on All Products,
Use Coupon: "8w52ceb345"