denis256 notes and projects

Previous: Series Introduction

Book: AWS Certified Data Engineer Associate Study Guide Authors: Sakti Mishra, Dylan Qu, Anusha Challa Publisher: O’Reilly Media ISBN: 978-1-098-17007-3

Chapter 1 is the warm-up. No heavy AWS services yet. It sets the stage: what the exam looks like, what topics it covers, and how to approach the questions. If you already know the exam structure, you can skim this. There are a few useful bits here worth your time though.

Who Is a Data Engineer?

The book describes data engineers as people who build the infrastructure behind data solutions. They design ETL pipelines, data warehouses, data lakes, and streaming systems. They’re the bridge between raw data and the people who actually use it: data scientists, analysts, ML engineers.

This is accurate. Data engineers are the plumbers of the data world. Nobody notices when things work. Everyone notices when they break.

AWS specifically offers a big set of services for data engineering work: Amazon EMR, AWS Glue, Amazon Redshift, Amazon Kinesis, and many more. The certification tests your ability to pick the right service for the right job.

Why Get the DEA-C01 Certification?

The book lists five reasons:

1. Practical knowledge. Studying for the exam forces you to learn AWS data services properly, not just the ones you use at work.
2. Career opportunities. Data engineering roles on AWS are in demand. The cert gives you proof of skill.
3. Best practices. The exam covers governance, security, compliance. You learn how AWS wants you to do things.
4. Community. Certified professionals get access to AWS events, forums, and networking.
5. AI-era relevance. Every AI model needs clean, structured data. Data engineers are the ones who deliver that.

Reasons 1 and 5 are the strongest in my opinion. The cert forces you to learn services you’d never touch in your daily job. The AI angle is real too. Behind every large language model is a massive data pipeline that someone had to build and maintain.

The Four Exam Domains

The exam is split into four domains with different weights:

Domain 1 is the biggest chunk. It covers data ingestion, transformation, pipeline orchestration, and programming concepts. If you’re weak here, you’ll struggle.

Domain 2 is about choosing the right data store, understanding data catalogs, managing data lifecycles, and handling schema evolution. Knowing when to use Redshift vs DynamoDB vs S3 is the core skill here.

Domain 3 focuses on analysis, automation, monitoring, and data quality. CloudWatch, Step Functions, data validation patterns.

Domain 4 covers authentication, authorization, encryption, masking, audit logs, and data privacy. It’s the smallest domain but don’t skip it. Security questions are everywhere in AWS exams.

Spend your study time proportional to these weights. Domain 1 deserves the most attention.

Exam Format

The facts:

• Level: Associate
• Questions: 65 total (50 scored, 15 unscored)
• Time: 130 minutes
• Cost: $150 USD
• Delivery: Pearson VUE testing center or online proctored
• Languages: English, Japanese, Korean, Simplified Chinese

Two types of questions show up:

Multiple choice has one correct answer out of four options. The distractors are designed to be plausible, especially if you only half-know the topic.

Multiple response has two or more correct answers out of five or more options. You need to select all correct answers.

No penalty for guessing. Never leave a question blank.

The 15 unscored questions are mixed in with the real ones. You can’t tell which ones they are. AWS uses them to test potential future exam questions. Just answer everything and move on.

130 minutes for 65 questions gives you exactly 2 minutes per question. That’s enough time if you know the material. If you’re spending 5 minutes on a single question, flag it and come back later.

Registering for the Exam

Straightforward process:

1. Go to aws.training
2. Click Certification, sign in with your AWS Builder ID
3. Choose Exam Registration, click “Schedule an exam”
4. Search for “AWS Certified Data Engineer – Associate” or code “DEA-C01”
5. Click Schedule and complete registration through Pearson VUE

Nothing complicated. Just make sure your ID matches exactly what you registered with. This trips people up on exam day.

Practice Questions and Resources

AWS provides a free practice question set on skillbuilder.aws. It has 20 questions that match the exam style and format. Each question comes with detailed explanations.

The book also includes practice questions at the end of each chapter and a full practice exam in Chapter 9. Use all of these. Reading the material isn’t enough. You need to practice answering questions under time pressure.

Think Like a Solutions Architect

This is the most useful part of Chapter 1. The authors present a six-step problem-solving framework that maps directly to how exam questions are structured:

1. Understand the use case. What problem needs solving? Real-time analytics? Migration? Security?
2. Gather current state and pain points. What exists today? What’s broken or insufficient?
3. Determine success criteria. What does “good” look like? Low cost? Low latency? High availability? The exam question will tell you which criteria matters most.
4. Consider context. What’s the team’s skill set? Do they prefer serverless? Are they a startup or an enterprise?
5. Explore possible solutions. Map AWS services to the requirements.
6. Evaluate trade-offs. Pick the solution that best matches the success criteria and context.

This framework is gold for exam questions. AWS certification questions are basically compressed customer scenarios. They give you a situation, constraints, and a success criterion, then ask you to pick the best answer.

Example: How the Framework Works

The book walks through a fintech fraud detection scenario. A company needs near-real-time fraud detection on millions of daily transactions. They want managed services and their team knows Spark.

Applying the framework: Kinesis for ingestion (managed, no cluster ops) plus Spark Structured Streaming on AWS Glue (serverless, team already knows Spark). This beats MSK (more ops overhead) and EMR (more management required).

The same scenario appears as a sample exam question. The key phrase in the question is “least operational overhead.” That phrase tells you to eliminate anything that requires you to manage infrastructure. Option D (Kinesis + Glue + Spark) wins because it’s fully managed and matches the team’s existing skills.

Most AWS exam questions work this way. There’s always a qualifying phrase that narrows down the correct answer. Look for words like “least cost,” “least operational overhead,” “most secure,” or “minimum downtime.” These phrases are your guide.

The Study Plan

The book suggests this approach:

1. Start with practice questions. See what the exam looks like before you study. This helps you know where to focus.
2. Read the study guide. Go through each chapter, complete the practice questions.
3. Get hands-on. Use AWS Builder Labs, AWS Cloud Quest (the data analytics track), or AWS Jam for practical experience.
4. Take the official practice exam. Available after you register for the real exam. Use it as your final readiness check.

I’d add one thing: set up a personal AWS account and build small pipelines yourself. Reading about Glue jobs is one thing. Actually writing one, debugging the errors, waiting for it to provision – that’s where real understanding happens. The free tier covers many data services. Use it.

My Thoughts on This Chapter

Chapter 1 is mostly orientation material. If you’ve taken any AWS certification before, a lot of this will feel familiar. The exam format, registration process, and general approach are similar across all associate-level certs.

The real value here is the Solutions Architect thinking framework. Too many people try to memorize AWS service names and features without understanding how to think through problems. The six-step framework gives you a systematic way to approach any question, even ones about services you haven’t studied in depth.

One more thing the book touches on that I agree with: the DEA-C01 is not just an architecture exam. It tests hands-on knowledge too. Expect questions about specific Glue configurations, Redshift tuning, Lake Formation permissions, and CLI usage. You can’t pass this exam with high-level knowledge alone.

Start with Chapter 1’s framework in your head. It will make every other chapter easier to absorb.

Next: Prerequisite Knowledge for Data Engineers