COF-C02 Question 264

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose C1

  Agreed

• Chose C1

  C.14 days

• 1

  C.14 days

• Chose C2

  C. 14 days

• 1

  Load history for Snowpipe is retained for 14 days:C Snowflake stores load history for Snowpipe in the metadata of the pipe object. This history includes information such as the date and time of the load, the number of files loaded, and the size of the data loaded. SELECT * FROM INFORMATION_SCHEMA.PIPE_LOAD_HISTORY WHERE PIPE_NAME = '<pipe_name>' ORDER BY START_TIME DESC;