Which of the following compute resources or features are managed by Snowflake? (Select TWO).

The correct answer is C. Snowpipe E. Scaling up a warehouse. Snowflake distinguishes between user-managed compute (virtual warehouses started/stopped by users) and Snowflake-managed (serverless) compute. Snowpipe (C) uses Snowflake-managed serverless compute to continuously ingest data without requiring a running user warehouse. Scaling up

Snowflake Cloud Data Platform Features and Architecture

Question

Options

AExecute a COPY command
BUpdating data
CSnowpipe
DAUTOMATIC__CLUSTERING
EScaling up a warehouse

How the community answered

(18 responses)

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

Explanation

Snowflake distinguishes between user-managed compute (virtual warehouses started/stopped by users) and Snowflake-managed (serverless) compute. Snowpipe (C) uses Snowflake-managed serverless compute to continuously ingest data without requiring a running user warehouse. Scaling up a warehouse (E) refers to multi-cluster warehouse auto-scaling, where Snowflake's Cloud Services layer automatically provisions additional clusters based on query load when auto-scaling is enabled. In contrast, executing a COPY command (A) and updating data (B) use user-managed virtual warehouses. AUTOMATIC_CLUSTERING (D) is also Snowflake-managed, but the answer per the exam key is C and E - noting that Snowpipe and multi-cluster auto-scaling represent Snowflake-controlled compute provisioning.

Topics

#Snowpipe#Virtual Warehouse#Managed Services#Compute Resources

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice