Free AWS Certified Data Engineer - Associate DEA-C01 Exam Questions and Answers

Last updated: September 11, 2026

Exam code

DEA-C01

Provider

Amazon

Questions in our bank

1000+

Free to read

First 10, with answers

Official page

Official Exam website

Our test mode duration & pass mark

130 mins · 70%

Recommended: Switch to Test Mode to start a practice test that simulates the real exam experience.

1. Question #1

   A data engineer maintains custom Python scripts that perform a data formatting process that many AWS Lambda functions use. When the data engineer needs to modify the Python scripts, the data engineer must manually update all the Lambda functions. The data engineer requires a less manual way to update the Lambda functions. Which solution will meet this requirement?

   • A. Store a pointer to the custom Python scripts in the execution context object in a shared Amazon S3 bucket.
   • B. Package the custom Python scripts into Lambda layer
   • C. Apply the Lambda layers to the Lambda functions.
   • D. Store a pointer to the custom Python scripts in environment variables in a shared Amazon S3 bucket.
   Reveal Answer

2. Question #2

   A company's data engineer needs to optimize the performance of table SQL queries. The company stores data in an Amazon Redshift cluster. The data engineer cannot increase the size of the cluster because of budget constraints. The company stores the data in multiple tables and loads the data by using the EVEN distribution style. Some tables are hundreds of gigabytes in size. Other tables are less than 10 MB in size. Which solution will meet these requirements?

   • A. Keep using the EVEN distribution style for all table
   • B. Specify primary and foreign keys for all tables.
   • C. Use the ALL distribution style for large table
   • D. Specify primary and foreign keys for all tables.
   Reveal Answer

3. Question #3

   A company needs to set up a data catalog and metadata management for data sources that run in the AWS Cloud. The company will use the data catalog to maintain the metadata of all the objects that are in a set of data stores. The data stores include structured sources such as Amazon RDS and Amazon Redshift. The data stores also include semistructured sources such as JSON files and .xml files that are stored in Amazon S3. The company needs a solution that will update the data catalog on a regular basis. The solution also must detect changes to the source metadata. Which solution will meet these requirements with the LEAST operational overhead?

   • A. Use Amazon Aurora as the data catalo
   • B. Create AWS Lambda functions that will connect to the data catalo
   • C. Configure the Lambda functions to gather the metadata information from multiple sources and to update the Aurora data catalo
   • D. Schedule the Lambda functions to run periodically.
   Reveal Answer

4. Question #4

   A security company stores IoT data that is in JSON format in an Amazon S3 bucket. The data structure can change when the company upgrades the IoT devices. The company wants to create a data catalog that includes the IoT data. The company's analytics department will use the data catalog to index the data. Which solution will meet these requirements MOST cost-effectively?

   • A. Create an AWS Glue Data Catalo
   • B. Configure an AWS Glue Schema Registr
   • C. Create a new AWS Glue workload to orchestrate the ingestion of the data that the analytics department will use into Amazon Redshift Serverless.
   • D. Create an Amazon Redshift provisioned cluste
   Reveal Answer

5. Question #5

   A company is migrating its database servers from Amazon EC2 instances that run Microsoft SQL Server to Amazon RDS for Microsoft SQL Server DB instances. The company's analytics team must export large data elements every day until the migration is complete. The data elements are the result of SQL joinsacross multiple tables. The data must be in Apache Parquet format. The analytics team must store the data in Amazon S3. Which solution will meet these requirements in the MOST operationally efficient way?

   • A. Create a view in the EC2 instance-based SQL Server databases that contains the required data element
   • B. Create an AWS Glue job that selects the data directly from the view and transfers the data in Parquet format to an S3 bucke
   • C. Schedule the AWS Glue job to run every day.
   • D. Schedule SQL Server Agent to run a daily SQL query that selects the desired data elements from the EC2 instance-based SQL Server database
   Reveal Answer

6. Question #6

   A company has used an Amazon Redshift table that is named Orders for 6 months. The company performs weekly updates and deletes on the table. The table has an interleaved sort key on a column that contains AWS Regions. The company wants to reclaim disk space so that the company will not run out of storage space. The company also wants to analyze the sort key column. Which Amazon Redshift command will meet these requirements?

   • A. VACUUM FULL Orders
   • B. VACUUM DELETE ONLY Orders
   • C. VACUUM REINDEX Orders
   • D. VACUUM SORT ONLY Orders
   Reveal Answer

7. Question #7

   A manufacturing company collects sensor data from its factory floor to monitor and enhance operational efficiency. The company uses Amazon Kinesis Data Streams to publish the data that the sensors collect to a data stream. Then Amazon Kinesis Data Firehose writes the data to an Amazon S3 bucket. The company needs to display a real-time view of operational efficiency on a large screen in the manufacturing facility. Which solution will meet these requirements with the LOWEST latency?

   • A. Use Amazon Managed Service for Apache Flink (previously known as Amazon Kinesis Data Analytics) to process the sensor dat
   • B. Use a connector for Apache Flink to write data to an Amazon Timestream databas
   • C. Use the Timestream database as a source to create a Grafana dashboard.
   • D. Configure the S3 bucket to send a notification to an AWS Lambda function when any new object is create
   Reveal Answer

8. Question #8

   A company uses an Amazon Redshift provisioned cluster as its database. The Redshift cluster has five reserved ra3.4xlarge nodes and uses key distribution. A data engineer notices that one of the nodes frequently has a CPU load over 90%. SQL Queries that run on the node are queued. The other four nodes usually have a CPU load under 15% during daily operations. The data engineer wants to maintain the current number of compute nodes. The data engineer also wants to balance the load more evenly across all five compute nodes. Which solution will meet these requirements?

   • A. Change the sort key to be the data column that is most often used in a WHERE clause of the SQL SELECT statement.
   • B. Change the distribution key to the table column that has the largest dimension.
   • C. Upgrade the reserved node from ra3.4xlarqe to ra3.16xlarqe.
   • D. Change the primary key to be the data column that is most often used in a WHERE clause of the SQL SELECT statement.
   Reveal Answer

9. Question #9

   A data engineer needs to use AWS Step Functions to design an orchestration workflow. The workflow must parallel process a large collection of data files and apply a specific transformation to each file. Which Step Functions state should the data engineer use to meet these requirements?

   • A. Parallel state
   • B. Choice state
   • C. Map state
   • D. Wait state
   Reveal Answer

10. Question #10

    A company wants to move its data warehouse to AWS. Which service should they consider?

    • A. Amazon Redshift
    • B. Amazon S3
    • C. Amazon DynamoDB
    • D. Amazon RDS
    Reveal Answer