Back to index
OtherCommonly reported as 65 questions in 115 minutes; Snowflake asks for 2 or more years of hands-on production data engineering·$375 per attempt, every registration charged in full; requires an active SnowPro Core certification

SnowPro Advanced: Data Engineer (DEA-C02)

3.9

A genuinely harder exam than SnowPro Core, with scenario questions about streams, tasks, Snowpipe, dynamic tables and warehouse sizing that reward real production experience. It is also expensive at $375 a go with no bundled retake, and it barely touches Cortex or anything AI-related.

What We Liked

  • Scenario-based questions that are hard to pass on memorisation alone
  • Focus on near real-time pipelines and compute design matches the problems Snowflake teams actually face
  • Cross-cloud replication and data sharing get proper attention, which few other exams cover
  • Snowflake states the two-year production experience expectation honestly rather than marketing it to beginners
  • Strong signal in the Snowflake partner ecosystem and with consultancies

What Could Be Better

  • $375 per attempt, and the FAQ is explicit that every registration costs the full amount
  • Requires SnowPro Core first, so the real entry cost is $550 or more
  • Exam format and pass mark sit in the study guide rather than on the main page, and most format figures online come from third parties
  • Very little on Cortex AI functions or feature pipelines despite Snowflake's AI Data Cloud pitch
  • Search interest is down about 30% year on year, and recognition outside Snowflake shops is limited

Detailed review

SnowPro Advanced: Data Engineer is the exam Snowflake engineers take after Core, and the current version is DEA-C02. Snowflake's page gives $375 per attempt and states plainly in its FAQ that each registration requires the full amount, so there is no discounted retake. The candidate profile asks for two or more years of hands-on experience as a data engineer in a production environment, and you need an active SnowPro Core certification before you can sit it. The format is widely reported as 65 questions in 115 minutes with a scaled pass mark of 750 out of 1000, but those numbers come from third-party sources; Snowflake puts the detail in its study guide rather than on the main page. The skills listed on the page are sourcing data from data lakes, APIs and on-premises systems, transforming, replicating and sharing data across cloud platforms, designing end-to-end near real-time streams, designing scalable compute for data engineering workloads, and evaluating performance metrics.

In practice that means a lot of questions about Snowpipe and Snowpipe Streaming, streams and tasks, dynamic tables, external and Iceberg tables, warehouse sizing and clustering. I rate the exam more highly than Core because the questions are built around scenarios. You get a pipeline with a latency requirement and a cost constraint and have to pick the right combination, which is a much better test than recalling which edition includes a feature. People who have only done courses tend to find it noticeably harder than Core, and that is a good sign. The cost is the obvious drawback. With Core at $175 and this at $375, the minimum is $550 before any retakes, and every retake is another $375.

The Databricks Data Engineer Professional is $200 and spends more of its weight on monitoring and cost optimisation, which I think are the most valuable skills in either platform. Snowflake does test performance evaluation here, but the cost side feels lighter for a platform where an oversized warehouse left running is the classic way to blow a budget. The other gap is AI. Snowflake now sells itself as the AI Data Cloud and ships Cortex functions, Cortex Search and Snowpark ML, but this exam is about classic data engineering. That is not a bad thing in itself, because good AI work still sits on good pipelines, but it means this cert says nothing about whether you can build retrieval or feature pipelines.

For that you would look at Snowflake's separate Gen AI specialty, which we cover elsewhere. Search interest is down about 30% on last year. I would read that less as the cert losing value and more as Snowflake's engineering market maturing. If you work in a Snowflake consultancy or partner, this is one of the credentials that actually gets noticed. Outside that world, a GitHub repo of a working pipeline will usually say more.

[ final ]

The verdict.

Worth it for working Snowflake data engineers and consultants, especially at partner firms where advanced certs count. Do not take it to learn Snowflake; take it once you have run pipelines in production and want proof. If your budget is tight, the Databricks Data Engineer Professional is cheaper and covers more of the cost and monitoring side.