DEA-C02 Question #74: Real Exam Question with Answer & Explanation

Question

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.)

Options

• Acopy into mytable from @mystage;
• Btruncate table mytable;
• Cdrop table mytable;
• Dcreate or replace pipe mypipe auto_ingest=true as copy into mytable
• EThe file will automatically be reloaded a second time after eight days.