SnowPro Advanced: Data Engineer

Exam format

Snowflake logo

SnowPro Advanced: Data Engineer Exam Format

DEA-C02

Everything the official exam blueprint specifies: question count, time limit, scoring and the weight each domain carries. The SnowPro Advanced Data Engineer certification verifies the ability to design and operate modern data pipelines in Snowflake. Candidates must master data movement, large-scale transformations, performance optimization, storage protection, and governance controls. Certification scenarios demand real-world decisions about Snowpipe, Streams, Tasks, Dynamic Tables, Time Travel, replication, and row-level security. The exam focuses on integration, troubleshooting, and architectural best practices.

65 questions
115 min
70% to pass
5 domains

Exam facts at a glance

The published specifications for this certification.

SpecificationValue
Questions65
Time limit115 minutes (106s per question)
Passing score70% — Passing Score: 750 + Scaled Scoring from 0 - 1000 (SnowPro Program Policies: "Snowflake uses a scale of 0-1000 with a passing scaled score of 750.")
Domains5
LevelProfessional
Question bank here65 questions
Published formatTotal Number of Questions: 65; Time Limit: 115 minutes; Question Types: Multiple Select, Multiple Choice, Interactive; Language: English
SourceOfficial exam specification, published by the vendor

Official domain weights

The percentage of the exam each domain carries. Weight your revision by these numbers, not by what you find hardest.

DomainWeightTopicsPractice Qs
Data Movement28%
  • COPY INTO and stage loading
  • Partitioned data ingestion from cloud storage
  • File formats and compression
  • +5 more
18
Data Governance14%
  • Column and row access policies
  • Masking policies
  • Tags and classifications
  • +5 more
9
Data Transformation25%
  • Advanced and window functions
  • Streams and change data capture
  • Tasks and DAG orchestration
  • +5 more
16
Performance Optimization19%
  • Query profiling and EXPLAIN
  • Warehouse sizing and concurrency
  • Clustering keys and automatic clustering
  • +5 more
13
Storage and Data Protection14%
  • Time Travel
  • Fail-safe
  • Cloning and zero-copy cloning
  • +5 more
9

The heaviest domain is Data Movement at 28%, and that is where lost points cost you the most. Certilum scores you per domain so you can see the difference between a knowledge gap and a formatting problem.

Note from the vendor record: Issuer: Snowflake, Inc. The official certification page lists Exam Version DEA-C02 as the current version of SnowPro Advanced: Data Engineer (verified via the page's official exam-details data); no retirement or effective date for the earlier DEA-C01 is published on Snowflake's official pages. Prerequisite as published: "SnowPro Core Certified"; candidate profile: 2+ years hands-on data engineering experience. Delivery: online proctoring or onsite testing centers (Pearson VUE), English only, with unscored items included. Renewal: all SnowPro certifications follow a two-year renewal cycle via the Continuing Education program (eligible ILT course or earning an equivalent/higher SnowPro certification). Caveat: fees shown differ by region (India $300). Official exam page

More about the SnowPro Advanced: Data Engineer exam

Explore the rest of this page series: format, cost, difficulty, requirements and how to prepare.

Related certifications

Explore other certifications in the same category and see how they stack up.

Frequently asked questions

Everything you need to know about the SnowPro Advanced: Data Engineer exam.