Chapter 1 of 5 · Snowflake DEA-C02

Data Movement

Loading, file formats, stages, error troubleshooting, pipelines, Snowpipe, streaming and connectors.

  • 17topics
  • 1 h 27 minfast track
  • 6diagrams and exhibits
  • 28%of the exam

Topics in this chapter

Take them in order, or jump to the one you need.

  1. 1Loading Data - Methods, Considerations and Load FeaturesChoose how to load data into Snowflake: PUT and COPY, Snowpipe, file sizing, warehouse parallelism, load metadata and the impact…6 min
  2. 2File Formats, INFER_SCHEMA and Structured, Semi-Structured and Unstructured DataPick file format options, detect table design with INFER_SCHEMA and USING TEMPLATE, and ingest structured, semi-structured and…5 min
  3. 3Stages, Storage Integrations and EncryptionSet up internal and external stages, storage integrations and stage encryption, and learn scoped, file and pre-signed URLs for…Diagram5 min
  4. 4Compression, Parsing Strategies and Staged File MetadataHandle compression and CSV or JSON parsing options, and read staged file metadata with METADATA columns, LIST, directory tables…5 min
  5. 5Troubleshooting Data Ingestion - Causes and ResolutionsFind why a Snowflake load failed or loaded nothing using VALIDATE, COPY_HISTORY and pipe status, then fix it with the right…Diagram6 min
  6. 6Continuous Data Pipelines - Stages, Tasks and StreamsBuild continuous Snowflake pipelines with stages, streams for change capture, and tasks or task graphs, including triggered tasks…Diagram6 min
  7. 7Dynamic Tables and Materialized ViewsCompare dynamic tables, materialized views and streams with tasks: TARGET_LAG, refresh modes, DOWNSTREAM lag, materialized view…Diagram5 min
  8. 8Snowpipe, Snowpipe Streaming and the Kafka ConnectorCompare Snowpipe auto ingest and the REST API, Snowpipe Streaming channels and offset tokens, and the Kafka connector: latency…Diagram6 min
  9. 9UDFs, Snowflake Scripting and Notebooks for PipelinesPick between UDFs, stored procedures and Snowflake Scripting, and learn how Notebooks run procedure pipelines for data ingestion…5 min
  10. 10The Snowflake SQL API and OpenflowRun SQL over REST with the Snowflake SQL API, including async handles and result partitions, and learn what Openflow is and how…4 min
  11. 11Kafka, Spark, Python and Native ConnectorsChoose and configure the Snowflake connectors for Kafka, Spark and Python, understand their ingestion paths, and know what native…5 min
  12. 12Secure Data Sharing Versus CloningDecide between a data share and a clone, build a share with the right grants, and know reader accounts, consumer setup, costs and…Diagram5 min
  13. 13Marketplace, Listings and Auto-FulfillmentShare data through the Snowflake Marketplace and listings, and manage cross cloud auto-fulfillment: refresh options, size limit…4 min
  14. 14Views and Row-Level FilteringChoose between standard, secure and materialized views and filter rows per user with row access policies, mapping tables and…5 min
  15. 15Streamlit Apps for Data ConsumptionBuild Streamlit in Snowflake apps for interactive dashboards and self-service data access: runtimes, owner's rights, sharing…4 min
  16. 16External, Iceberg and Hybrid Tables with Horizon FederationCompare external, Iceberg and hybrid tables, pick catalogs and external volumes, and federate remote Iceberg catalogs with…5 min
  17. 17Table Management, Schema Evolution and UnloadingManage table types and data operations, enable schema evolution on load, and unload data with COPY INTO location, file size…6 min

About this chapter

What this chapter covers

Data Movement is the chapter on how data gets into Snowflake, how it flows between tables, and how it reaches consumers. For the SnowPro Advanced: Data Engineer DEA-C02 exam it tests decisions rather than definitions: which loading path, which option, which object, and why.

Questions are scenarios that start with "A Data Engineer needs to ...". They are single answer, multiple select or interactive, and the right answer usually hinges on one trade-off such as latency, cost, ordering or a default value.

How the topics fit together

Data travels a path, and each step has its own tools and failure modes.

Sourcefiles, rows, Kafkaland inStagesintegration and encryptionread withFile formatsparse and inferloaded byCOPY, Snowpipeor Snowpipe Streamingrefined byStreams, tasksdynamic tables, views
  • Loading choices cover methods, file sizing, load metadata and the options that change COPY behavior.
  • Formats and schema detection cover how files are parsed and how INFER_SCHEMA designs tables.
  • Stages, integrations and encryption control where files wait and how they are secured.
  • Troubleshooting covers reading errors and choosing the right ON_ERROR option.
  • Continuous pipelines combine streams, tasks, dynamic tables and materialized views.
  • Snowpipe and Snowpipe Streaming automate ingestion of files and rows, with the Kafka connector on top.
Exam tip

Learn the defaults and limits as a set. ON_ERROR is ABORT_STATEMENT for COPY and SKIP_FILE for Snowpipe, load metadata lasts 64 days for COPY and 14 days for pipes, and target lag has a 60 second minimum.

How to use these pages

Each topic page has the same shape, so you can skim for what you need.

  • What it is: the idea in plain words.
  • How it works: the mechanism, with diagrams, SQL and comparison tables.
  • Common mistakes: the classic traps.
  • What to remember for the exam: the facts to memorize.
  • Check yourself: three questions to test your understanding.

Read the pages in order the first time. Later pages on pipelines reuse the stages, file formats and COPY options from the earlier ones.

Ready for more practice?

The full Snowflake DEA-C02 question bank has 709 questions, with timed practice exams and an explanation for every answer.

This study guide is independent and is not affiliated with, endorsed by, or sponsored by Snowflake. Vendor names, certification names and exam codes are trademarks of their respective owners and are used for identification only.