SnowPro Advanced: Data Engineer

Measured data

Snowflake logo

SnowPro Advanced: Data Engineer

DEA-C02

We scored 65 real SnowPro Advanced: Data Engineer exam questions 1-10 on question complexity and broke the result down by exam domain.

65 questions scored
5 domains
2.0/10 overall complexity

Complexity by exam domain

Higher scores mean more demanding question formats. The exam score is computed over the whole bank, not averaged across domains.

Exam complexity score2.0/10Gentle · measured across 65 bank questions
  • Data Governance9 questions · complexity 2.0/10 · Gentle

    33% multi-select · 0% scenario · 33% interactive

  • Data Movement18 questions · complexity 2.0/10 · Gentle

    33% multi-select · 0% scenario · 33% interactive

  • Data Transformation16 questions · complexity 1.9/10 · Gentle

    31% multi-select · 0% scenario · 31% interactive

  • Performance Optimization13 questions · complexity 1.8/10 · Gentle

    31% multi-select · 0% scenario · 31% interactive

  • Storage and Data Protection9 questions · complexity 2.3/10 · Gentle

    33% multi-select · 11% scenario · 33% interactive

Full per-domain breakdown

Blueprint weight, bank size and question format mix for every domain of the exam.

DomainBlueprintQuestionsSingleMultiInteractiveComplexity
Data Governance14%93332.0/10Gentle
Data Movement28%186662.0/10Gentle
Data Transformation25%166551.9/10Gentle
Performance Optimization19%135441.8/10Gentle
Storage and Data Protection14%93332.3/10Gentle

How the score is calculated

The formula is fixed and public, so anyone can reproduce these numbers from the same bank.

Every question in the SnowPro Advanced: Data Engineer bank is measured on four signals that can be read directly from the database. Each signal is expressed as a share of the questions in the domain, and the four shares are combined with fixed weights:

  • Multi-select questions (40% weight). Items with more than one correct answer. The candidate has to find all of them, which is the single hardest format in the bank.
  • Scenario questions (30% weight). Questions longer than 150 characters, which describe a situation instead of a definition and therefore test reasoning rather than recall.
  • Interactive questions (20% weight). Items that require reading code or a configuration snippet.
  • Deep explanations (10% weight). Questions whose explanation runs past 300 characters, which signals a concept with real nuance behind it.

The combined share is multiplied by ten to produce a 1-10 score. The exam-level score is computed over the whole bank rather than averaged across domains, so a small domain cannot distort the total. Figures on this page are recomputed from the live bank on every crawl.

Data set: Certilum SnowPro Advanced: Data Engineer Foundation question bank, 65 questions, 5 domains. Published by CERTILUM. This is Certilum’s own measurement of its own question bank and is not an official Snowflake statistic.

Questions analysed
65
Exam domains
5
Hardest domain
Storage and Data Protection (2.3)
Most approachable domain
Performance Optimization (1.8)
Question mix
23 single · 21 multi · 21 interactive
Measured on
Foundation

Frequently asked questions

What our SnowPro Advanced: Data Engineer complexity numbers mean and how they are produced.