Free study guide
Snowflake DEA-C02 Study Guide
SnowPro Advanced: Data Engineer DEA-C02
The SnowPro Advanced: Data Engineer (DEA-C02) exam is Snowflake's advanced-level certification for data engineers who already hold SnowPro Core. It covers moving data into and out of Snowflake with continuous pipelines, tuning performance and cost, protecting and recovering data, governing data, and transforming it with UDFs, stored procedures, Snowpark and Cortex. It suits data engineers with hands-on Snowflake experience in production.
- Exam code DEA-C02
- Advanced level
- 5 exam domains
This guide is free, with no sign-up. It explains every Snowflake DEA-C02 exam topic in plain English, one chapter at a time. Read them in order or jump straight to the topic you need.
- 5chapters
- 49topics
- 15diagrams and exhibits
- 3 h 55 minfast track
- Every topic follows the same simple pattern: what it is, how it works, common mistakes
- Diagrams and real command output where a picture explains it best
- Exam tips and worked subnetting and IPv6 practice, with answers
How the exam is weighted
Each domain is worth this share of the exam, so spend your study time in proportion. Select a domain to open its chapter.
Chapters
Open a chapter to see its topics and how long each takes.
1
- 1Loading Data - Methods, Considerations and Load Features6 min
- 2File Formats, INFER_SCHEMA and Structured, Semi-Structured and Unstructured Data5 min
- 3Stages, Storage Integrations and Encryption5 min
- 4Compression, Parsing Strategies and Staged File Metadata5 min
- 5Troubleshooting Data Ingestion - Causes and Resolutions6 min
- 6Continuous Data Pipelines - Stages, Tasks and Streams6 min
- 7Dynamic Tables and Materialized Views5 min
- 8Snowpipe, Snowpipe Streaming and the Kafka Connector6 min
- 9UDFs, Snowflake Scripting and Notebooks for Pipelines5 min
- 10The Snowflake SQL API and Openflow4 min
- 11Kafka, Spark, Python and Native Connectors5 min
- 12Secure Data Sharing Versus Cloning5 min
- 13Marketplace, Listings and Auto-Fulfillment4 min
- 14Views and Row-Level Filtering5 min
- 15Streamlit Apps for Data Consumption4 min
- 16External, Iceberg and Hybrid Tables with Horizon Federation5 min
- 17Table Management, Schema Evolution and Unloading6 min
2
- 1Troubleshooting Underperforming Queries and the Query Profile5 min
- 2Warehouse Sizing, Multi-cluster and Snowpark-optimized Warehouses5 min
- 3Query Complexity, Micro-partitions and Clustering5 min
- 4Materialized Views, Search Optimization, Query Acceleration and Caching5 min
- 5Monitoring Usage, Resource Monitors and Credit Control5 min
- 6Monitoring Streams, Tasks, Pipes and Snowpipe Streaming5 min
- 7Dynamic Table Monitoring, Alerts, Notifications and Data Quality5 min
3
4
- 1Object Tagging and Data Classification5 min
- 2Lineage, Dependencies and Data Quality4 min
- 3Horizon Catalog and Data Protection4 min
- 4Column-level Security and Masking5 min
- 5Row Access and Aggregation Policies4 min
- 6Managing Policies with DDL and Best Practices5 min
- 7Snowflake Data Clean Rooms4 min
5
- 1User-Defined Functions - SQL, JavaScript, Snowpark and Secure UDFs4 min
- 2User-Defined Table Functions and Aggregate Functions4 min
- 3External Functions - Create, Secure and Use5 min
- 4Stored Procedures - Design, SQL Scripting and JavaScript5 min
- 5Snowpark Stored Procedures and Transaction Management5 min
- 6Semi-Structured Data - Traverse, Flatten and Rebuild5 min
- 7Unstructured Data - URLs, Directory Tables and the REST API5 min
- 8Cortex AI Functions in Data Pipelines5 min
- 9Semantic Views, Semantic Analysis and Cortex Cost Control4 min
- 10Development Workflows, Workspaces and Notebooks4 min
- 11Git Integration, dbt Projects and Deployment Pipelines4 min
- 12Testing, Validation and Environment Management4 min
- 13Snowpark Architecture, Querying and Filtering4 min
- 14Snowpark Transformations and DataFrame Manipulation4 min
Ready for more practice?
The full Snowflake DEA-C02 question bank has 709 questions, with timed practice exams and an explanation for every answer.
This study guide is independent and is not affiliated with, endorsed by, or sponsored by Snowflake. Vendor names, certification names and exam codes are trademarks of their respective owners and are used for identification only.