CertPrepNow
SnowflakeDEA-C02100 cards5 domains

DEA-C02 Flashcards

Active recall study cards for the SnowPro Advanced: Data Engineer exam. Flip each card to reveal the answer, filter by domain, or shuffle for spaced repetition.

0 / 100 cards reviewed0% done
x
Card 1 of 100
data-movement

What compute does COPY INTO use versus Snowpipe, and how does this affect cost?

Click to reveal answer

Answer

COPY INTO uses virtual warehouse credits (your configured compute). Snowpipe uses Snowflake-managed serverless compute credits. Snowpipe is not free — it accrues separate serverless credit costs. The key distinction: COPY INTO requires an active warehouse; Snowpipe does not.

Click to flip back

Tip: Use Space to flip, / to navigate

Ready for the real thing?

Take a timed DEA-C02mock exam to test what you've learned.