Snowflake · SF-DE · Advanced
SnowPro Advanced: Data Engineer (DEA-C02) — Practice Questions and Mock Exam
Practice real SF-DE questions, never dumps. Alex explains every answer, and your readiness score tells you when you're ready to pass.
Checked against Snowflake · April 2026Current exam version
Overview
About the exam
The SnowPro Advanced: Data Engineer Certification (DEA-C02) validates expertise in building and optimizing data pipelines on Snowflake, including data ingestion from lakes, APIs, and on-premise sources, data transformation and cloning, real-time streaming with Snowpipe and tasks, scalable compute management, and performance analytics. It tests the full data engineering lifecycle within Snowflake.
This certification is designed for data engineers, ETL developers, and pipeline architects with two or more years of production Snowflake experience. It demonstrates the ability to build reliable, performant data infrastructure and is one of the most sought-after Advanced certifications in the Snowflake ecosystem.
Exam Domains
What's on the exam
The exam consists of 65 questions — multiple-choice, multiple-select, and true/false — to be completed in 115 minutes. Questions cover five domains: Data Transformations (30%), Data Movement (28%), Performance Optimization (22%), Storage & Data Protection (10%), and Security (10%). A passing score is 750 out of 1000. Budget extra time for multi-step pipeline scenario questions that dominate the transformation and movement domains.
Design and implement data loading, unloading, and replication using Snowpipe, COPY, external stages, and data sharing.
Optimize query performance, warehouse configuration, clustering keys, search optimization, and resource monitoring.
Manage storage, Time Travel, Fail-safe, data retention, cloning, and data protection strategies.
Implement data governance using tags, policies, masking, row access policies, and object tagging.
Build data transformations using streams, tasks, stored procedures, UDFs, and Snowpark for pipeline automation.
SourceSnowflake exam page
Format
What to expect
Watch out
Where candidates struggle
Data engineers who haven't built actual Snowpipe and Task/Stream pipelines often fail questions about continuous ingestion patterns, change data capture mechanics, and MERGE statement nuances.
- 01Streams vs Tasks — Confusing Streams (change tracking on tables) with Tasks (scheduled SQL execution) and not understanding how they combine for continuous pipelines causes CDC question errors.
- 02Snowpipe vs COPY INTO — Not knowing when to use Snowpipe (continuous, event-driven) versus COPY INTO (batch, on-demand) for different ingestion patterns leads to architecture mistakes.
- 03Transient vs Temporary — Mixing up transient tables (no Fail-Safe, persist across sessions) with temporary tables (session-scoped, auto-dropped) leads to wrong storage optimization answers.
- 04MERGE Semantics — Not understanding MERGE statement behavior with duplicate matches, non-deterministic results, and the difference between matched/not-matched clauses causes transformation errors.
- 05Zero-Copy Cloning — Misunderstanding that clones share storage until modified and that cloning a schema or database also clones all child objects leads to incorrect storage and pipeline answers.
Details
Exam logistics
Delivered online via the Snowflake Certification Portal. Available in English and Japanese. The certification is valid for 2 years. Renewal requires recertification or continuing education credits. Exam fee is $375 USD. Prerequisite: active SnowPro Core certification.
SourceSnowflake exam page
Before you book the exam
Would you pass SF-DE today?
Take the free readiness check. Answer real SF-DE questions and get your readiness score across every domain.
Take the free readiness check20 questions · freeReach 80% readiness by exam day. Pass, or your money back.