DEA-C01 Retired: What Replaced It and What Carries Over

Historical DEA-C01 Scope

The SnowPro Advanced: Data Engineer certification exam, administered by Snowflake, is now retired and no longer available for scheduling. Its verified successor is DEA-C02. The linear exam format historically featured 65 questions, a duration of 115 minutes, and a passing score of 65. Candidates evaluated data engineering concepts across 5 distinct domains.

Who DEA-C01 Was For

Data engineers and advanced Snowflake professionals seeking to validate technical proficiency. Candidates should focus study efforts on the successor DEA-C02, as the current program requires transition planning.

Skills You Should Be Ready to Demonstrate

• Data Movement
• Performance Optimization
• Storage and Data Protection
• Security
• Data Governance and Privacy

How to Reuse Your Preparation

Do not attempt to schedule or study for the retired exam code, as it is retired. Focus all preparation efforts entirely on DEA-C02. Transfer your knowledge of bulk loading, continuous loading with Snowpipe, virtual warehouse performance tuning, and access control directly to your studies for the successor exam today.

Historical Domain Guide

Data Movement: Historical Scope

This domain covers standard data movement mechanisms in Snowflake, focusing heavily on bulk loading with COPY INTO, continuous loading using Snowpipe and Snowpipe Streaming, and integrating with external cloud storage stages securely.

• Configuring internal and external stages
• Implementing bulk and continuous loading strategies
• Handling data ingestion via Kafka and streaming

Performance Optimization: Historical Scope

This domain focuses intensely on optimizing query execution and warehouse performance through resource sizing, memory management, query acceleration, and effectively managing virtual warehouse queues to ensure optimal enterprise computing efficiency.

• Reducing warehouse query queues
• Resolving memory spillage issues
• Scaling virtual warehouse sizes

Storage and Data Protection: Historical Scope

This domain deals extensively with storage management and data protection features built into Snowflake, including time travel, failsafe capabilities, and handling external tables for modern cloud-based data lakes effectively.

• Managing storage metrics and usage
• Configuring data protection features
• Utilizing external tables for cloud storage

Security: Historical Scope

This domain addresses specific security principles within Snowflake, focusing deeply on access control hierarchies, user privileges, and object level security configurations required to protect sensitive corporate assets during standard operations.

• Configuring security access control privileges
• Managing table ownership and grants
• Securing database objects

Data Governance and Privacy: Historical Scope

This domain covers broad data governance and privacy practices, ensuring proper handling of data objects and strict compliance with organizational requirements and regulatory standards within the platform ecosystem.

• Implementing data governance policies
• Managing privacy standards
• Utilizing governance framework tools