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
| 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
| 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?
- A An external volume and a catalog integration for Glue, then Iceberg tables that use that catalog (correct answer)
- 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
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 (correct answer)
- 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
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 (correct answer)
See all 10 free DEA-C02 questions with answers Read them or quiz yourself.
What your score report looks like
Example attempt, DEA-C02 practice test 3
80%
Passed
Pass mark 75%
| Domain | Weight | Your 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.
Study plans
Two weeks
- Day 1: take practice test 1 in exam mode to get a baseline.
- Days 2 to 5: domain mode on Data Movement and Data Transformation, the two most heavily weighted domains.
- Day 6: practice test 2 in exam mode, then the mistakes quiz.
- Days 7 to 12: practice tests 3 to 5, one every other day, each followed by its mistakes quiz.
- Days 13 and 14: final mode. Book the exam when your readiness stays above the pass mark.
Four weeks
- Week 1: one practice test in practice mode, reading every explanation. Note your two lowest domains.
- Week 2: domain mode on those two domains, then a second practice test in exam mode.
- Week 3: practice tests 3 and 4 in exam mode, with the mistakes and flagged quizzes after each.
- 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.
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 |