DEA-C02 Snowflake · Snowflake Data Engineer

DEA-C02 practice test

SnowPro Advanced: Data Engineer. A full-length practice exam for SnowPro Advanced: Data Engineer DEA-C02: 65 questions in 115 minutes across all five domains, including multiple-select questions, code and exhibits, weighted like the real exam.

  • 2 practice tests + challenge test
  • 180 questions
  • 65 questions, 115 min per test
  • Pass at 70%

Take the free DEA-C02 diagnostic10 questions, no card needed

Free DEA-C02 sample questions

3 questions from the free diagnostic, with answers and explanations.

Question 1 · Data Movement

Snowflake recommends a size range for data files loaded in bulk or by Snowpipe, so that loads run in parallel efficiently. What is that range?

  1. About 100–250 MB compressed
  2. About 1–5 MB uncompressed
  3. Exactly 1 GB per file, uncompressed
  4. Any size, as long as each file has under 1,000 rows
Show answer

Answer: A (About 100–250 MB compressed)

Files of roughly 100–250 MB compressed balance parallelism against per-file overhead; very small files add overhead and very large ones limit parallelism.

Question 2 · Data Movement

A pipe with AUTO_INGEST = TRUE loads files from an S3 bucket. What notifies Snowflake that a new file has arrived?

  1. S3 event notifications sent to the pipe's SQS queue
  2. A task that lists the stage every minute
  3. The warehouse named in the pipe definition
  4. A COPY command the client runs after uploading
Show answer

Answer: A (S3 event notifications sent to the pipe's SQS queue)

Auto-ingest relies on cloud event notifications (S3 to SQS, Event Grid on Azure, Pub/Sub on Google Cloud); the pipe uses serverless compute, not a warehouse.

Question 3 · Performance Optimization

A dashboard runs the same aggregate over a large, rarely changing table many times an hour, with different users and roles. Which feature avoids recomputing the aggregate each time, even when the result cache cannot be used?

  1. A materialized view
  2. The search optimization service
  3. A larger warehouse with the same SQL
  4. A multi-cluster warehouse in maximized mode
Show answer

Answer: A (A materialized view)

A materialized view stores the precomputed result and Snowflake keeps it current in the background; search optimization targets selective point lookups instead.

Try the full diagnostic free

What the DEA-C02 practice covers

Share of practice questions per skill area.

  • Data Movement26%
  • Data Transformation25%
  • Performance Optimization21%
  • Storage and Data Protection14%
  • Data Governance14%

Question formats

  • Single choice
  • Multiple select
  • Exhibits (screenshots, diagrams and code)

Career path: Snowflake Data Engineer

Build and run data pipelines on Snowflake: loading and Snowpipe, streams, tasks and dynamic tables, Snowpark and UDFs, performance tuning, recovery and data governance.

  1. COF-C03
  2. DEA-C02

DEA-C02 practice test FAQ

Is there a free DEA-C02 practice test?

Yes. Create a free account and take the DEA-C02 free diagnostic: 10 questions across every skill area of the exam, with a study plan for the topics to work on. You can retake it as often as you like.

How many questions are in each ExamKite DEA-C02 practice test?

Each full practice test has 65 questions with a 115-minute timer, and you pass at 70%. There are 2 practice tests plus a harder challenge test, with 180 questions in total.

Which question formats does the DEA-C02 practice include?

Single choice, multiple select and exhibits (screenshots, diagrams and code), the same formats you meet on the real exam.

Are these real DEA-C02 exam questions?

No. They are original questions written for ExamKite and mapped to the official Snowflake exam guide, never copied from the real exam. Using leaked exam questions breaks the certification provider's exam rules and can get your certification revoked.

More answers in the full FAQ.

Ready to practice for DEA-C02?

Start with the free diagnostic and get a study plan for the topics you miss.

Create a free account