Answer: Pipe

The correct answer is A (Pipe) because Snowpipe is specifically designed for continuous, automated data loading from cloud storage locations. When files become available in a stage, Snowpipe automatically loads them into Snowflake tables without manual intervention. The community discussion shows 100% consensus on answer A, with multiple comments confirming that Snowpipe enables loading data from files as soon as they're available in a stage. Other options are incorrect: B (External stage) is just a reference to cloud storage location, not the loading mechanism; C (Task) is for scheduling SQL operations, not automatic file loading; D (Stream) is for change data capture on tables, not loading from external files.

Author: LeetQuiz Editorial Team