SnowPro Advanced: Data Engineer — Question 21

A table is loaded using Snowpipe and truncated afterwards. Later, a Data Engineer finds that the table needs to be reloaded, but the metadata of the pipe will not allow the same files to be loaded again.
How can this issue be solved using the LEAST amount of operational overhead?

Answer options

• A. Wait until the metadata expires and then reload the file using Snowpipe.
• B. Modify the file by adding a blank row to the bottom and re-stage the file.
• C. Set the FORCE=TRUE option in the Snowpipe COPY INTO command.
• D. Recreate the pipe by using the CREATE OR REPLACE PIPE command.

Correct answer: D

Explanation

The correct answer is D because recreating the pipe allows for the metadata to be reset, enabling the same files to be loaded again without any complications. Options A and B involve unnecessary delays or modifications to the files, while option C does not address the metadata issue directly and may not be effective.