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.
Full access
$99
- All 188 questions, with explanations
- Study, timed and flashcard modes
- Progress saved, resume any time
- Questions
- 188
- Free samples
- –
- 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

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.
What does SnowFlake SnowPro Advanced Data Engineer DEA-C02 cover?
5 weighted domains. Open a domain for its topics, and a topic for its objectives. Practice questions are tagged to these.
How do I earn this certification?
Passing SnowPro-Advanced-Data-Engineer earns the SnowPro Advanced Data Engineer in the Data Engineering track.
How to study for this exam?
Use the SnowPro-Advanced-Data-Engineer practice test alongside the official material and the study plan below.
What's changed on this exam?
Status and coverage changes that affect what you should study.
- Current status
- ACTIVE
- Last content update
- Feb 18, 2025
- Announced
- Dec 15, 2024
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 simulatorTimed mode
A shuffled deck with a countdown that mirrors the real exam. Your score is saved to your attempt history.
Open in the simulatorFlashcards
Question on the front, answer on the back. Good for the last week before the exam.
Open in the simulator