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

> Prepare for DEA-C02 with 290 practice questions across 5 full timed exams, weighted toward Data Movement and Data Transformation. Every answer is explained.

Page: https://devopscodelab.com/exams/snowpro-advanced-data-engineer/

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

| Setting | Value |
| --- | --- |
| 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 format before you book.

## Domains and weights

| Domain | Weight | 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 |

## Price and access

- DEA-C02 practice exams: $14.99 for 12 months of access.
- Free mini exam: 15 questions with explanations (free account): https://devopscodelab.com/app/exams/snowpro-advanced-data-engineer/mini/
- All-Access subscription includes every exam: https://devopscodelab.com/pricing/
- 10 free questions with answers: https://devopscodelab.com/exams/snowpro-advanced-data-engineer/free-practice-questions/

## 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?

- A. An external volume and a catalog integration for Glue, then Iceberg tables that use that catalog
- B. A Snowflake-managed Iceberg table with CATALOG = 'SNOWFLAKE' and a task that copies from Glue
- C. A Snowpipe that loads the Iceberg data files into standard Snowflake tables as soon as each Spark job commits a snapshot
- D. A storage integration and an external table with TABLE_FORMAT = DELTA on the warehouse folder

**Answer:** A

**Explanation:** 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?

- A. CREATE TABLE ... USING TEMPLATE over INFER_SCHEMA output, then ENABLE_SCHEMA_EVOLUTION = TRUE with MATCH_BY_COLUMN_NAME on COPY
- B. An external table with AUTO_REFRESH = TRUE and a view that selects each new field with $1:field_name syntax
- C. CREATE TABLE ... AS SELECT from the stage, then a stream on the table to detect new fields and ALTER it
- 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

**Answer:** A

**Explanation:** 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?

- A. A storage integration whose STORAGE_ALLOWED_LOCATIONS lists the partner's API URL as an allowed location
- B. A network policy with ALLOWED_IP_LIST set to the partner's IP addresses
- C. An API integration with API_ALLOWED_PREFIXES and an external function proxy service
- D. An egress network rule for the host plus an external access integration referenced by the procedure

**Answer:** D

**Explanation:** 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.


## 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.

DevOpsCode Lab is not affiliated with Snowflake. DEA-C02 and related names are trademarks of their owners. We write every question ourselves; these are not real exam questions.
