An overview of what this certification covers
The SnowPro Advanced: Data Engineer (DEA-C02) exam validates advanced knowledge and skills used to apply comprehensive data engineering principles on the Snowflake AI Data Cloud. The exam tests the candidate's ability to design and operate data movement pipelines (batch and continuous ingestion via stages, Snowpipe, Snowpipe Streaming, Streams, Tasks, Dynamic Tables, and connectors), build data transformations (UDFs, UDTFs, UDAFs, stored procedures, Snowpark for Python/Java/Scala, Snowflake Cortex, Snowflake Notebooks, and Git-integrated dbt Projects), optimize performance and cost (warehouse sizing, micro-partition pruning, clustering, caching, Materialized Views, Search Optimization Service, Query Acceleration Service, resource monitors), administer storage and data protection (Time Travel, Fail-safe, zero-copy cloning, cross-region and cross-cloud replication), and apply data governance controls (object tagging, classifications, lineage, Dynamic Data Masking, row access policies, projection policies, Data Clean Rooms, and Horizon Catalog).
What to expect on exam day
Note: Exam specifications, pricing, and validity are subject to change. Always verify the most up-to-date information on the official provider's page before scheduling your exam.
Everything you need to pass
Sign in to unlock more questions and features
Get all 0 questions, simulator and saved questions.
0 chapters · 0 sections
The SnowPro Advanced - Data Engineer (DEA-C02) exam contains 65 questions and lasts 115 minutes. Always confirm the latest exam blueprint on the official page before scheduling.
The passing score is 750 / 1000 on a scaled scoring system out of 1000.
You get 115 minutes to complete the exam. The MyCertStack exam simulator uses the same time budget so you can build pacing under realistic pressure.
The official exam fee is $375 USD at the time of writing. Pricing can vary by region and is set by Snowflake — always confirm on the official page.
The certification is valid for 2 years from the date you pass. After that, you'll need to recertify to keep your credential current.
No. MyCertStack provides original practice questions, sample exam questions, and a realistic exam simulator written by our team to mirror the style and difficulty of the real exam. They are not dumps and are not the actual questions used by Snowflake.
Work through the structured study material chapter by chapter, then drill the practice zone for each topic until you consistently score above the passing threshold. Finish with at least two full exam simulations under timed conditions before sitting the real exam.