DEA-C02 Data Transformation Practice Question
Which Snowflake feature is best suited for transforming data that is already loaded and requires periodic, complex SQL transformations without managing manual scheduling or streams?
⚠ Common exam trap
Candidates often default to Tasks and Streams for simple pipelines. They miss that Dynamic Tables are specifically designed to abstract away the scheduling and incremental logic entirely.
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
✓
Dynamic Tables
Dynamic Tables provide a declarative approach to data transformation. Users define the query that represents the transformation, and Snowflake manages the refresh frequency, dependencies, and incremental updates automatically. This reduces the administrative burden compared to managing manual Tasks and Streams. It is the modern standard for building ELT pipelines where the user describes the desired state, and the system ensures the target reflects the source over time.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Materialized Views
Why it's wrong here
Materialized views are optimized for query performance on a single table. They do not support complex transformations like multi-table joins, window functions, or non-deterministic functions, which are often required for general data transformation pipelines. They are not suitable for generic ELT pipelines where complex logic is needed.
- ✓
Dynamic Tables
Why this is correct
Dynamic tables allow for complex transformations involving joins, aggregations, and window functions. They automatically handle the incremental refresh logic, removing the need for manual task orchestration and stream tracking, making them the ideal choice for declarative data transformation pipelines within the Snowflake ecosystem.
- ✗
Stored Procedures
Why it's wrong here
Stored procedures are imperative and require manual triggering via tasks or external schedulers. While flexible, they do not inherently handle incremental logic or refresh state management. Building a robust transformation pipeline with stored procedures requires significant coding effort to track processed data and manage failures effectively.
- ✗
External Tables
Why it's wrong here
External tables are used for querying data stored in cloud storage without loading it into Snowflake. They are not intended for performing transformations on data that has already been loaded into internal tables. Their performance is generally lower than native tables for complex analytical transformations.
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.