Snowflake · DEA-C02
SnowPro Advanced: Data Engineer (DEA-C02) Practice Tests
Validates advanced expertise in designing, building, optimizing, and managing complex data pipelines within the Snowflake platform. Covers data movement, transformation, performance optimization, storage, and data governance at a production-level depth.
Exam Details
Practice Questions
597
≈ 5 practice exams
Duration
115 minutes
Passing Score
750/1000
Difficulty
ProfessionalLast Updated
Jun 2026
Topics Covered
Data MovementData TransformationPerformance OptimizationStorage & Data ProtectionData GovernanceSnowpark & UDFsContinuous Data Pipelines
SnowPro Advanced: Data Engineer (DEA-C02) Practice Exam Preparation
Use this DEA-C02 practice exam to prepare for SnowPro Advanced: Data Engineer (DEA-C02) with realistic questions, detailed explanations, and focused study modes. The practice bank includes 597 questions for Snowflake DEA-C02, so you can review the exam steadily instead of relying on one long cram session.
As you practice, pay extra attention to recurring topics such as Data Movement, Data Transformation, Performance Optimization, Storage & Data Protection, and Data Governance. Start with short sessions to identify weak areas, then move into timed quizzes once your accuracy is consistent.
The explanations are especially useful when you want to connect exam wording to the responsibilities and scenarios described in the official certification guidance. Use the free preview first, then unlock the full question bank when you are ready to build a complete study routine.
Exam Domain Breakdown
Data Movement26%
Data Transformation25%
Performance Optimization21%
Storage and Data Protection14%
Data Governance14%
Exam Overview
The SnowPro Advanced: Data Engineer (DEA-C02) is Snowflake's role-based advanced certification that validates production-level expertise in designing, building, optimizing, and managing complex data engineering workflows on the Snowflake platform. Released on February 18, 2025 as the successor to DEA-C01, this exam tests a candidate's ability to source data from data lakes, APIs, and on-premises systems; build near real-time streaming pipelines; execute ELT/ETL transformations at scale; and apply advanced performance tuning across Snowflake's compute and storage architecture. The 2025 revision places greater emphasis on streaming technologies, automation, data observability, and multi-cloud interoperability compared to its predecessor.
The certification spans five weighted content domains: Data Movement (26%), Data Transformation (25%), Performance Optimization (21%), Storage and Data Protection (14%), and Data Governance (14%). It covers advanced Snowflake-native capabilities including Snowpark for Python/Java/Scala-based transformations, User-Defined Functions (UDFs) and UDTFs, continuous data pipelines using Streams and Tasks, dynamic data masking, row-level security policies, and Snowflake's data sharing and replication features. Achieving this credential demonstrates that a practitioner can operate confidently in enterprise-grade production environments.
Who Should Take This Exam
This certification is designed for experienced data engineers who work with Snowflake in production environments and wish to formally validate their advanced expertise. The ideal candidate has at least two years of hands-on Snowflake data engineering experience and is comfortable designing end-to-end pipelines, troubleshooting performance bottlenecks, and implementing governance frameworks at scale.
Relevant job titles include Data Engineer, Senior Data Engineer, Cloud Data Engineer, Data Platform Engineer, and Cloud Data Architect. Professionals working in data-intensive industries such as financial services, retail, healthcare, media, and technology who are responsible for building and maintaining Snowflake-based data infrastructure will find this credential directly applicable to their day-to-day work.
Prerequisites
Snowflake does not list any hard prerequisites that must be completed before registering for DEA-C02, but strongly recommends holding an active SnowPro Core certification (COF-C02) as a foundational baseline. The SnowPro Core validates general Snowflake platform knowledge, and candidates who lack it will likely find the advanced-level content significantly more challenging.
Beyond the Core certification, Snowflake recommends a minimum of two years of hands-on, production-level experience in a data engineering role using Snowflake. Candidates should be proficient in SQL and at least one of Python, Java, or Scala for Snowpark-based transformations, and should have practical experience with cloud platforms (AWS, Azure, or GCP), data ingestion tools such as Snowpipe, and Snowflake's native pipeline constructs including Streams, Tasks, and Dynamic Tables.
Exam Format
The DEA-C02 exam consists of 65 scored questions delivered in 115 minutes, yielding a time allocation of approximately 1 minute 46 seconds per question. Question types include multiple choice (single correct answer), multiple select (two or more correct answers), and interactive question types such as drag-and-drop and matching scenarios that simulate real-world data engineering decisions. There is no announced beta or unscored survey question pool; Snowflake states that results are available immediately upon exam completion.
The exam is delivered online via remote proctoring through Pearson VUE, or at an authorized Pearson VUE testing center. The cost is $375 USD per attempt (approximately $300 USD in India with a regional discount). Scoring uses a scaled score from 100 to 1000, with a passing threshold of 750. Candidates who do not pass must wait a minimum of seven days before retaking the exam. The certification is valid for two years, after which holders can renew via the dedicated recertification exam (DEA-R02).
Skills Measured
- 1.Data Movement (26%): Covers ingestion patterns including bulk loading with COPY INTO, continuous micro-batch ingestion via Snowpipe, Kafka connector configurations, external stages (S3, Azure Blob, GCS), and change data capture (CDC) strategies. Also includes data replication across accounts and regions using Snowflake Replication and Failover Groups.
- 2.Data Transformation (25%): Validates the ability to design and implement ELT pipelines using SQL and Snowpark (Python, Java, Scala), write and deploy User-Defined Functions (UDFs) and User-Defined Table Functions (UDTFs), leverage Dynamic Tables for declarative pipeline definitions, and orchestrate transformations using Streams and Tasks, including DAG-based task graph management.
- 3.Performance Optimization (21%): Tests knowledge of virtual warehouse sizing and multi-cluster configurations, query profiling with the Query Profile UI and EXPLAIN plans, clustering keys and Automatic Clustering, result caching and query acceleration service, partition pruning strategies, and identifying and resolving performance anti-patterns such as data spilling and inefficient joins.
- 4.Storage and Data Protection (14%): Covers Snowflake's storage architecture including micro-partitions and columnar storage, Time Travel configuration and usage (up to 90 days for Enterprise+), Fail-Safe for disaster recovery, data cloning (zero-copy cloning), table and schema types (permanent, transient, temporary), and managing storage costs through lifecycle policies.
- 5.Data Governance (14%): Assesses implementation of column-level security via Dynamic Data Masking and External Tokenization, row-level security using Row Access Policies, object tagging and data classification, Snowflake Access History and Data Lineage for auditing, account usage and information schema views for governance reporting, and designing compliant data sharing arrangements using Secure Views and the Snowflake Marketplace.
Study Tips
- Enroll in the official DEA-C02 Study Guide on learn.snowflake.com (requires a free Snowflake Community account). This guide provides the complete domain-by-domain objectives, links to relevant Snowflake documentation pages, and curated video resources — it is the single most authoritative preparation resource.
- Take the official DEA-P02 practice exam available through the Snowflake learning portal. This Snowflake-authored practice test mirrors the format and difficulty of the real exam, including interactive question types, and is the most reliable signal of exam readiness.
- Build hands-on pipelines in a free Snowflake trial account focusing on the two highest-weighted domains (Data Movement and Data Transformation). Practice loading data with Snowpipe and the Kafka connector, then transform it using both SQL Tasks/Streams and Snowpark DataFrames in Python to internalize both approaches.
- Study the Query Profile tool deeply for the Performance Optimization domain. Run intentionally inefficient queries (missing clustering keys, large cross-joins, queries that spill to disk), capture the Query Profile output, and practice diagnosing the bottleneck — this mirrors the diagnostic scenarios the exam presents.
- Review Snowflake's governance features end-to-end by implementing a complete governance setup in your trial account: apply Dynamic Data Masking policies to PII columns, create a Row Access Policy, tag objects using object tagging, and query ACCOUNT_USAGE.ACCESS_HISTORY to verify audit trails. Hands-on configuration of these features is consistently tested.
- Read the official Snowflake documentation changelog and release notes for features introduced or updated in 2024–2025, particularly around Dynamic Tables, Apache Iceberg table support, and Snowpark Container Services. The DEA-C02 refresh specifically incorporates newer platform capabilities not covered in DEA-C01.
- After studying each domain, attempt targeted questions from the VMExam DEA-C02 question bank or similar third-party practice sets to identify weak areas. Cross-reference every incorrect answer against the official Snowflake documentation rather than relying solely on third-party explanations.
Career Benefits
Earning the DEA-C02 credential signals to employers that a candidate can independently own and operate complex, production-scale Snowflake data platforms — a skill set in high demand as enterprises increasingly consolidate their data infrastructure on cloud-native platforms. Certified Snowflake data engineers in the United States report average annual salaries of approximately $125,000, with the range spanning roughly $101,000 at the 25th percentile to $156,000 at the 75th percentile, and senior roles reaching $190,000 or more. Industry analyses suggest that Snowflake-specific certification correlates with 20–30% higher compensation compared to equivalent roles without platform credentials.
The DEA-C02 positions holders for senior individual contributor and lead engineer roles across finance, retail, healthcare, and technology sectors where Snowflake is a primary data platform. Compared to broader cloud certifications such as AWS Certified Data Engineer or Google Professional Data Engineer, the SnowPro Advanced: Data Engineer is narrower in scope but commands a premium in organizations already standardized on Snowflake. It complements rather than competes with cloud-provider certifications and is frequently listed alongside them in job postings for Senior Data Engineer, Cloud Data Architect, and Data Platform Lead roles.
Sample Questions
5 sample questions with answers and explanations. The full bank has 597 questions, enough for 5 full-length practice exams.
Preview — answers shown1. A data engineering team at Adatum Retail executes CREATE TABLE PRODUCTS_DEV CLONE PRODUCTS on a 500 GB production table at 9:00 AM. At 9:30 AM, a developer runs a DELETE statement that removes 10% of rows from PRODUCTS_DEV. Which two statements accurately describe the storage behavior resulting from this sequence of operations? (Select two!)
Multiple correct answersAAt clone creation time, Snowflake physically copies all 500 GB of micro-partition data from PRODUCTS to PRODUCTS_DEV, which is why the clone operation completes nearly instantly.
BAt clone creation time, no additional storage is charged because PRODUCTS_DEV shares the underlying micro-partitions of PRODUCTS through metadata references only.
CAfter the DELETE on PRODUCTS_DEV, new micro-partitions are created for the affected data using copy-on-write semantics, and storage is charged only for those newly written micro-partitions.
DDeleting rows from PRODUCTS_DEV also removes those rows from the original PRODUCTS table because both tables share the same physical micro-partitions at the time of deletion.
EZero-copy cloning is only supported for Snowflake tables smaller than 1 TB; the 500 GB PRODUCTS table qualifies, but larger tables require a CREATE TABLE AS SELECT approach instead.
Explanation
Zero-copy cloning creates a metadata-level snapshot of the source object instantly, regardless of its size. At clone creation time, PRODUCTS_DEV does not allocate any new physical storage — it references the same underlying micro-partitions as PRODUCTS through metadata pointers. No additional storage costs are incurred at this moment. When the developer deletes 10% of rows from PRODUCTS_DEV, Snowflake uses copy-on-write semantics: only the micro-partitions containing the deleted rows are materialized as new partitions in PRODUCTS_DEV. Storage is charged solely for those newly written micro-partitions. The original PRODUCTS table is completely unaffected because modifications to a clone never propagate back to the source — each object independently manages writes to its own new micro-partitions after divergence. Zero-copy cloning has no size restriction; databases, schemas, and tables of any size can be cloned, and the operation always completes in seconds regardless of data volume because no physical data movement occurs.
2. A data engineer at Litware ran a faulty UPDATE statement against a critical permanent production table six days ago, corrupting a large portion of the data. The table is configured with DATA_RETENTION_TIME_IN_DAYS = 1. The engineer has just discovered the issue and needs to recover the original pre-corruption data. Which statement correctly describes the available recovery options? (Select one!)
AThe engineer can use Time Travel with AT(OFFSET => -518400) to restore the table to its state from six days ago
BThe engineer can recover the data directly by using UNDROP TABLE to restore a Fail-safe version of the corrupted table
CThe data may still be recoverable by contacting Snowflake Support, as the table is likely within its Fail-safe retention period
DNo recovery is possible because Fail-safe only preserves data for dropped tables, not tables modified by DML statements
Explanation
With DATA_RETENTION_TIME_IN_DAYS = 1, the Time Travel window is only 24 hours. Since the corruption occurred six days ago, Time Travel is no longer available. However, Snowflake provides a 7-day Fail-safe period for permanent tables that begins immediately after the Time Travel period expires. The total recovery window is 1 day (Time Travel) + 7 days (Fail-safe) = 8 days. Since only six days have elapsed, the table is still within the Fail-safe window. Critically, customers cannot directly access or initiate Fail-safe recovery themselves — only Snowflake Support can attempt to recover data from Fail-safe storage. Opening a support case immediately is the correct action. Time Travel with AT(OFFSET) cannot look back six days when the retention period is only 1 day — historical micro-partition versions are no longer accessible through the Time Travel mechanism after expiration. UNDROP TABLE is a Time Travel operation that restores tables that have been dropped; it cannot recover data corrupted by a DML statement on a table that still exists. Fail-safe applies to all permanent table data, including versions created or modified by any DML operation such as UPDATE — it preserves micro-partition history regardless of the type of change that was made.
3. A data security team at Tailspin Ventures attaches a row access policy to the EMPLOYEE_COMP table. The policy is designed so that each department manager can only view records belonging to employees in their department, using a mapping table keyed on CURRENT_ROLE(). A database administrator who has no entry in the policy mapping table executes SELECT * FROM EMPLOYEE_COMP. What result does the administrator receive? (Select one!)
AA policy enforcement error is raised and the query fails to execute because the administrator lacks a mapping entry
BThe query returns only the row matching the administrator's own CURRENT_USER() employee record by default
CThe query returns an empty result set because the policy expression evaluates to FALSE for every row when no mapping entry exists
DThe query returns all rows because ACCOUNTADMIN and SYSADMIN roles automatically bypass all row access policies
Explanation
Row access policies in Snowflake work by evaluating a policy expression for each individual row. If the expression returns FALSE, that row is silently excluded from the query result. When a user's role has no entry in the policy's mapping table, the policy expression returns FALSE for every row, producing an empty result set rather than an error. Snowflake does not raise a permission error for row access policy filtering — the SQL query executes successfully and simply returns zero rows. No built-in Snowflake role, including SYSADMIN or ACCOUNTADMIN, automatically bypasses row access policies unless the policy body explicitly includes logic granting those roles full access. Returning only the user's own record would require the policy to be written with a CURRENT_USER() condition, which is not described in this scenario.
4. A data engineering team at Adatum has configured database replication from their primary Snowflake account in us-east-1 to a secondary account in eu-west-1 for disaster recovery. After the first complete replication run finishes without errors, a data engineer inspects the secondary account and reports that several object types present in the primary are absent from the secondary. Which three object types are NOT replicated by Snowflake database replication? (Select three!)
Multiple correct answersAMaterialized views
BTemporary tables
CExternal tables
DDynamic tables
EStreams
FTemporary stages
Explanation
Snowflake database replication explicitly excludes several object types. Temporary tables are session-scoped objects that exist only for the duration of the user session that created them; they have no persistent existence beyond their originating session and are therefore not candidates for cross-account replication. External tables are excluded because the underlying data resides in external cloud storage (S3, GCS, or Azure Blob Storage) outside Snowflake's control; the table metadata references an external stage, but the actual data files and their access relationships cannot be assumed identical or accessible in the secondary account. Temporary stages are similarly excluded due to their transient, session-associated nature. Materialized views, dynamic tables, and streams are all included in Snowflake's database replication scope. When a replication group is refreshed, these object types are propagated to the secondary account along with their definitions, enabling the secondary account to serve as a functional replica of the primary for disaster recovery and failover purposes.
5. A data engineer at Contoso accidentally executes DELETE FROM INVOICE_RECORDS WHERE INVOICE_STATUS = 'DRAFT' on the production table at 10:15 AM UTC, removing 92,000 invoice records. New invoices with INVOICE_STATUS = 'SUBMITTED' were inserted into the table between 10:15 AM and 10:45 AM. The INVOICE_RECORDS table has DATA_RETENTION_TIME_IN_DAYS set to 7. The engineer needs to restore only the deleted DRAFT records while preserving all rows inserted after 10:15 AM. Which two approaches correctly restore the deleted records without causing additional data loss? (Select two!)
Multiple correct answersARun UNDROP TABLE INVOICE_RECORDS to immediately restore the full table to its state before the DELETE statement was executed
BQuery the table using the Time Travel BEFORE clause at a timestamp prior to 10:15 AM and INSERT only the DRAFT status rows back into the current INVOICE_RECORDS production table
CCreate a cloned table from INVOICE_RECORDS at a historical timestamp before 10:15 AM using Time Travel, then INSERT only the DRAFT records from the clone into the production table
DUse the FAIL-SAFE recovery window to directly query deleted rows via standard SQL SELECT statements and re-insert them
ESet DATA_RETENTION_TIME_IN_DAYS = 0 on INVOICE_RECORDS to reset the retention pointer and trigger automatic restoration of deleted rows
Explanation
Querying the historical version of INVOICE_RECORDS using the Time Travel BEFORE clause at a timestamp prior to 10:15 AM returns all rows that existed at that point, including the 92,000 deleted DRAFT records. The engineer can then filter for INVOICE_STATUS = 'DRAFT' and INSERT those rows back into the current production table, restoring only the deleted data without disturbing any records inserted after 10:15 AM. Creating a Time Travel clone achieves the same outcome from the other direction — CLONE INVOICE_RECORDS AT (TIMESTAMP => ...) creates an independent, queryable snapshot of the table at that historical moment, from which the DRAFT records can be selectively extracted and re-inserted into production. UNDROP TABLE is used to recover a table that has been dropped entirely; it is not applicable when only rows were deleted by a DML statement. Even if applicable, UNDROP restores the entire table to a previous state and would eliminate all 10:15 to 10:45 AM inserts, creating further data loss. FAIL-SAFE is a Snowflake-managed 7-day backup layer for disaster recovery scenarios; it cannot be accessed via SQL and is available only through Snowflake Support. Setting DATA_RETENTION_TIME_IN_DAYS to 0 immediately purges all existing Time Travel history, eliminating any chance of recovery rather than restoring deleted rows.
More Snowflake Practice Exams
SnowPro Advanced: Administrator (ADA-C02)
ADA-C02 · 600 questions
SnowPro Advanced: Architect (ARA-C01)
ARA-C01 · 592 questions
SnowPro Advanced: Data Analyst (DAA-C01)
DAA-C01 · 600 questions
SnowPro® Advanced: Data Scientist (DSA-C03)
DSA-C03 · 600 questions
SnowPro Advanced: Security Engineer (SEA-C01)
SEA-C01 · 550 questions
SnowPro Core Certification (COF-C03)
COF-C03 · 592 questions
$17.99
One-time access to this exam
597 questions (5 practice exams' worth)
Unlimited timed exam simulations
Yours forever — no subscription
Detailed explanations
Free preview stays available