Answer: 14 days

The correct answer is C (14 days) based on Snowflake documentation and community consensus. Snowpipe load history is stored in the metadata of the pipe object for 14 days, as confirmed by multiple community members referencing official Snowflake documentation. This differs from bulk data load using COPY INTO commands, where load history is retained for 64 days in the target table metadata. The community discussion shows unanimous agreement on option C with supporting documentation links and explanations about how to access Snowpipe load history via INFORMATION_SCHEMA.PIPE_LOAD_HISTORY or other methods.

Author: LeetQuiz Editorial Team