EN简体繁體
Sign in
Home / AWS / DEA-C01
AWS · DEA-C01

DEA-C01 Exam Practice Questions

AWS Certified Data Engineer – Associate

DEA-C01 English PDF practice questions: 366 questions in source order, with options supported by the source format, answers and available explanations. Access covers this exam only. One-time payment; no automatic renewal.

Exam overview

For data engineers implementing ingestion, transformations, storage, operational pipelines and data governance.

Exam code
DEA-C01
Official exam / credential
AWS Certified Data Engineer – Associate
Exam format
Single-answer and multiple-response questions
Exam duration
130 minutes
Official exam questions
65 questions
Official exam languages
English, Japanese, Korean, Simplified Chinese

Official exam languages and practice-question file languages are listed separately. Confirm the exam version and available languages when booking with the provider.

Official sources: Provider reference
Information checked: 2026-10-20

Supported languages

  • English
  • Simplified Chinese
Try before you buy

First 20 practice questions

366 total questions

Questions follow the source order. Expand each answer to see its explanation.

Disclaimer: All questions on ExamPico are compiled from internet sources and are provided for study reference only.

Question 6

Question#6Topic1

A company created an extract, transform, and load (ETL) data pipeline in AWS Glue. A data engineer must crawl a table that is in Microsoft SQL Server. The data engineer needs to extract, transform, and load the output of the crawl to an Amazon S3 bucket. The data engineer also must orchestrate the data pipeline.
Which AWS service or feature will meet these requirements MOST cost-effectively?

  1. A. AWS Step Functions
  2. B. AWS Glue workflows
  3. C. AWS Glue Studio
  4. D. Amazon Managed Workflows for Apache Airflow (Amazon MWAA)
Show answer and explanation

Answer

B

Explanation

https://aws.amazon.com/blogs/big-data/orchestrate-an-etl-pipeline-using-aws-glue-workflows-triggers-and-crawlers-with-custom-classifiers/ https://aws.amazon.com/blogs/big-data/extracting-multidimensional-data-from-microsoft-sql-server-analysis-services-using-aws-glue/

Question 7

Question#7Topic1

A financial services company stores financial data in Amazon Redshift. A data engineer wants to run real-time queries on the financial data to support a web-based trading application. The data engineer wants to run the queries from within the trading application.
Which solution will meet these requirements with the LEAST operational overhead?

  1. A. Establish WebSocket connections to Amazon Redshift.
  2. B. Use the Amazon Redshift Data API.
  3. C. Set up Java Database Connectivity (JDBC) connections to Amazon Redshift.
  4. D. Store frequently accessed data in Amazon S3. Use Amazon S3 Select to run the queries.
Show answer and explanation

Answer

B

Explanation

The Amazon Redshift Data API is a lightweight, HTTPS-based API that provides an alternative to using JDBC or ODBC drivers for running queries against Amazon Redshift. It allows you to execute SQL queries directly from within your application without the need for managing connections or drivers. This reduces operational overhead as there's no need to manage and maintain WebSocket or JDBC connections.

Question 8

Question#8Topic1

A company uses Amazon Athena for one-time queries against data that is in Amazon S3. The company has several use cases. The company must implement permission controls to separate query processes and access to query history among users, teams, and applications that are in the same AWS account.
Which solution will meet these requirements?

  1. A. Create an S3 bucket for each use case. Create an S3 bucket policy that grants permissions to appropriate individual IAM users. Apply the S3 bucket policy to the S3 bucket.
  2. B. Create an Athena workgroup for each use case. Apply tags to the workgroup. Create an IAM policy that uses the tags to apply appropriate permissions to the workgroup.
  3. C. Create an IAM role for each use case. Assign appropriate permissions to the role for each use case. Associate the role with Athena.
  4. D. Create an AWS Glue Data Catalog resource policy that grants permissions to appropriate individual IAM users for each use case. Apply the resource policy to the specific tables that Athena uses.
Show answer and explanation

Answer

B

Explanation

https://docs.aws.amazon.com/athena/latest/ug/user-created-workgroups.html

Question 9

Question#9Topic1

A data engineer needs to schedule a workflow that runs a set of AWS Glue jobs every day. The data engineer does not require the Glue jobs to run or finish at a specific time.
Which solution will run the Glue jobs in the MOST cost-effective way?

  1. A. Choose the FLEX execution class in the Glue job properties.
  2. B. Use the Spot Instance type in Glue job properties.
  3. C. Choose the STANDARD execution class in the Glue job properties.
  4. D. Choose the latest version in the GlueVersion field in the Glue job properties.
Show answer

Answer

A

Question 10

Question#10Topic1

A data engineer needs to create an AWS Lambda function that converts the format of data from .csv to Apache Parquet. The Lambda function must run only if a user uploads a .csv file to an Amazon S3 bucket.
Which solution will meet these requirements with the LEAST operational overhead?

  1. A. Create an S3 event notification that has an event type of s3:ObjectCreated:*. Use a filter rule to generate notifications only when the suffix includes .csv. Set the Amazon Resource Name (ARN) of the Lambda function as the destination for the event notification.
  2. B. Create an S3 event notification that has an event type of s3:ObjectTagging:* for objects that have a tag set to .csv. Set the Amazon Resource Name (ARN) of the Lambda function as the destination for the event notification.
  3. C. Create an S3 event notification that has an event type of s3:*. Use a filter rule to generate notifications only when the suffix includes .csv. Set the Amazon Resource Name (ARN) of the Lambda function as the destination for the event notification.
  4. D. Create an S3 event notification that has an event type of s3:ObjectCreated:*. Use a filter rule to generate notifications only when the suffix includes .csv. Set an Amazon Simple Notification Service (Amazon SNS) topic as the destination for the event notification. Subscribe the Lambda function to the SNS topic.
Show answer and explanation

Answer

A

Explanation

"only if a user uploads data to an Amazon S3 bucket" that excludes B & C because we need s3:ObjectCreated:* You don't need SNS for S3 event notifications.

Downloads and personal use

  • Purchase this exam question set separately with 1, 3, 6 or 12 months of download access.
  • After payment confirmation, your library shows the download link and exact expiry time.
  • Download again during your term. Purchase a new term after expiry.
  • PDFs are licensed for personal study only and must not be resold or shared publicly.
  • Files already saved to your device are not remotely deleted when access expires.
How to choose your certification