Exam SnowPro Core All QuestionsBrowse all questions from this exam
Go to Exam
Question 200

How many days is load history for Snowpipe retained?

    Correct Answer: C

    Load history for Snowpipe is retained for 14 days. This history is stored in the metadata of the pipe object and includes information such as the date and time of the load, the number of files loaded, and the size of the data loaded.

Discussion
shyemkoOption: 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. 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

EmiBOption: C

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

_yyuktaOption: C

C. 14 days

NaahOption: C

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

Rob__C

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

Mallikharjuna452Option: C

C.14 days

ColourseunOption: C

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;

MultiCloudIronManOption: C

Correct

muks86Option: C

Correct ans 14 days