Câu 22: SnowPro Advanced Data Engineer

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?

1. A. Wait until the metadata expires and then reload the file using Snowpipe.
2. B. Modify the file by adding a blank row to the bottom and re-stage the file.
3. C. Set the FORCE=TRUE option in the Snowpipe COPY INTO command.
4. D. Recreate the pipe by using the CREATE OR REPLACE PIPE command. — đáp án hiện tại