Answer: CREATE PIPE

The correct answer is CREATE PIPE because Snowflake Pipes are specifically designed for continuous data loading scenarios. Pipes use Snowpipe, which automatically loads data from external stages as soon as files are available, making data incrementally available for analysis. This matches the requirement for 'continuous loading' and 'incrementally making data available' mentioned in the question. COPY INTO (A) is for bulk loading and requires manual execution, INSERT INTO (C) is for inserting individual rows rather than continuous file loading, and TABLE STREAM (D) is for change data capture on existing tables, not for loading new data from external sources. The community discussion shows 100% consensus on answer B, with users highlighting that 'continuously' is the key indicator for Pipes.

Author: LeetQuiz Editorial Team