ExamDumpster

SnowPro-Advanced-Data-Engineer

SnowFlake SnowPro Advanced Data Engineer DEA-C02 practice test

188 Snowflake SnowPro-Advanced-Data-Engineer practice questions with explanations, in study, timed and flashcard modes. 20 sample questions are free.

Full access

$99

  • All 188 questions, with explanations
  • Study, timed and flashcard modes
  • Progress saved, resume any time
Try the free samples first
Snowflake logo
Questions
188
Free samples
20
Versions
1
Updated
Oct 2025

Exam simulator

Practice SnowPro-Advanced-Data-Engineer in the simulator.

Study, timed and flashcard modes. Answers and explanations as you go, and your progress saves.

At a glance

SnowPro-Advanced-Data-Engineer, by the numbers.

Official specifications published by Snowflake.

Duration
115 min
Questions
65
Passing score
750
Exam fee
$375
Open the full exam guide

Exam guide

Everything about SnowFlake SnowPro Advanced Data Engineer DEA-C02.

SnowPro-Advanced-Data-Engineer · Snowflake · v2.0

What is SnowFlake SnowPro Advanced Data Engineer DEA-C02?

DEA-C02 is the SnowPro Advanced: Data Engineer exam, and passing it shows you can build Snowflake data pipelines. Data engineers, ETL developers and analytics engineers usually take it after SnowPro Core. It asks you to load and transform data, keep it safe and make queries run faster. You should know streams: objects that record changes to a table so a pipeline can process only the new rows. For example, you may work out why a load of JSON files keeps failing, then fix it. Questions in this practice test cover data movement, transformation, performance, storage and security.

What you'll practise

  • Load files and streaming data with COPY INTO and Snowpipe, and fix failed loads.
  • Find the cause of slow queries, then tune warehouse settings and caching.
  • Use Time Travel, streams and micro-partition details to protect and track data.
  • Apply system-defined roles and governance rules to pipeline data.
  • Write user-defined functions (UDFs), external functions and stored procedures.

Requirements

  • You must hold an active SnowPro Core Certification.
  • Recommended: two or more years as a data engineer in a production setting.
  • Recommended: SQL with semi-structured data, REST APIs and cloud-native concepts.
  • Recommended: programming in Python, Java or JavaScript.

Who it's for

  • Data engineers and ETL or ELT developers who build Snowflake pipelines.
  • Analytics engineers who shape raw data into models for reporting.
  • Data pipeline architects and cloud data engineers.

Exam details

Published by Snowflake, plus what is in our question bank.

Duration
115 min
Questions
65
Passing score
750
Level
Advanced
Question types
Multiple Choice, Multiple Select, Drag and Drop, Matching

Three ways to practise

Study mode

Work through the bank at your own pace with the answer and explanation one tap away. Flag questions, add notes, bookmark the hard ones.

Open in the simulator

Timed mode

A shuffled deck with a countdown that mirrors the real exam. Your score is saved to your attempt history.

Open in the simulator

Flashcards

Question on the front, answer on the back. Good for the last week before the exam.

Open in the simulator

SnowPro-Advanced-Data-Engineer questions, answered