Free study guide

Snowflake DEA-C02 Study Guide

SnowPro Advanced: Data Engineer DEA-C02

The SnowPro Advanced: Data Engineer (DEA-C02) exam is Snowflake's advanced-level certification for data engineers who already hold SnowPro Core. It covers moving data into and out of Snowflake with continuous pipelines, tuning performance and cost, protecting and recovering data, governing data, and transforming it with UDFs, stored procedures, Snowpark and Cortex. It suits data engineers with hands-on Snowflake experience in production.

  • Exam code DEA-C02
  • Advanced level
  • 5 exam domains

This guide is free, with no sign-up. It explains every Snowflake DEA-C02 exam topic in plain English, one chapter at a time. Read them in order or jump straight to the topic you need.

  • 5chapters
  • 49topics
  • 15diagrams and exhibits
  • 3 h 55 minfast track
  • Every topic follows the same simple pattern: what it is, how it works, common mistakes
  • Diagrams and real command output where a picture explains it best
  • Exam tips and worked subnetting and IPv6 practice, with answers

How the exam is weighted

Each domain is worth this share of the exam, so spend your study time in proportion. Select a domain to open its chapter.

Chapters

Open a chapter to see its topics and how long each takes.

1Data Movement17 topics · 1 h 27 min fast trackLoading, file formats, stages, error troubleshooting, pipelines, Snowpipe, streaming and connectors.
2Performance Optimization7 topics · 35 min fast trackQuery troubleshooting, warehouses, clustering, caching, cost control and pipeline monitoring.
3Storage and Data Protection4 topics · 20 min fast trackTime Travel, Fail-safe, replication, clustering, cloning, validating and rolling back changes.
4Data Governance7 topics · 31 min fast trackTags, classification, lineage, data quality, Horizon Catalog, masking, row policies and Data Clean Rooms.
5Data Transformation14 topics · 1 h 2 min fast trackUDFs, external functions, stored procedures, transactions, semi-structured and unstructured data.

Ready for more practice?

The full Snowflake DEA-C02 question bank has 709 questions, with timed practice exams and an explanation for every answer.

This study guide is independent and is not affiliated with, endorsed by, or sponsored by Snowflake. Vendor names, certification names and exam codes are trademarks of their respective owners and are used for identification only.