Which Snowflake feature will allow small volumes of data to continuously load into Snowflake and will incrementally make the data available for analysis?

The correct answer is B. CREATE PIPE. Snowpipe, created with the CREATE PIPE command, is Snowflake's continuous data ingestion service. It monitors a cloud storage stage for new files and automatically loads them as soon as they arrive, incrementally making data available for querying with low latency. COPY INTO…

Data Loading and Unloading

Question

Options

ACOPY INTO
BCREATE PIPE
CINSERT INTO
DTABLE STREAM

How the community answered

(52 responses)

A
4% (2)
B
92% (48)
C
2% (1)
D
2% (1)

Explanation

Snowpipe, created with the CREATE PIPE command, is Snowflake's continuous data ingestion service. It monitors a cloud storage stage for new files and automatically loads them as soon as they arrive, incrementally making data available for querying with low latency. COPY INTO (A) is a batch loading command that must be manually triggered or scheduled. INSERT INTO (C) is a DML statement for inserting individual rows, not for streaming file-based loads. TABLE STREAM (D) tracks change data capture (CDC) on a table - it does not load external data.

Topics

#Snowpipe#Continuous Data Loading#Incremental Data Loading#Data Ingestion

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice