SNOWFLAKE

Snowflake SnowPro Advanced — Data Engineer

DEA-C02

The SnowPro Advanced: Data Engineer certification validates your expertise in designing and implementing complex data engineering solutions on the Snowflake AI Data Cloud. It is for experienced data engineers who build and manage robust, scalable data pipelines and transformations. Earning it demonstrates your ability to apply advanced Snowflake features to solve real-world data challenges and stand out in the data community.

Practice Free Questions

5Domains

13Objectives

64Practice pages

290Free questions

DEA-C02 free practice questions

Choose any objective and open any question page — no sign-in required.

Load and unload data with COPY INTO and Snowpipe

32 questions · 7 pages

Questions 1–5 6–10 11–15 16–20 21–25 26–30 31–32

Configure stages, file formats, and connectors

25 questions · 5 pages

Questions 1–5 6–10 11–15 16–20 21–25

Ingest streaming data

28 questions · 6 pages

Questions 1–5 6–10 11–15 16–20 21–25 26–28

Transform data using SQL and Snowpark

25 questions · 5 pages

Questions 1–5 6–10 11–15 16–20 21–25

Implement streams and tasks

27 questions · 6 pages

Questions 1–5 6–10 11–15 16–20 21–25 26–27

Process semi-structured data

12 questions · 3 pages

Questions 1–5 6–10 11–12

Apply clustering keys and the Search Optimization Service

24 questions · 5 pages

Questions 1–5 6–10 11–15 16–20 21–24

Size warehouses and use query pruning

17 questions · 4 pages

Questions 1–5 6–10 11–15 16–17

Optimize data pipelines

16 questions · 4 pages

Questions 1–5 6–10 11–15 16–16

Manage Time Travel and Fail-safe

26 questions · 6 pages

Questions 1–5 6–10 11–15 16–20 21–25 26–26

Configure cloning and data retention

22 questions · 5 pages

Questions 1–5 6–10 11–15 16–20 21–22

Apply masking and row access policies

21 questions · 5 pages

Questions 1–5 6–10 11–15 16–20 21–21

Manage access control for data pipelines

15 questions · 3 pages

Questions 1–5 6–10 11–15

Want a smarter study session?Try adaptive questions aimed at your weak spots, the illustrated book, and readiness you can trust.

Continue Free Practice

Percentages reflect share of the current practice bank, not official exam weightings. Every page above is a live, crawlable practice page (13 objectives · 64 pages).

Snowflake SnowPro Advanced — Data Engineer

DEA-C02 free practice questions

Domain 1 · Data Movement29% of practice bank · 3 objectives · 85 questions29%

Domain 2 · Data Transformation22% of practice bank · 3 objectives · 64 questions22%

Domain 3 · Performance Optimization20% of practice bank · 3 objectives · 57 questions20%

Domain 4 · Storage and Data Protection17% of practice bank · 2 objectives · 48 questions17%

Domain 5 · Data Governance12% of practice bank · 2 objectives · 36 questions12%