DEA-C01 cheat sheet

Exam at a glance

Domain weightings

How much of the exam each domain covers. Spend your study time in proportion — the heavier the domain, the more questions you'll see.

Key terms

AWS Glue

AWS Glue is a serverless data-integration service for discovering, cataloging, transforming, and moving data. DEA-C01 relies heavily on Glue ETL jobs, crawlers, and the Glue Data Catalog across ingestion and governance.

Glue Data Catalog

The AWS Glue Data Catalog is a central metadata repository that stores table definitions and schema for data in S3 and other stores. DEA-C01 covers it as the catalog that Athena, Redshift Spectrum, and Lake Formation query against.

Amazon Kinesis

Amazon Kinesis is a family of services for real-time streaming data, including Data Streams and Data Firehose. DEA-C01 covers Kinesis for ingesting and delivering streaming data into stores like S3 and Redshift.

Amazon MSK

Amazon Managed Streaming for Apache Kafka (MSK) is a managed Kafka service for building streaming data pipelines. DEA-C01 covers MSK alongside Kinesis as an ingestion option for high-throughput event streams.

Amazon Redshift

Amazon Redshift is AWS's petabyte-scale cloud data warehouse for analytics using SQL. DEA-C01 covers Redshift for data warehousing, schema and distribution design, and querying S3 data via Redshift Spectrum.

Amazon Athena

Amazon Athena is a serverless interactive query service that runs SQL directly against data in S3 using the Glue Data Catalog. DEA-C01 covers Athena for ad-hoc analysis of data-lake data without provisioning infrastructure.

Data Lake

A data lake is a centralized repository, typically on Amazon S3, that stores structured and unstructured data at any scale for analytics. DEA-C01 covers building and governing data lakes with S3, the Glue Data Catalog, and Lake Formation.

AWS Lake Formation

AWS Lake Formation is a service that simplifies building and securing data lakes with fine-grained, centrally managed permissions. DEA-C01 covers it for governance and column/row-level access control over cataloged data.

Partitioning

Partitioning is organizing data-lake files into folders by key (such as date) so queries scan less data and run faster and cheaper. DEA-C01 covers partitioning strategies for S3 data queried by Athena and Redshift Spectrum.

Parquet

Apache Parquet is a columnar storage file format that compresses well and speeds up analytic queries by reading only needed columns. DEA-C01 covers choosing columnar formats like Parquet and ORC over row formats for analytics.

AWS DMS

AWS Database Migration Service (DMS) is a service that replicates and migrates data between databases, including ongoing change data capture. DEA-C01 covers DMS as an ingestion path for bringing relational data into data lakes and warehouses.

Step Functions

AWS Step Functions is a serverless orchestration service that coordinates multiple AWS services into workflows using state machines. DEA-C01 covers it for orchestrating and error-handling multi-step data pipelines.