Exam SnowPro Core topic 1 question 200 discussion

Bulk data load Stored in the metadata of the target table for 64 days. Available upon completion of the COPY statement as the statement output. Snowpipe Stored in the metadata of the pipe for 14 days. Must be requested from Snowflake via a REST endpoint, SQL table function, or ACCOUNT_USAGE view. source : https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro

C.14 days

C.14 days

C. 14 days

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;

Correct

COPY INTO - Stored in the metadata of the target table for 64 days SNOWPIPE - Stored in the metadata of the pipe for 14 days

Correct ans 14 days

C https://docs.snowflake.com/en/sql-reference/functions/copy_history.html

https://docs.snowflake.com/en/sql-reference/info-schema/load_history.html