DEA-C02 Data Transformation Practice Question
Which Snowflake feature helps in managing data transformation pipelines by providing a visual and programmatic way to handle task dependencies and state management?
⚠ Common exam trap
Test-takers often confuse DAG tasks with simple streams or dynamic tables, missing the specific orchestration structure provided by parent-child task dependencies.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Tasks with dependencies (DAG)
A Directed Acyclic Graph (DAG) of tasks allows for complex, multi-step transformation sequences where each task can have dependencies on the success of prior tasks. This structure provides a clear, manageable workflow for production ELT. By centralizing the orchestration logic within Snowflake, engineers avoid the need for external workflow schedulers, simplifying the architecture and improving observability through standard Snowflake monitoring views and query history tools.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Streams
Why it's wrong here
Streams are for change tracking, not orchestration. They do not manage task dependencies or define the graph structure of a pipeline. While they are often used in conjunction with tasks, they are simply data objects that expose CDC information for consumption by other processes.
- ✗
Stored Procedures
Why it's wrong here
Stored procedures contain the logic to be executed, but they do not inherently manage the dependency graph or scheduling of tasks. While one could write complex logic within a procedure to call other procedures, it would lack the built-in observability and management of a native task-based DAG.
- ✓
Tasks with dependencies (DAG)
Why this is correct
Defining tasks with an 'AFTER' clause creates a DAG, allowing Snowflake to manage the execution order and dependencies automatically. This is the recommended approach for orchestrating complex transformation pipelines within the database, providing native support for success/failure triggers and clear visibility into the entire workflow.
- ✗
External Tables
Why it's wrong here
External tables are for reading data from cloud storage, not for managing transformation pipelines. They do not have any native capability to orchestrate tasks or manage dependencies between different transformation steps. They are purely storage-access abstractions rather than orchestration tools for ELT workflows.
About these practice questions
This DEA-C02 question is part of Courseiva's 229-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Snowflake exam blueprint
This DEA-C02 practice question is part of Courseiva's free Snowflake certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DEA-C02 exam.