SnowPro DEA-C02 exam guide covering pipelines, transformations, governance, and performance decisions.
This guide targets Snowflake SnowPro Advanced: Data Engineer (DEA-C02), the current English advanced data-engineering certification on Snowflake. As of April 13, 2026, Snowflake’s live DEA-C02 overview page and update FAQ both point to the current DEA-C02 version released on February 18, 2025, and the FAQ says that after March 31, 2025 only DEA-C02 remained available in English. This guide follows the five official Snowflake capability areas exposed on the current public overview page.
Dynamic table: Snowflake-managed table that refreshes from upstream objects based on a defined query and target freshness behavior.
Snowpipe Streaming: Ingestion path for lower-latency streaming writes into Snowflake without relying only on staged-file polling.
Secure Data Sharing: Snowflake mechanism that lets a provider expose live governed data to a consumer account without copying the data into that consumer’s storage first.
| Exam fact | Current official signal |
|---|---|
| Current English version | DEA-C02 |
| Current public version timing | released February 18, 2025; only DEA-C02 remained available in English after March 31, 2025 |
| Total questions | 65 |
| Question types in Snowflake’s update FAQ | multiple select, multiple choice, and interactive items such as drag-and-drop and matching |
| Candidate guidance | 2 or more years of hands-on production data-engineering experience |
| Advanced certification price | $375 USD per attempt |
| Guide model | 5 official capability chapters -> 10 section lessons |
Snowflake’s current public DEA-C02 pages do not expose the full weighted domain table, but they do expose the five official capability lanes the exam is designed to validate. That is the structure this guide uses. Strong DEA-C02 answers usually begin by classifying the responsibility first: ingest, transform, orchestrate near real-time flow, deliver across platforms, or evaluate and tune performance. The trap is often not choosing a nonsense answer. The trap is choosing a feature that works, but owns the wrong responsibility.
Snowflake’s current public DEA-C02 overview page says the certification validates the ability to do these five things. This guide follows that map directly.
| Official capability area | Chapter | Start here |
|---|---|---|
| Source data from Data Lakes, APIs, and on-premises | 1. Source Data & Ingest | 1.1 Stages, Formats & COPY INTO, 1.2 Snowpipe, Streaming & Semi-Structured |
| Transform, replicate, and share data across cloud platforms | 2. Transform, Share & Replicate | 2.1 Dynamic Tables, ELT & Snowpark, 2.2 Sharing, Replication & Failover |
| Design end-to-end near real-time streams | 3. Near Real-Time Streams | 3.1 Streams, Change Tracking & Tasks, 3.2 Dynamic Tables, Tasks & Streaming |
| Design scalable compute solutions for Data Engineer workloads | 4. Scalable Compute | 4.1 Warehouse Fit & Serverless, 4.2 Task Compute, Concurrency & Cost |
| Evaluate performance metrics | 5. Performance Evidence | 5.1 History, Profile & Bottlenecks, 5.2 Pruning, Clustering & Troubleshooting |
flowchart LR
A["1. Staging and ingestion boundaries"] --> B["2. Transform, replicate, and share"]
B --> C["3. Near real-time streams and orchestration"]
C --> D["4. Compute design and cost control"]
D --> E["5. Performance diagnosis and final review"]
| Failure pattern | Better instinct |
|---|---|
| treating streams, tasks, and dynamic tables as synonyms | identify which object owns change capture, scheduling, or managed refresh |
| unloading or copying data when live sharing is the real requirement | separate delivery and sharing patterns carefully |
| sizing warehouses before reading query or history evidence | diagnose first, resize second |
| using Snowpark or procedural logic when SQL-native ELT or dynamic tables fit directly | choose the lightest Snowflake-native abstraction that solves the job |
| mixing near real-time design with batch staging logic | the latency target changes the correct ingest and orchestration choice |