Which option purges loaded data files in the COPY INTO command?

• A. DELETE
• B. PURGE
• C. ERASE
• D. REMOVE

Answer: (B)

When loading data from a stage with COPY INTO, you can remove the source files automatically after they’re loaded. This behavior is controlled by the PURGE option. Setting PURGE = TRUE tells Snowflake to delete the files from the stage once the load completes successfully, which helps keep the stage tidy and prevents reprocessing the same files. If a file fails to load, it won’t be purged, so you can investigate the issue without losing the original data.

The other terms don’t represent a purge behavior in COPY INTO; they aren’t valid options for removing files from the stage during a load, so they wouldn’t achieve the purging effect.