Skip to Content
Cloud Engineering Academy

AWS Certified Data Engineer – Associate (DEA-C01)

The data pipeline exam. It covers ingesting, transforming, storing, operating and governing data on AWS.

DEA-C01

Verified against official sources on 2026-11-17.

AWS Certified Data Engineer – Associate (DEA-C01) checks that you can build data pipelines on AWS: ingest and transform data, choose and model data stores, run and monitor pipelines, check data quality, and secure and govern the data. Banking data pipelines (transactions, reconciliation, regulatory reporting) are one of your priorities, so this exam fits well.

At a glance

CodeDEA-C01
LevelAssociate
Intended audience2–3 years in data engineering, plus 1–2 years hands-on with AWS
Questions65 (50 scored + 15 unscored)
Time130 minutes
Passing score720 (scaled 100–1000)
PriceUSD 150
Question typesMultiple choice, multiple response
Valid for3 years. Renewed by passing AIP-C01, or with the paid Skill Builder maintain option
Out of scopeML training and inference, language-specific syntax, drawing business conclusions from data

Official domains and weightings

DomainWeight
1. Data Ingestion and Transformation34%
2. Data Store Management26%
3. Data Operations and Support22%
4. Data Security and Governance18%

Key AWS services tested

  • Ingestion: Kinesis Data Streams, Amazon Data Firehose, Amazon MSK, DMS (including change data capture), AWS Transfer Family, DataSync, AppFlow, EventBridge, S3 event notifications
  • Transformation and orchestration: AWS Glue (ETL jobs, crawlers, Data Catalog, job bookmarks, Glue Data Quality), Amazon EMR, Lambda, Step Functions, Amazon MWAA, Glue workflows
  • Storage and modelling: S3 (data lake zones, partitioning, lifecycle), Redshift (and Redshift Serverless, Spectrum, distribution and sort keys), DynamoDB, RDS and Aurora, Apache Iceberg tables, file formats (Parquet, ORC, Avro, CSV, JSON)
  • Analytics: Athena (partitions, partition projection, CTAS), QuickSight, OpenSearch Service
  • Security and governance: Lake Formation (column, row and tag-based access), IAM, KMS, Macie, CloudTrail, Secrets Manager, Glue Data Catalog permissions, data sharing

What you already know vs what you must learn

You already know (from .NET, SQL Server and banking)You must learn
T-SQL, joins, indexes, query plansColumnar formats and partitioning: why Parquet partitioned by date beats CSV for Athena and Redshift Spectrum
SSIS, SQL Agent jobs, batch file processingGlue ETL (PySpark basics), job bookmarks, crawlers, and orchestration with Step Functions or MWAA
SQL Server CDC and replicationDMS full load plus CDC, and Kinesis and Firehose for streaming
Row-level security in SQL ServerLake Formation permissions on S3 data, and LF-tags
Reconciliation and end-of-day batch windowsEvent-driven pipelines (S3 events to EventBridge to Step Functions), handling late-arriving data, idempotent reprocessing

Preparation order and study plan (about 50–60 hours over 5–7 weeks)

WeekFocusHours
1Exam guide. Module 07 data lake design (zones, formats, partitioning)8–10
2Glue (crawlers, ETL, bookmarks, Data Quality), Athena. Build the transaction pipeline project10–12
3Streaming: Kinesis, Firehose, MSK basics. DMS CDC from SQL Server8–10
4Redshift (Serverless, distribution and sort keys, Spectrum), DynamoDB patterns (Module 06)8
5Domain 4: Lake Formation, KMS, Macie, PII masking in the pipeline. Domain 3: monitoring8
6Free Exam Prep course, the 20-question set, this page's questions, a mock exam6–8

Mapped platform modules

Practical skills to build

  • Build the Module 07 banking pipeline: SFTP drop, raw S3 zone, a Glue job that validates and quarantines rows, partitioned Parquet output, Athena queries, and a daily reconciliation report
  • Add Glue Data Quality rules (for example, valid IBAN format, positive amounts, no duplicate transaction IDs)
  • Stream fictional card transactions through Kinesis to Firehose to S3 as Parquet
  • Restrict analysts from seeing PII columns with Lake Formation, and prove it with Athena
  • Compare scan cost for the same query on CSV and on partitioned Parquet

Exam-prep checklist

  • I can choose between Kinesis Data Streams, Firehose, MSK, SQS and DMS for a given ingestion scenario
  • I know Glue job bookmarks, crawlers, the Data Catalog and Glue Data Quality
  • I can explain partitioning, partition projection, compression and file sizing for Athena performance and cost
  • I know Redshift distribution styles, sort keys, Spectrum and data sharing at a high level
  • I can design S3 lifecycle rules for raw, curated and archive data
  • I can secure a data lake with Lake Formation (column, row and tag-based access) and KMS
  • I know how to orchestrate with Step Functions compared with MWAA, and how to retry and alert on failures
  • I can mask or tokenise PII inside a pipeline

Practice questions

These 5 questions are original, banking-flavoured scenarios. They aren't real exam questions.

Independent learning resource — not affiliated with, endorsed or sponsored by Amazon Web Services. AWS and related marks are trademarks of Amazon.com, Inc. or its affiliates. All banking data in examples is fictional. Sample architectures are for learning and are not automatically compliant with GDPR, PCI DSS or any banking regulation.

On this page