AWS DEA-C01 Practice Exam
AWS Certified Data Engineer Associate DEA-C01
The AWS Certified Data Engineer - Associate certification validates the ability to build and operate data pipelines on AWS. The exam covers four domains: Data Ingestion and Transformation, Data Store Management, Data Operations and Support, and Data Security and Governance. It draws on services such as AWS Glue, Amazon Kinesis, Amazon S3, Amazon Redshift, Amazon Athena, Amazon EMR, AWS Lake Formation, Amazon DynamoDB, AWS Step Functions and Amazon MWAA. Candidates are tested on choosing and combining these services to ingest, transform, store and govern data at scale, rather than on writing application code. This certification suits data engineers with about a year of hands-on AWS experience.
887 questions in the bank
Question bank updated : questions, answers, explanations and chapters.
Certification Overview
- Exam name: DEA-C01
- Vendor: AWS
- Exam code: DEA-C01
- Duration: 130 minutes
- Total questions: about 65
- Official passing score: 720 on a scale of 100-1,000 (source)
- Our practice exam pass mark: 72%
Who Should Take This Exam?
Data Engineer, Analytics Engineer, ETL Developer, Data Platform Engineer, Data Architect, Business Intelligence Engineer, Backend Developer
Prerequisites
No prior certification is required. AWS recommends two to three years of data engineering experience and about one year of hands-on experience with AWS services.
Topics Covered
- Data Ingestion and Transformation
- Data Store Management
- Data Operations and Support
- Data Security and Governance
Question Types
- Multiple Choice (Single Answer)
- Multiple Choice (Multiple Answers)
DEA-C01 Practice Questions
Our question bank contains 887+ practice questions for this certification. Sample questions from each exam chapter. Expand a question to see the answer choices. With full access, you get unlimited practice exams with randomized questions from our full question bank.
Data Ingestion and Transformation
A startup ingests clickstream data continuously from a mobile application and needs a fully managed service that automatically buffers records and delivers them to Amazon S3 without the startup managing any shards. Which service should the startup use?
- A. Amazon Kinesis Data Streams
- B. Amazon Data Firehose Correct answer
- C. Amazon Managed Streaming for Apache Kafka
- D. AWS Database Migration Service
Amazon Data Firehose is correct because it is a fully managed delivery service that auto-scales, buffers, and writes streaming records to S3 with no shard management. Kinesis Data Streams is the distractor but requires the customer to provision and manage shards themselves.
A financial services firm needs to capture ongoing change data capture (CDC) updates from an on-premises relational database and replicate them into an Amazon S3 data lake. Which service should the firm use?
- A. Amazon Athena
- B. AWS Step Functions
- C. AWS Glue Crawler
- D. AWS Database Migration Service Correct answer
AWS Database Migration Service is correct because its ongoing replication mode captures change data capture (CDC) events from a source relational database and streams them continuously into targets like S3. Glue Crawler only catalogs existing data and does not capture live database changes.
A retail platform needs to load a one-time historical export of ten years of sales records from a file share into Amazon S3. What is this type of ingestion called?
- A. Micro-batch replication
- B. Batch ingestion Correct answer
- C. Stream ingestion
- D. Change data capture
Batch ingestion is correct because it describes moving a large, static, one-time dataset (a decade of historical records) into storage as a single job. Stream ingestion and CDC both describe continuous, ongoing data movement, which does not apply to a one-time historical export.
In Amazon Kinesis Data Streams, what is the basic unit of throughput and read/write capacity called?
- A. Partition
- B. Broker
- C. Segment
- D. Shard Correct answer
A shard is correct because it is Kinesis Data Streams' base unit of capacity, each providing a fixed read and write throughput (1 MB/s in, 2 MB/s out). Broker is Kafka terminology, and partition/segment are not the throughput unit used in Kinesis Data Streams.
Which TWO AWS services can automatically start an AWS Glue ETL job running? (Choose two)
- A. AWS Certificate Manager
- B. Amazon EventBridge Correct answer
- C. AWS Glue triggers Correct answer
- D. Amazon Cognito
- E. Amazon Route 53
Amazon EventBridge (via event rules) and AWS Glue triggers can both automatically start a Glue ETL job. Certificate Manager, Cognito, and Route 53 are unrelated services with no ability to start a Glue job.
Data Store Management
Which AWS Glue component scans a data source and automatically populates table definitions in the AWS Glue Data Catalog?
- A. Glue workflow
- B. Glue trigger
- C. Glue job
- D. Glue crawler Correct answer
The Glue crawler is correct because it connects to a data source, infers schema, and writes table definitions into the Glue Data Catalog automatically. A Glue job runs transformation logic but does not perform schema discovery, which is the crawler's specific role.
Which compression codec is splittable and commonly paired with Parquet files in Amazon EMR and AWS Glue jobs to allow parallel processing?
- A. A single unsplit Gzip file
- B. ZIP
- C. Uncompressed BMP
- D. Snappy Correct answer
Snappy is correct because it is a splittable compression codec commonly paired with Parquet in EMR and Glue, allowing multiple workers to read separate blocks of the same file in parallel. An unsplit Gzip file cannot be divided across workers, forcing single-threaded reads.
A company needs a fully managed key-value data store for a shopping cart application that requires single-digit millisecond read and write latency at any scale. Which AWS service should the company use?
- A. Amazon RDS for MySQL
- B. Amazon EFS
- C. Amazon Redshift
- D. Amazon DynamoDB Correct answer
DynamoDB is correct: it is a fully managed key-value/document store built for single-digit millisecond latency at virtually any scale, matching a shopping cart's needs. RDS for MySQL is relational and does not offer that latency guarantee at scale without significant tuning.
Which AWS service acts as a central metadata repository that stores table definitions so that Athena and Redshift Spectrum can query data in Amazon S3?
- A. Amazon Inspector
- B. Amazon CloudWatch Logs
- C. AWS Config
- D. AWS Glue Data Catalog Correct answer
AWS Glue Data Catalog is correct: it is the persistent metadata store that holds table/schema definitions Athena and Redshift Spectrum query against. CloudWatch Logs only stores log data and has no concept of table schemas for S3 data.
An analytics team wants to reduce both the amount of data scanned and the dollar cost of recurring Athena queries against a multi-terabyte dataset stored as uncompressed CSV in S3. Which TWO changes should the team make? (Choose two)
- A. Switch consumers to use the Redshift Data API
- B. Enable S3 Transfer Acceleration on the bucket
- C. Convert the data to a columnar format such as Parquet Correct answer
- D. Partition the data by a commonly filtered column Correct answer
- E. Increase the Athena workgroup's per-query scan limit
Converting uncompressed CSV to a columnar format like Parquet reduces bytes scanned per column read, and partitioning by a commonly filtered column lets Athena skip whole partitions, together cutting both scan volume and cost. The Redshift Data API, Transfer Acceleration, and a higher scan limit don't reduce what Athena itself scans.
Data Operations and Support
A financial services firm wants a visual, no-code interface for cleaning and normalizing raw datasets before loading them into a data lake. Which service should the firm use?
- A. AWS CloudFormation
- B. AWS Glue DataBrew Correct answer
- C. Amazon CloudWatch
- D. Amazon Quick Sight
AWS Glue DataBrew is correct because it provides a visual, no-code interface with over 250 built-in transformations for cleaning and normalizing data before it lands in a data lake. Quick Sight is a distractor since it is a BI visualization tool, not a data preparation service.
Which AWS service allows a data analyst to run standard SQL queries directly against data stored in Amazon S3 without provisioning any servers?
- A. Amazon Athena Correct answer
- B. AWS Glue Studio
- C. Amazon Redshift Serverless
- D. Amazon EMR Serverless
Amazon Athena runs standard SQL directly against S3 objects with no servers to provision, billing per query. Glue Studio builds ETL jobs rather than running ad hoc SQL, and Redshift Serverless/EMR Serverless still require loading or provisioning a compute engine before querying.
A company wants a fully managed service that collects the metrics an AWS Glue job publishes, such as job run status, so it can trigger an alarm when a job fails.
- A. Amazon CloudWatch Correct answer
- B. AWS Config
- C. AWS Trusted Advisor
- D. AWS CloudTrail
Amazon CloudWatch collects Glue job metrics like run status and duration and can trigger alarms on them. AWS Config tracks resource configuration compliance, Trusted Advisor gives account best-practice checks, and CloudTrail logs API calls; none of them collect job run metrics or fire alarms.
Which TWO AWS services let a user run SQL queries directly against data stored in Amazon S3? (Choose two)
- A. AWS Direct Connect
- B. Amazon WorkSpaces
- C. Redshift Spectrum Correct answer
- D. Amazon Athena Correct answer
- E. Amazon Kinesis Data Streams
Redshift Spectrum and Amazon Athena both let a user run SQL queries directly against data in S3 without loading it elsewhere. Direct Connect is network connectivity, WorkSpaces is virtual desktops, and Kinesis Data Streams is a streaming ingestion service, none of which run SQL over S3.
Which TWO AWS services help a team monitor the health and activity of a running data pipeline? (Choose two)
- A. Amazon CloudWatch Correct answer
- B. AWS CloudTrail Correct answer
- C. Amazon Route 53
- D. AWS Organizations
- E. AWS Direct Connect
Amazon CloudWatch monitors pipeline health/activity through metrics and alarms, while AWS CloudTrail records the API activity behind that pipeline, together covering health and activity. Route 53, Organizations, and Direct Connect don't monitor pipeline health or activity.
Data Security and Governance
Which AWS Lake Formation object grants a principal read access to specific columns of a table registered in the Glue Data Catalog?
- A. An S3 bucket policy
- B. A Glue job bookmark
- C. A VPC endpoint policy
- D. A Lake Formation data permission Correct answer
A Lake Formation data permission is correct: Lake Formation grants fine-grained, column-level read access to principals for tables registered in the Glue Data Catalog. An S3 bucket policy only controls access at the object/prefix level and cannot restrict individual columns.
Which AWS service records a history of API calls made against an account, such as who created or deleted an AWS Glue job, for auditing purposes?
- A. AWS Config
- B. Amazon CloudWatch Logs
- C. AWS Trusted Advisor
- D. AWS CloudTrail Correct answer
AWS CloudTrail records every API call, including who created or deleted a Glue job, for auditing. AWS Config tracks configuration state over time rather than the calling identity, CloudWatch Logs holds application/service logs, and Trusted Advisor only gives account recommendations.
Which AWS service centrally manages fine-grained permissions, including column-level access control, on databases and tables in the AWS Glue Data Catalog?
- A. AWS Identity and Access Management
- B. AWS Resource Access Manager
- C. AWS Organizations
- D. AWS Lake Formation Correct answer
AWS Lake Formation centrally manages fine-grained permissions, including column-level grants, on Glue Data Catalog tables. IAM controls access to AWS resources generally but not column-level table grants, Resource Access Manager shares resources across accounts, and Organizations manages account structure.
Which TWO AWS services help enforce data access permissions on tables in the AWS Glue Data Catalog? (Choose two)
- A. Amazon Cognito
- B. AWS Certificate Manager
- C. AWS Direct Connect
- D. AWS Identity and Access Management Correct answer
- E. AWS Lake Formation Correct answer
AWS IAM controls who can access Glue Data Catalog resources at the API/resource level, and AWS Lake Formation adds fine-grained, table/column-level permissions on top. Cognito, Certificate Manager, and Direct Connect don't enforce data access permissions on Data Catalog tables.
Which TWO of the following let an application obtain temporary AWS credentials instead of relying on long-term IAM access keys? (Choose two)
- A. An IAM role attached through an EC2 instance profile Correct answer
- B. A long-term IAM user access key pair
- C. A shared root account credential
- D. A hardcoded password in the application config
- E. AWS STS AssumeRole Correct answer
An EC2 instance profile attaches an IAM role to the instance, so the SDK/CLI automatically retrieves short-lived credentials from the instance metadata service; sts:AssumeRole similarly issues temporary, auto-expiring credentials. A user access key pair, root credentials, and hardcoded passwords are all long-term secrets that must be manually rotated and stored, the opposite of what's required.
Free Study Guide
Read the free AWS DEA-C01 study guide: every exam topic explained in plain English, with diagrams, exam tips and the mistakes to avoid.
More AWS Practice Exams
Practice with realistic mock exams to prepare for your AWS certification.