SnowPro Advanced: Data Engineer — Question 89

A Data Engineer is creating a pipe by executing the following statement:

create or replace pipe mypipe auto_ingest=true as copy into mytable from @mystage;

The Data Engineer adds a file data.csv.gz to the stage and it successfully loads into the table mytable.

What will cause the file data.csv.gz to be loaded a second time? (Choose two.)

Answer options

• A. copy into mytable from @mystage;
• B. truncate table mytable; alter pipe mypipe refresh;
• C. drop table mytable; create table mytable (coll string,...)
• D. create or replace pipe mypipe auto_ingest=true as copy into mytable from @mystage; alter pipe mypipe refresh;
• E. The file will automatically be reloaded a second time after eight days.

Correct answer: C, D

Explanation

Options C and D will result in the file data.csv.gz being loaded again. Option C drops and recreates the table, which triggers a reload of the data. Option D redefines the pipe and refreshes it, causing it to reprocess the data in the stage. The other options do not initiate a second load of the file.