Snowflake Exam DEA-C01 Topic 1 Question 15 Discussion

Actual exam question for Snowflake's DEA-C01 exam

Question #: 15
Topic #: 1

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?

AWait until the metadata expires and then reload the file using Snowpipe

BModify the file by adding a blank row to the bottom and re-stage the file

CSet the FORCE=TRUE option in the Snowpipe COPY INTO command

DRecreate the pipe by using the create or replace pipe command

Show Suggested Answer

Suggested Answer: B

Please note JavaScript is case sensitive but if we are using a JavaScript UDF in a masking policy,

ensure the data type of the column, UDF, and masking policy match.

by Martina at Dec 25, 2023, 12:24 AM

Limited Time Offer

25%

Off

Get Premium DEA-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!