AWS · DEA-C01
Validates ability to implement data pipelines and to monitor, troubleshoot, and optimize cost and performance issues in accordance with best practices.
Practice Questions
1,120
≈ 17 practice exams
Duration
130 minutes
Passing Score
720/1000
Difficulty
AssociateLast Updated
Jan 2026
Use this DEA-C01 practice exam to prepare for AWS Certified Data Engineer - Associate (DEA-C01) with realistic questions, detailed explanations, and focused study modes. The practice bank includes 1,120 questions for AWS DEA-C01, so you can review the exam steadily instead of relying on one long cram session.
As you practice, pay extra attention to recurring topics such as Data Ingestion and Transformation, Data Store Management, Data Operations and Support, and Data Security and Governance. Start with short sessions to identify weak areas, then move into timed quizzes once your accuracy is consistent.
The explanations are especially useful when you want to connect exam wording to the responsibilities and scenarios described in the official certification guidance. Use the free preview first, then unlock the full question bank when you are ready to build a complete study routine.
The AWS Certified Data Engineer – Associate (DEA-C01) is an associate-level credential that validates a practitioner's ability to implement, monitor, and optimize data pipelines on AWS. Launched in 2023, it is the first AWS certification designed specifically for data engineers, replacing the need to cobble credentials from Solutions Architect or Data Analytics Specialty exams. The exam assesses proficiency across the full data engineering lifecycle: ingesting and transforming data, selecting and managing appropriate data stores, orchestrating pipelines using programming concepts, and enforcing data security and governance policies using AWS-native tooling.
Key AWS services in scope include Amazon S3, AWS Glue, Amazon Redshift, Amazon Kinesis, Amazon EMR, AWS Lake Formation, Amazon DynamoDB, AWS Database Migration Service, and Amazon Athena, among others. Candidates are evaluated on their ability to compare cost and performance trade-offs between services, apply SQL on AWS platforms, implement encryption and access controls, and validate data quality and consistency. Out-of-scope topics include ML model training and inference, programming-language-specific syntax, and deriving business conclusions from data analysis.
The target candidate is a data engineer or data architect with roughly 2–3 years of experience in data engineering and at least 1–2 years of hands-on AWS experience. This includes professionals who design and maintain ETL/ELT pipelines, manage data lakes and warehouses, or work with real-time streaming architectures. Adjacent roles transitioning into cloud data engineering — such as database administrators, backend developers, or traditional ETL developers — will also find this certification a clear roadmap for bridging legacy skills with AWS-native approaches.
The exam suits those who regularly work with concepts such as volume, variety, and velocity of data; data modeling and schema design; data lifecycle management; and cloud security and governance. It is not aimed at data scientists, ML engineers, or business analysts, as those domains fall outside the exam's scope.
AWS does not enforce formal prerequisites for the DEA-C01, but the official exam guide recommends 2–3 years of data engineering or data architecture experience and 1–2 years of hands-on work with AWS services. Candidates should be comfortable setting up and maintaining ETL pipelines from ingestion to destination, writing and executing SQL queries, using Git-based source control workflows, and applying language-agnostic programming concepts (loops, conditionals, data structures).
On the AWS side, recommended knowledge includes familiarity with data pipeline orchestration services (AWS Glue, AWS Step Functions), storage systems (Amazon S3, Amazon Redshift, Amazon DynamoDB), streaming platforms (Amazon Kinesis), and security/governance services (AWS IAM, AWS KMS, AWS Lake Formation). Understanding of data lakes, networking fundamentals (VPC, subnets, connectivity), compute options (Amazon EMR, AWS Lambda), and vector/embedding concepts is also beneficial. While no prior AWS certification is required, having the AWS Cloud Practitioner or AWS Solutions Architect – Associate background provides a useful foundation.
The DEA-C01 exam consists of 65 total questions: 50 scored questions that contribute to the final result and 15 unscored pilot questions that AWS uses to evaluate future content. Unscored questions are not identified, so candidates should treat all questions equally. Question types are multiple choice (one correct answer from four options) and multiple response (two or more correct answers from five or more options). The time limit is 130 minutes, and the exam is delivered via Pearson VUE at a testing center or through an online proctored session. The exam is available in English, Japanese, Korean, and Simplified Chinese, and costs $150 USD.
Scores are reported on a scaled range of 100–1,000, and the minimum passing score is 720. AWS uses a compensatory scoring model, meaning candidates do not need to achieve a passing threshold in each individual domain — only the overall scaled score matters. Unanswered questions are treated as incorrect; there is no penalty for guessing. The certification is valid for three years, after which recertification requires passing the current version of the exam.
The DEA-C01 certification targets one of the fastest-growing roles in cloud computing. AWS-certified data engineers in the US report average salaries around $141,000 per year according to Glassdoor data, with entry-level positions starting near $124,000–$130,000 and senior roles exceeding $175,000. Research from the Jefferson Frank Careers and Hiring Guide found that 73% of AWS professionals saw a salary increase after certification, averaging approximately 27%. Job roles accessible with this credential include Data Engineer, Cloud Data Architect, ETL/ELT Developer, Data Platform Engineer, and Analytics Engineer.
AWS certifications appear in cloud job postings more than any other vendor credential, and the DEA-C01 specifically validates the services — Glue, Redshift, Kinesis, S3 — that dominate real-world data engineering job requirements. For professionals transitioning from database administration, backend development, or traditional ETL roles, the certification provides a structured path into cloud-native data engineering. Many candidates report role transitions or salary increases within 3–6 months of earning the credential. Pairing DEA-C01 with the Databricks Data Engineer Associate certification is widely considered the most job-market-relevant two-certification combination in the data engineering space.
5 sample questions with answers and explanations. The full bank has 1,120 questions, enough for 17 full-length practice exams.
Preview — answers shown1. Litware runs a complex weekly analytics workload on Amazon Redshift requiring launching a cluster, processing and loading data to S3, and terminating the cluster. The company wants to minimize operational overhead while automating all tasks. Which solution offers the least overhead?
Explanation
Amazon Redshift Serverless automatically provisions, scales, and releases compute resources in response to workload demand. The weekly analytics job can be initiated directly without managing cluster lifecycle; Redshift Serverless spins up capacity when a query arrives and winds down after the workload completes. This eliminates the need to script cluster creation, configuration, and termination, and charges apply only for the compute time consumed during active processing. Amazon Redshift Spectrum is an extension to a provisioned Redshift cluster that queries S3 external tables; it requires an existing running cluster and cannot operate independently, so the cluster lifecycle management burden remains. Amazon Athena is serverless for SQL queries against S3 data but does not provide the full data warehousing capabilities of Redshift for complex analytical workloads requiring sorted columnar storage, distribution keys, and Redshift-specific optimizations. Apache Oozie on EC2 requires provisioning EC2 instances, installing and configuring the Oozie workflow scheduler and its Hadoop dependencies, and managing the underlying infrastructure, which represents the highest operational overhead of all options.
2. Contoso Healthcare processes patient lab results from 50 hospital systems. Each system delivers CSV files to Amazon S3 every hour with slightly different column naming conventions. The data engineer must build a pipeline that automatically detects schema changes, normalizes column names, and loads results into a curated data lake layer. Which solution handles schema changes with the LEAST manual intervention? (Select one!)
Explanation
A Glue workflow combining a crawler with an ETL job provides automated schema detection and transformation. The crawler automatically detects schema changes from new hospital files and updates the Glue Data Catalog accordingly. The subsequent Glue ETL job uses ApplyMapping to normalize varying column names into a standardized schema. S3 event notifications trigger the workflow automatically upon file arrival. Data Firehose with Lambda has a 6 MB payload limit and does not provide schema detection capabilities. Athena CTAS requires predefined schemas and cannot automatically detect schema changes. EMR with Hive requires manual SerDe configuration for each hospital system and significant operational overhead.
3. A data engineer at Litware Inc. manages an AWS Glue ETL job that processes data from a JDBC source (Amazon RDS PostgreSQL). The job runs every hour and must process only the rows that have been inserted or updated since the last run. The source table has an auto-incrementing ID column and an updated_at timestamp column. Which approach ensures the job processes only new and changed data efficiently? (Select one!)
Explanation
Glue job bookmarks track the last processed data position for JDBC sources using bookmark key columns. The updated_at timestamp column is ideal as a bookmark key because it captures both new inserts and updates. The bookmark key must be monotonically increasing, which a timestamp column satisfies. The job.init() and job.commit() calls are required to initialize and save bookmark state. CRAWL_EVENT_MODE uses S3 event notifications, not JDBC change detection. Storing timestamps in DynamoDB with pushdown predicates works but requires custom state management code, adding operational overhead that bookmarks handle natively. Reading the entire table and filtering in the job wastes compute resources and increases costs.
4. Litware Financial runs an Amazon Redshift provisioned cluster with RA3 nodes for their data warehouse. The analytics team needs to enable real-time dashboards that display stock trading data arriving through an Amazon Kinesis Data Stream, replacing their current pipeline that stages data in S3 before loading with COPY commands. Which approach eliminates the S3 staging requirement with the LEAST operational overhead? (Select one!)
Explanation
Redshift streaming ingestion allows creating materialized views that read directly from Kinesis Data Streams or Amazon MSK topics without any intermediate S3 staging. The materialized view is refreshed to pull new data, providing near real-time analytics with minimal operational overhead. Redshift Spectrum queries external data in S3, not streaming sources directly. Lambda inserting individual records into Redshift is operationally complex and not designed for high-throughput ingestion. Amazon Data Firehose with a Redshift destination actually stages data in S3 first and then uses COPY commands internally, which does not eliminate the S3 staging requirement.
5. A data engineer at Tailspin Analytics needs to create a Step Functions workflow that processes 50,000 CSV files stored in an Amazon S3 bucket. Each file must be processed by an AWS Lambda function independently. The workflow must complete within 2 hours and track the processing status of each file. Which Step Functions configuration should be used? (Select one!)
Explanation
The Distributed Map state is designed for large-scale parallel processing, supporting up to 10,000 concurrent child executions and reading input directly from S3 inventory or object lists. It can process 50,000 files by running multiple batches of up to 10,000 parallel executions, tracking the status of each file independently. The Inline Map state is limited to 40 concurrent iterations, making it unsuitable for 50,000 files. The Parallel state requires statically defined branches at design time, making 50,000 branches impractical and exceeding state machine definition limits. Nested Express workflows within a Standard workflow adds complexity, and Express workflows have a 5-minute maximum duration which may not be sufficient for Lambda processing of individual files, plus managing 50,000 nested executions creates significant orchestration overhead.
AWS Certified AI Practitioner (AIF-C01)
AIF-C01 · 426 questions
AWS Certified Cloud Practitioner (CLF-C02)
CLF-C02 · 600 questions
AWS Certified CloudOps Engineer - Associate (SOA-C03)
SOA-C03 · 2141 questions
AWS Certified Developer - Associate (DVA-C02)
DVA-C02 · 536 questions
AWS Certified DevOps Engineer - Professional (DOP-C02)
DOP-C02 · 436 questions
AWS Certified Generative AI Developer - Professional (AIP-C01)
AIP-C01 · 1978 questions
$17.99
One-time access to this exam