DEA-C02

SnowPro Advanced: Data Engineer (DEA-C02) practice exams

290 questions in 5 timed practice tests. Each test has about 61 questions and a 115-minute limit. The pass mark is 75%. Results are split across the 5 exam domains.

Exam at a glance

DEA-C02 practice exam settings
Practice tests 5
Questions in total 290
Questions per test About 61
Time limit per test 115 minutes
Pass mark 75%
Question types Single answer and multiple answer (29 multiple-answer questions)
Level Professional
Category Data & Analytics

These are the settings of our practice tests. Check the official Snowflake exam page for the current exam format before you book.

Domains and weights

DEA-C02 exam domains, weights and question counts
Domain Weight Weight bar Questions in our bank
Data Movement 26% 75
Performance Optimization 21% 61
Storage and Data Protection 14% 41
Data Governance 14% 41
Data Transformation 25% 72

Sample questions

Question 1 of 3

Analysts must query Apache Iceberg tables whose metadata is maintained by an AWS Glue Data Catalog, while Spark jobs keep writing to them. Snowflake should not take over table management. What should the engineer configure?

  1. A An external volume and a catalog integration for Glue, then Iceberg tables that use that catalog (correct answer)
  2. B A Snowflake-managed Iceberg table with CATALOG = 'SNOWFLAKE' and a task that copies from Glue
  3. C A Snowpipe that loads the Iceberg data files into standard Snowflake tables as soon as each Spark job commits a snapshot
  4. D A storage integration and an external table with TABLE_FORMAT = DELTA on the warehouse folder
Why: Externally managed Iceberg tables use an external volume for storage access and a catalog integration (here AWS Glue) so Snowflake reads metadata that another engine maintains. TABLE_FORMAT = DELTA is for Delta Lake. A Snowflake-managed Iceberg table hands management to Snowflake, which conflicts with Spark writing through Glue. Loading data files into standard tables duplicates data and ignores deletes recorded in Iceberg metadata.

Question 2 of 3

A team receives Parquet files whose schema changes often as new fields appear. They want the target table created automatically from the files and new columns added automatically on later loads. Which combination meets this requirement?

  1. A CREATE TABLE ... USING TEMPLATE over INFER_SCHEMA output, then ENABLE_SCHEMA_EVOLUTION = TRUE with MATCH_BY_COLUMN_NAME on COPY (correct answer)
  2. B An external table with AUTO_REFRESH = TRUE and a view that selects each new field with $1:field_name syntax
  3. C CREATE TABLE ... AS SELECT from the stage, then a stream on the table to detect new fields and ALTER it
  4. D A VARIANT landing table loaded with STRIP_OUTER_ARRAY, followed by a scheduled task that runs ALTER TABLE ADD COLUMN for new fields each week
Why: INFER_SCHEMA with USING TEMPLATE builds the table definition from the files, and table schema evolution adds new columns during COPY when MATCH_BY_COLUMN_NAME is used. An external table plus a view needs manual view edits for each field. A stream on the table cannot see fields that were never loaded. A VARIANT landing table avoids the problem but does not produce typed columns automatically and STRIP_OUTER_ARRAY applies to JSON.

Question 3 of 3

A Snowpark Python procedure needs to call a partner's REST API to enrich rows during a load. Outbound traffic must be limited to that one host. What must be configured?

  1. A A storage integration whose STORAGE_ALLOWED_LOCATIONS lists the partner's API URL as an allowed location
  2. B A network policy with ALLOWED_IP_LIST set to the partner's IP addresses
  3. C An API integration with API_ALLOWED_PREFIXES and an external function proxy service
  4. D An egress network rule for the host plus an external access integration referenced by the procedure (correct answer)
Why: External network access from UDFs and procedures requires an egress network rule naming allowed hosts and an external access integration referenced in the function definition. Storage integrations govern stage access. Network policies restrict inbound client connections to Snowflake. External functions with API integrations go through a cloud proxy service rather than letting procedure code call the host directly.

What your score report looks like

Example attempt, DEA-C02 practice test 3

80%

Passed
Pass mark 75%

Score by exam domain
DomainWeightYour score%
Data Movement 26%
88
Performance Optimization 21%
81
Storage and Data Protection 14%
76
Data Governance 14%
58
Data Transformation 25%
84

Study next: Data Governance. It is below the pass mark and carries 14% of the exam.

Domains and pass mark from our DEA-C02 practice tests. Scores are an example attempt.

Study plans

Two weeks

  1. Day 1: take practice test 1 in exam mode to get a baseline.
  2. Days 2 to 5: domain mode on Data Movement and Data Transformation, the two most heavily weighted domains.
  3. Day 6: practice test 2 in exam mode, then the mistakes quiz.
  4. Days 7 to 12: practice tests 3 to 5, one every other day, each followed by its mistakes quiz.
  5. Days 13 and 14: final mode. Book the exam when your readiness stays above the pass mark.

Four weeks

  1. Week 1: one practice test in practice mode, reading every explanation. Note your two lowest domains.
  2. Week 2: domain mode on those two domains, then a second practice test in exam mode.
  3. Week 3: practice tests 3 and 4 in exam mode, with the mistakes and flagged quizzes after each.
  4. Week 4: practice test 5 and final mode until your readiness holds above the pass mark.

Questions about the DEA-C02 practice exams

Are these real DEA-C02 exam questions?
No. We write every question ourselves and map it to the published DEA-C02 exam objectives. We do not use leaked or recalled questions.
Do the time limit and pass mark match the official exam?
They match the settings of our practice tests. Exam providers change their format from time to time, so check the official exam page before you book.
Can I try it before I pay?
Yes. The free mini exam has 15 questions with full explanations and needs no account.
How long do I keep access?
A single-exam purchase gives you 12 months of access. All-Access includes this exam for as long as your subscription runs.
What happens after I finish a test?
You get a score, a pass or fail against the pass mark, a score per domain and every answer with its explanation.

Last updated November 2026. Written and reviewed by the DevOpsCode Lab team.

DevOpsCode Lab is not affiliated with Snowflake. DEA-C02 and related names are trademarks of their owners.

Related exams
Exam Vendor Level Questions Minutes Price
COF-C03SnowPro Core COF-C03 Snowflake Associate 300 70 $12.99
ARA-C01SnowPro Advanced: Architect ARA-C01 Snowflake Professional 300 105 $14.99
DP-900Azure Data Fundamentals DP-900 Microsoft Foundational 225 45 $9.99
SPLK-1001Splunk Core Certified User (SPLK-1001) Splunk Foundational 300 60 $9.99
1Z0-071Oracle Database SQL 1Z0-071 Oracle Associate 315 120 $12.99
1Z0-082Oracle Database Admin I 1Z0-082 Oracle Associate 300 100 $12.99