Free Amazon Data-Engineer-Associate Exam Questions
Absolute Free Data-Engineer-Associate Exam Practice for Comprehensive Preparation
-
Amazon Data-Engineer-Associate Exam Questions
-
Provided By: Amazon
- Exam: AWS Certified Data Engineer Associate (DEA-C01)
- Certification: AWS Certified Associate
-
Total Questions: 582
-
Updated On: Sep 25, 2026
-
Rated: 4.9 |
-
Online Users: 1164
-
Question 1
-
Files from multiple data sources arrive in an Amazon S3 bucket on a regular basis. A data engineer wants to ingest new files into Amazon Redshift in near real time when the new files arrive in the S3 bucket. Which solution will meet these requirements?
Answer: D
-
-
Question 2
-
As a data engineering consultant, you've been approached by a client who's experiencing difficulties with their Amazon DynamoDB setup. They've noticed that their query performance degrades as their dataset grows, despite having a primary key design that they believed would be optimal. They ask for your advice on how they can maintain consistent, fast query performance as their dataset scales.
Which of the following suggestions would be the most effective for maintaining query performance in DynamoDB at scale?
Answer: C
-
As a data engineering consultant, you've been approached by a client who's experiencing difficulties with their Amazon DynamoDB setup. They've noticed that their query performance degrades as their dataset grows, despite having a primary key design that they believed would be optimal. They ask for your advice on how they can maintain consistent, fast query performance as their dataset scales.
-
Question 3
-
A company has completed a full database load to their S3 data lake and is now using AWS Database Migration Service (DMS) to stream ongoing change data capture (CDC) updates. They need an effective method to apply these CDC updates, including deletes and upserts, to their structured data in S3.
What is the most efficient and transactionally consistent approach for applying these updates?
Answer: D
-
A company has completed a full database load to their S3 data lake and is now using AWS Database Migration Service (DMS) to stream ongoing change data capture (CDC) updates. They need an effective method to apply these CDC updates, including deletes and upserts, to their structured data in S3.
-
Question 4
-
A global enterprise is using Amazon RDS for its production environment. The Chief Information Security Officer (CISO) mandates a solution to ensure the ability to perform security analysis and audit database activity, including tracking which user performed which action on the database. The company requires that the solution should also track API calls made to the Amazon RDS service, even if they do not directly modify the database.
Which AWS service should the company use to meet these requirements?
Answer: D
-
A global enterprise is using Amazon RDS for its production environment. The Chief Information Security Officer (CISO) mandates a solution to ensure the ability to perform security analysis and audit database activity, including tracking which user performed which action on the database. The company requires that the solution should also track API calls made to the Amazon RDS service, even if they do not directly modify the database.
-
Question 5
-
A data engineer wants to orchestrate a set of extract, transform, and load (ETL) jobs that run on AWS. The
ETL jobs contain tasks that must run Apache Spark jobs on Amazon EMR, make API calls to Salesforce, and
load data into Amazon Redshift.
The ETL jobs need to handle failures and retries automatically. The data engineer needs to use Python to
orchestrate the jobs.
Which service will meet these requirements?
Answer: A
-