Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
SnowPro Advanced: Data Engineer · Snowflake
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
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.