Answer: Snowpipe

Snowpipe is Snowflake's continuous data ingestion service that automatically loads data from files as soon as they become available in a stage. This matches the question requirement for immediate loading when files are available. Option A (COPY_INTO) requires manual execution, Option B (Data replication) is for copying data between databases, and Option D (Direct share) is for secure data sharing between accounts, not for loading data from stages. The community discussion with 100% consensus on C and reference to Snowflake documentation confirms this is the correct answer.

Author: LeetQuiz Editorial Team