DEA-C01 practice questions — AWS Certified Data Engineer

The exam

What DEA-C01 tests

DEA-C01 validates a candidate's ability to implement data pipelines and to monitor, troubleshoot, and optimize cost and performance issues in accordance with best practices — ingesting and transforming data and orchestrating pipelines, choosing data stores and designing schemas, operationalizing and monitoring pipelines while ensuring data quality, and implementing authentication, authorization, encryption, privacy, and governance.

Who it is for

Built for associate-level candidates

The target candidate has the equivalent of 2-3 years of experience in data engineering and at least 1-2 years of hands-on experience with AWS services. They understand the effects of volume, variety, and velocity on data ingestion, transformation, modeling, security, governance, privacy, schema design, and optimal data store design, and can structure and run SQL queries on AWS services. Performing ML training and inference, demonstrating programming-language-specific syntax, and drawing business conclusions from data are explicitly out of scope for this role.

What it covers

The official domains, weighted as the exam weights them.

Your readiness map in the app is organised the same way, so what you see here is exactly what you study against.

Data Ingestion and Transformation
34%
Data Store Management
26%
Data Operations and Support
22%
Data Security and Governance
18%

What Preppio gives you

Signal, not vibes.

1,766 questions

Across every domain above, in 5 formats: concept, scenario, ordering, multi-select, matching. Each one explains why the right answer is right and every distractor wrong.

A readiness map

Per domain, whether you are ready, weak, or not started — the same domains and weights as the exam itself.

Winston

Your study partner. He tracks where you are weak and drills exactly that, instead of serving you what you already know.

Try one

One of each format DEA-C01 uses, from the same bank.

Answer on the page. The explanation appears when you submit; use Next to move through the formats.

Sample 1 · Concept

A retail company ingests clickstream events from a mobile app through Amazon Kinesis Data Streams. A data engineer must replay the last 5 days of events into a new consumer application for backfill testing without affecting the existing production consumers. The stream currently uses the default retention setting. Which change will meet this requirement MOST cost-effectively?

Pick one, then submit.

Sample 2 · Scenario

A financial services company runs a nightly batch job that updates a Redshift dimension table. During the update, an analyst's long-running SELECT query on the same table is unexpectedly blocked, delaying downstream reports. A data engineer must determine why the query is blocked and prevent recurrence without changing the batch job's logic. What is the MOST likely cause and fix?

Pick one, then submit.

Sample 3 · Ordering

An Amazon MWAA environment runs a DAG that has begun failing intermittently at the task that loads data into Amazon Redshift, while upstream tasks consistently succeed. A data engineer must find the root cause with the LEAST operational overhead. Put the following diagnostic steps in the correct order.

Drag an item onto another to swap them, or use the arrows, then submit.

1Adjust the task's retry policy or connection configuration based on the identified root cause and redeploy the DAG
2Search the corresponding CloudWatch Logs group for the task using CloudWatch Logs Insights to correlate the error with Redshift-side throttling or connection events
3Open the MWAA environment's Airflow UI and identify the failed task instance for the specific DAG run
4View the task instance's log stream to capture the exact error message and stack trace at time of failure

Sample 4 · Multi-select

Select all that apply: A data engineer must let an on-premises ETL application invoke AWS Glue APIs over AWS Direct Connect without traversing the public internet, MOST cost-effectively, while ensuring the workflow continues to function if the VPC has no NAT gateway.

Select all that apply, then submit.

Sample 5 · Matching

Match each streaming source to the ingestion service that natively reads from it with the LEAST development effort:

Pick up a response below, then click a prompt to place it.

Response pool — click to pick up

1 of 5

Study links

Official material

Official Exam Guide (AWS)docs.aws.amazon.com AWS Certified Data Engineer – Associate (AWS)aws.amazon.com Exam Prep: AWS Certified Data Engineer - Associate (Skill Builder)skillbuilder.aws

FAQ

The things people ask about DEA-C01

How many questions are on the DEA-C01 exam, and how long is it?

65 questions in 130 minutes.

What score do you need to pass DEA-C01?

70%, a scaled score of 720.

What does DEA-C01 cover?

4 domains, weighted as the exam weights them: Data Ingestion and Transformation (34%), Data Store Management (26%), Data Operations and Support (22%) and Data Security and Governance (18%). Your readiness map in the app is organised by the same domains, so what you study against is what the exam tests.

What question formats does DEA-C01 use?

Five formats: concept, scenario, ordering, multi-select and matching. The practice questions use every one of them, and the sample on this page shows one of each.

Is DEA-C01 free on Preppio.ai?

DEA-C01 is on the Single, Dual and All Access plans. You start on the free tier and add it from the plan picker inside the app. Three fundamentals exams (AZ-900, CLF-C02 and CDL) are always free, and the sample on this page is free to try.

Where do the DEA-C01 practice questions come from?

Every question is generated from the exam's published objectives, then checked for accuracy, answer key and explanation before it is served. Nothing is copied from any exam, questions rotate by how often they have been seen, and they are retired when the objectives change.

DEA-C01AWS Certified Data Engineer - Associate