Snowflake SnowPro Advanced: Data Engineer Certification Exam DEA-C01 Question # 12 Topic 2 Discussion

Snowflake SnowPro Advanced: Data Engineer Certification Exam DEA-C01 Question # 12 Topic 2 Discussion

DEA-C01 Exam Topic 2 Question 12 Discussion:
Question #: 12
Topic #: 2

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?


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


Get Premium DEA-C01 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.