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, evenif they were loaded previously by the old pipe2.
COF-C03 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 65% Discount on All Products,
Use Coupon: "ac4s65"