Exam SnowPro Advanced Data Engineer topic 1 question 23 discussion

Files modified and staged again within 14 days : Snowpipe ignores modified files that are staged again. To reload modified data files, it is currently necessary to recreate the pipe object using the CREATE OR REPLACE PIPE syntax.

https://docs.snowflake.com/en/sql-reference/sql/create-pipe#usage-notes FORCE is not a valid option for Snowpipe: -----All COPY INTO <table> copy options are supported except for the following: FILES = ( 'file_name1' [ , 'file_name2', ... ] ) ON_ERROR = ABORT_STATEMENT SIZE_LIMIT = num PURGE = TRUE | FALSE (i.e. automatic purging while loading) FORCE = TRUE | FALSE RETURN_FAILED_ONLY = TRUE | FALSE VALIDATION_MODE = RETURN_n_ROWS | RETURN_ERRORS | RETURN_ALL_ERRORS

I think is D. If you modify the COPY INTO statement you need to recreate the pipe. Then you need to (1) modify the COPY INTO and (2)recreate the pipe. 2 Steps. If you recreate the pipe directly you will reload again the files. 1 Step.

C. Set the FORCE=TRUE option in the Snowpipe COPY INTO command. Using the FORCE=TRUE option in the Snowpipe COPY INTO command allows reloading files even if they have been loaded previously. This can be useful in situations where you need to reload data, and the metadata of the pipe is preventing the same files from being loaded again. It minimizes operational overhead by avoiding the need to wait for metadata expiration or modifying the files.

According to https://docs.snowflake.com/en/sql-reference/sql/copy-into-table FORCE = TRUE would "load all files, regardless of whether they’ve been loaded previously and have not changed since they were loaded". The question asked for the least impact. C is the least impact

Snowpipe ignores modified files that are staged again. To reload modified data files, it is currently necessary to recreate the pipe object using the CREATE OR REPLACE PIPE syntax. https://docs.snowflake.com/en/user-guide/data-load-snowpipe-ts