What compute resource is used when loading data using Snowpipe?

The correct answer is C. Snowpipe uses compute resources provided by Snowflake. Snowpipe is a serverless, continuous data ingestion service. Unlike the COPY INTO command (which requires a user-managed virtual warehouse), Snowpipe uses Snowflake-managed compute resources that are automatically provisioned and scaled by Snowflake. Users are billed based on…

Data Loading and Unloading

Question

Options

ASnowpipe uses virtual warehouses provided by the user.
BSnowpipe uses an Apache Kafka server for its compute resources.
CSnowpipe uses compute resources provided by Snowflake.
DSnowpipe uses cloud platform compute resources provided by the user.

How the community answered

(18 responses)

A
6% (1)
C
89% (16)
D
6% (1)

Explanation

Snowpipe is a serverless, continuous data ingestion service. Unlike the COPY INTO command (which requires a user-managed virtual warehouse), Snowpipe uses Snowflake-managed compute resources that are automatically provisioned and scaled by Snowflake. Users are billed based on compute seconds used rather than warehouse credits. This serverless model means there is no need to manage warehouse sizing or availability for ingestion, and Snowpipe can load data continuously as files arrive in a stage.

Topics

#Snowpipe#Data Loading#Compute Resources#Serverless

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice