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

Asuncion

7 days ago

Option C looks like the simplest solution. Just add the FORCE=TRUE flag and voila, problem solved with minimal effort.

upvoted 0 times

...

Roosevelt

12 days ago

I'm not sure, but option B seems like a quick fix with minimal effort. Adding a blank row to the file could work.

upvoted 0 times

...

Lonna

13 days ago

I disagree, I believe option D is the way to go as recreating the pipe will ensure that the table can be reloaded without any issues.

upvoted 0 times

...

Darnell

14 days ago

I think option C is the best solution because it allows us to reload the file without waiting for the metadata to expire.

upvoted 0 times

...

Rashad

18 days ago

I'm not sure about option C, I think option D might be a safer choice to ensure the table is reloaded correctly.

upvoted 0 times

...

Luisa

22 days ago

I agree with Gracia, option C seems like the most efficient solution to the problem.

upvoted 0 times

...

Gracia

25 days ago

I think option C is the best choice because it allows us to reload the file without waiting for the metadata to expire.

upvoted 0 times

...