Exam SnowPro Core topic 1 question 341 discussion

Correct Answer : C https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html#load-history

data bulk load history ===> in the metadata of the target table for 64 days snowpipe ====> in the metadata of the pipe for 14 days

Load history 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.

1. The load history for Snowpipe operations is stored in the metadata of the pipe object , it remains for 14 days. When a pipe is recreatedthe load history is dropped

Load history is stored in the metadata of the target table for 64 days

For Snowpipe use copy_history. and for table LOAD_History, both have 14day hisotry https://docs.snowflake.com/en/sql-reference/functions/copy_history.html https://docs.snowflake.com/en/sql-reference/info-schema/load_history.html

https://docs.snowflake.com/en/user-guide/data-load-considerations-load.html#load-metadata Snowflake maintains detailed metadata for each table into which data is loaded .... This load metadata expires after 64 days. If the LAST_MODIFIED date for a staged data file is less than or equal to 64 days, the COPY command can determine its load status for a given table and prevent reloading (and data duplication).

It is C

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. https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html#load-history

I think, since it is Bulk loading. Answer is A

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