Overview
162 real exam questions for the Snowflake SnowPro Advanced: Data Engineer (DEA-C02).
The questions you've seen on my YouTube channel come from this PDF - but I only share 20 to 30% of the bank publicly. This is the complete set: every question from the actual exam, word for word.
-
162 real exam questions - pulled from the actual DEA-C02 exam
-
Instant delivery - sent to your email immediately after purchase
- Free updates every month, forever
-
Full refund if you fail - no questions asked
Fail the DEA-C02 and it's another US$375 plus weeks of restudying. This PDF is US$39 - once, with a refund if you fail anyway.
Last updated: July 2026 - 162 questions
Deep Dive
DEA-C02 is the current Data Engineer code - the C01 bank is stale - and it tests pipeline engineering at the depth where Snowpipe, Streams, and Tasks stop being features and start being failure modes.
The recurring marks: ingestion architecture - Snowpipe versus Snowpipe Streaming versus COPY, CDC patterns with Streams and their offset behaviour, Task DAGs and error handling, Snowpark and UDF/UDTF choices, dynamic tables versus materialised views, and the performance questions - warehouse sizing, clustering, query profile reading. The distractors are yesterday's best practice.
Same buyers as my Core, Databricks, and DP-line banks - data engineers collect these. This PDF has 162 real questions from the actual DEA-C02.
Exam Info
SnowPro Advanced: Data Engineer (DEA-C02) certifies building and optimising data pipelines on Snowflake - ingestion and CDC, transformation with Snowpark and SQL, dynamic tables, performance, and governance. Requires an active SnowPro Core certification. Valid 2 years.
Exam topics
- Data movement - Snowpipe, streaming, COPY, connectors
- Transformation - Streams, Tasks, dynamic tables, Snowpark
- Performance optimisation and cost management
- Storage, data protection, and governance
- Security in data engineering workflows
65 questions, 115 minutes, scaled passing score 750/1000, US$375 per attempt, online proctored or test centre, valid 2 years.
