SnowPro Advanced: Data Engineer — Question 72

A Data Engineer made modifications to staged files and re-staged them. A pipe is running but the changed data is not appearing in the table.

What step should the Engineer take in order to see the changed data without duplicating data?

Answer options

• A. Run the CREATE or REPLACE PIPE syntax.
• B. Re-run the pipe by using the RELOAD PIPE syntax.
• C. Re-run the pipe by using the ONLY_CHANGES syntax.
• D. Create new files with the changed data.

Correct answer: D

Explanation

The correct answer is D because creating new files with the changed data ensures that the data is processed correctly in the pipeline without duplication. The other options do not address the need to incorporate the modified data effectively, and they may lead to confusion or unnecessary redundancy.