Answer: 14 days

The correct answer is D (14 days) based on Snowflake documentation and community consensus. Snowpipe data load history is retained for 14 days by default when a pipe is paused, after which it becomes stale. This is confirmed by multiple community members with upvotes, references to official Snowflake documentation (PIPE_USAGE_HISTORY function), and the unanimous 100% agreement in the community discussion. Option A is incorrect as retention is not configurable in CREATE PIPE settings. Option B is incorrect because retention is time-based, not tied to the pipe's existence. Option C (64 days) is incorrect as it does not match Snowflake's documented 14-day retention period.

Author: LeetQuiz Editorial Team