This guide is for candidates preparing for AWS Certified Data Engineer - Associate (DEA-C01) and for readers who need a sharper review of data lake, streaming, batch, orchestration, metadata, data quality, and governance patterns on AWS. The real exam is less about memorizing isolated services and more about implementing data platforms that stay durable, queryable, replayable, governed, observable, and cost-aware under production pressure.
Data lake: Centralized storage pattern that keeps raw and curated data available for many analytics tools and downstream consumers.
Orchestration: Coordinating multi-step pipeline tasks, dependencies, retries, and scheduling.
Backfill: Reprocessing historical data to load missing, corrected, or newly required records into a pipeline.
Current orientation
As of May 17, 2026, AWS positions DEA-C01 as an associate-level certification for candidates with the equivalent of 2-3 years of data engineering experience and at least 1-2 years of hands-on AWS work. AWS also expects the candidate to understand how volume, variety, and velocity affect ingestion, transformation, modeling, security, governance, privacy, schema design, and data-store selection.
The current exam validates whether you can implement data pipelines, monitor and troubleshoot them, and optimize cost and performance according to best practices. AWS lists 50 scored questions and 15 unscored questions, with 130 minutes and a reported passing score of 720.
AWS’s current exam guide breaks DEA-C01 into four weighted domains, and this online guide now follows that structure directly:
Official scope snapshot
| Official domain |
Weight |
What this guide emphasizes |
| 1. Data Ingestion and Transformation |
34% |
Batch and streaming ingestion, source triggers, ETL/ELT choices, file formats, orchestration, notifications, code performance, and IaC. |
| 2. Data Store Management |
26% |
Data-store fit, S3 data lakes, Redshift, DynamoDB, OpenSearch, catalogs, crawlers, metadata, lifecycle, schema evolution, and query optimization. |
| 3. Data Operations and Support |
22% |
Automation, APIs, SQL operations, analysis tools, monitoring, logging, troubleshooting, data quality, consistency, and skew. |
| 4. Data Security and Governance |
18% |
Authentication, secrets, network access, authorization, Lake Formation, encryption, masking, cross-account access, privacy, sovereignty, logging, and governance. |
AWS explicitly calls out ingestion and transformation, data-store choice, schema cataloging, lifecycle management, operational monitoring, data quality, authentication, authorization, encryption, privacy, governance, and logging. Keep the scope anchored there. ML training, model inference, language-specific programming syntax, and drawing business conclusions from data are outside the target candidate’s role.
Data pipeline operating loop
Most DEA-C01 scenarios can be placed in this loop.
flowchart LR
S["Source data: batch, stream, SaaS, database, files"] --> L["Durable landing and replay"]
L --> T["Transform, validate, and enrich"]
T --> C["Catalog metadata and schema"]
C --> Q["Serve query, analytics, ML, or downstream apps"]
Q --> O["Monitor cost, quality, latency, failures, and skew"]
O --> G["Govern access, retention, privacy, and lineage"]
G --> L
If an answer skips durable landing, replay becomes fragile. If it skips metadata, downstream discovery and governance break. If it skips monitoring, late data, skew, failed jobs, and cost regressions stay hidden.
What strong answers usually do
- land data durably first, then optimize transformation and serving layers around that landing pattern
- separate ingestion choice from storage choice and analytics choice instead of trying to solve everything with one service
- design for replay, late data, duplicates, schema drift, and monitoring rather than assuming the happy path
- treat governance as part of the platform design, not as an afterthought added after pipelines already exist
- choose data stores from access pattern, freshness, query shape, concurrency, governance, and cost rather than service familiarity
- keep data quality, schema evolution, and lineage visible enough for operations and audit
Use this exam guide in order
- Start with the study plan if you want a practical weekly sequence.
- Work through the four weighted domain chapters in order, starting with Data Ingestion and Transformation and Data Store Management.
- Use the cheat sheet for high-yield service pickers and trade-offs after you know the chapter logic.
- Use the cheat sheet when pipeline, governance, replay, and query-path decisions start to blur.
- Work through the sample questions to practice data-platform design prompts with full explanations.
- Keep the glossary open when lakehouse, streaming, and metadata terms begin to blur together.
- Use the FAQ to calibrate expected depth and exam fit.
- Keep the resources page nearby while you work through the official AWS exam guide and primary service docs.
Coverage map against the current exam guide
| Domain |
Weight |
What to study first |
| 1. Data Ingestion and Transformation |
34% |
1.1 Ingestion Patterns, Sources & Triggers, 1.2 Transformation Services, Formats & Processing Trade-Offs, 1.3 Orchestration, Workflows & Notifications, 1.4 Programming, IaC & Code Performance |
| 2. Data Store Management |
26% |
2.1 Choosing Data Stores for Access Patterns, 2.2 Catalogs, Crawlers & Metadata, 2.3 Data Lifecycle, Loads & Retention, 2.4 Data Models, Schema Evolution & Optimization |
| 3. Data Operations and Support |
22% |
3.1 Automation, Data APIs & Query Operations, 3.2 Analysis, Visualization & SQL Patterns, 3.3 Monitoring, Logging & Pipeline Troubleshooting, 3.4 Data Quality, Consistency & Skew |
| 4. Data Security and Governance |
18% |
4.1 Authentication, Secrets & Network Access, 4.2 Authorization, Least Privilege & Lake Formation, 4.3 Encryption, Masking & Cross-Account Protection, 4.4 Logging, Privacy, Sovereignty & Governance |
What the exam is really testing
| Scenario pressure |
Strong DEA-C01 reasoning |
| New data arrives late, duplicated, or out of order |
Design idempotent ingestion, durable landing, replay, watermarking or checkpoint logic, and downstream quality checks. |
| A pipeline must support both analytics and audit |
Keep raw and curated zones, catalog metadata, retention, lineage, access controls, and logs aligned. |
| Query performance is poor |
Check file format, partitioning, compression, table layout, statistics, distribution, indexes, workload management, and access pattern before changing the whole platform. |
| Schema changes break consumers |
Use schema evolution, catalog updates, compatibility checks, versioning, contracts, and controlled rollout. |
| Data quality regresses |
Add validation, anomaly checks, reconciliation, monitoring, alerts, quarantine paths, and ownership for failed records. |
| Data access crosses accounts or teams |
Use IAM, Lake Formation, resource policies, KMS, masking, tagging, sharing controls, and audit logs intentionally. |
Common DEA-C01 traps
| Trap |
Better exam posture |
| Treating ingestion, storage, and analytics as one decision |
Choose each layer separately, then check how they interact. |
| Skipping raw landing because transformation is the goal |
Land durably first when replay, audit, backfill, or recovery matters. |
| Choosing streaming because data is important |
Use streaming when freshness and event timing require it; use batch when latency tolerance and cost fit. |
| Fixing every query issue with more compute |
Check partitioning, file size, format, statistics, table design, and data skew first. |
| Adding governance after the lake is built |
Design catalog, permissions, encryption, retention, privacy, and logging into the platform from the start. |
| Treating “serverless” as automatically operational |
Serverless still needs retries, monitoring, quotas, cost controls, data quality checks, and failure handling. |
Review flow
flowchart LR
A["Study plan"] --> B["1. Ingestion and transformation"]
B --> C["2. Data stores and metadata"]
C --> D["3. Operations and support"]
D --> E["4. Security and governance"]
E --> F["Cheat sheet, glossary, and final review"]
In this section
-
Data Ingestion and Transformation
AWS DEA-C01 ingestion guide covering sources, transforms, orchestration, code patterns, and loading decisions.
-
Ingestion Patterns, Sources, and Triggers
DEA-C01 ingestion lesson for batch, streaming, CDC, API-driven, and event-triggered source patterns.
-
Transformation Services, Formats, and Processing Trade-Offs
DEA-C01 transformation lesson for Glue, EMR, Redshift, Lambda, file formats, partitioning, and scan efficiency.
-
Orchestration, Workflows, and Notifications
DEA-C01 orchestration lesson for Step Functions, MWAA, EventBridge, SQS, SNS, retries, and alerts.
-
Programming, IaC, and Code Performance
DEA-C01 coding lesson for SDK use, Lambda fit, Infrastructure as Code, CI/CD, packaging, and runtime performance.
-
Data Store Management
AWS DEA-C01 data store guide covering storage fit, catalogs, metadata, lifecycle, and schema decisions.
-
Choosing Data Stores for Access Patterns
DEA-C01 lesson on choosing S3, Redshift, RDS, Aurora, DynamoDB, OpenSearch, and vector-capable stores by access pattern.
-
Catalogs, Crawlers, and Metadata
DEA-C01 lesson on Glue Data Catalog, crawlers, Hive metastore, partitions, connections, and business cataloging.
-
Data Lifecycle, Loads, and Retention
DEA-C01 lesson on Redshift load/unload, S3 lifecycle policies, versioning, DynamoDB TTL, deletion, and resiliency.
-
Data Models, Schema Evolution, and Optimization
DEA-C01 lesson on Redshift, DynamoDB, Lake Formation schemas, schema conversion, lineage, indexing, partitioning, and vectors.
-
Data Operations and Support
AWS DEA-C01 operations guide covering automation, SQL patterns, monitoring, logging, and troubleshooting decisions.
-
Automation, Data APIs, and Query Operations
DEA-C01 lesson on automated data processing, managed workflows, SDK calls, data APIs, Lambda, EventBridge, and query operations.
-
Analysis, Visualization, and SQL Patterns
DEA-C01 lesson on Athena, Redshift, QuickSight, notebooks, serverless versus provisioned tradeoffs, and SQL analysis patterns.
-
Monitoring, Logging, and Pipeline Troubleshooting
DEA-C01 lesson on CloudWatch, CloudTrail, alerts, audit logs, troubleshooting, performance issues, and log analysis.
-
Data Quality, Consistency, and Skew
DEA-C01 lesson on data quality checks, rules, consistency, sampling, skew, duplicates, and trustworthy output.
-
Data Security and Governance
AWS DEA-C01 security guide covering authentication, authorization, masking, encryption, and governance decisions.
-
Authentication, Secrets, and Network Access
DEA-C01 lesson on IAM roles, credentials, Secrets Manager, Parameter Store, VPC endpoints, PrivateLink, and security groups.
-
Authorization, Least Privilege, and Lake Formation
DEA-C01 lesson on custom IAM policies, least privilege, Lake Formation, Redshift permissions, RBAC, ABAC, and tag-based access.
-
Encryption, Masking, and Cross-Account Protection
DEA-C01 lesson on KMS, encryption in transit, masking, anonymization, cross-account keys, and sensitive-data protection.
-
Logging, Privacy, Sovereignty, and Governance
DEA-C01 lesson on CloudTrail, CloudWatch Logs, CloudTrail Lake, Macie, AWS Config, sovereignty, privacy, and data sharing.
-
AWS DEA-C01 Study Plan: Ingestion, Catalogs, and Lakehouse in 30, 60, and 90 Days
AWS DEA-C01 30-, 60-, and 90-day study plan for ingestion, catalogs, lakehouse, review loops, and final-week priorities.
-
AWS DEA-C01 Cheat Sheet: Ingestion, Lakehouse, and Governance
AWS DEA-C01 cheat sheet for ingestion, transformation, lakehouse storage, catalogs, operations, security, governance, cost, and final review traps.
-
AWS DEA-C01 Sample Questions with Explanations
AWS DEA-C01 sample questions with explanations, traps, and topic labels.
-
AWS DEA-C01 FAQ: Exam Format, Topics, and Prep
AWS DEA-C01 FAQ for exam format, topics, prep strategy, practice, and common candidate traps.
-
AWS DEA-C01 Glossary: Lakehouse, Catalog, and Ingestion Terms
AWS DEA-C01 glossary of lakehouse, catalog, ingestion, transformation, and governance terms.