Which automatic Snowpipe feature ensures that the same data file is not loaded multiple times...

The correct answer is B. Snowpipe references the metadata of previously loaded files and will not load new files with the same metadata .

Snowflake keeps load metadata for files loaded into a table. Snowpipe uses this metadata to prevent duplicate loading of the same file into the same table.

Why B is correct:

Snowpipe tracks metadata for loaded files, including information that identifies files already processed. If the same file is encountered again, Snowpipe can use the load metadata to avoid loading it again.

Why the other options are incorrect:

A. Snowpipe does not automatically delete files from the stage after loading.

C. Snowpipe does not automatically rename staged files after loading.

D. Snowpipe does not automatically move loaded files to a temporary stage.

Official Snowflake documentation reference:

Snowflake documentation explains that Snowpipe maintains load metadata and prevents the same files from being loaded multiple times into the same table by default.