Free Amazon Data-Engineer-Associate Practice Exam Questions 2026

Question 1

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?

A : Trigger AWS Lambda functions for each CDC update to apply changes to the S3 data.

B : Implement Amazon Redshift Spectrum to manage and apply CDC updates to the structured data in the S3 data lake

C : Use AWS Glue with custom ETL scripts to process and apply the CDC changes to the data in S3

D : Structure the data in Apache Iceberg format on S3 and use AWS Glue to apply CDC logic

Answer: D

Question 2

A Cloud Data Engineer is designing a serverless data processing pipeline on AWS. The pipeline uses AWS Lambda for data transformation, AWS Step Functions for workflow management, and Amazon DynamoDB for storing intermediate data. The engineer decides to use the AWS Serverless Application Model (AWS SAM) to manage the deployment of these components. The primary requirement is to ensure that the deployment process is repeatable and easily modifiable.

What should the engineer include in the SAM template to meet these requirements efficiently?

A : Include the Lambda functions and DynamoDB tables in the SAM template, but exclude the Step Functions, as they are not supported by AWS SAM.

B : Specify only the Lambda function in the SAM template, manually configuring the Step Functions and DynamoDB tables through the AWS Console.

C : Use separate SAM templates for each component (Lambda, Step Functions, DynamoDB) to manage deployments individually for better control.

D : Define all the components (Lambda functions, Step Functions, DynamoDB tables) in the SAM template, and use AWS CloudFormation to deploy the entire pipeline

Answer: D

Question 3

A company stores daily records of the financial performance of investment portfolios in .csv format in an

Amazon S3 bucket. A data engineer uses AWS Glue crawlers to crawl the S3 data.

The data engineer must make the S3 data accessible daily in the AWS Glue Data Catalog.

Which solution will meet these requirements?

A : Create an IAM role that includes the AmazonS3FullAccess policy. Associate the role with the crawler. Specify the S3 bucket path of the source data as the crawler-s data store. Create a daily schedule to run the crawler. Configure the output destination to a new path in the existing S3 bucket.

B : Create an IAM role that includes the AWSGlueServiceRole policy. Associate the role with the crawler. Specify the S3 bucket path of the source data as the crawler-s data store. Create a daily schedule to run the crawler. Specify a database name for the output.

C : Create an IAM role that includes the AmazonS3FullAccess policy. Associate the role with the crawler. Specify the S3 bucket path of the source data as the crawler-s data store. Allocate data processing units (DPUs) to run the crawler every day. Specify a database name for the output.

D : Create an IAM role that includes the AWSGlueServiceRole policy. Associate the role with the crawler. Specify the S3 bucket path of the source data as the crawler-s data store. Allocate data processing units (DPUs) to run the crawler every day. Configure the output destination to a new path in the existing S3 bucket.

Answer: B

Question 4

A telecommunications company collects network usage data throughout each day at a rate of several thousand

data points each second. The company runs an application to process the usage data in real time. The

company aggregates and stores the data in an Amazon Aurora DB instance.

Sudden drops in network usage usually indicate a network outage. The company must be able to identify

sudden drops in network usage so the company can take immediate remedial actions.

Which solution will meet this requirement with the LEAST latency?

A : Create an AWS Lambda function to query Aurora for drops in network usage. Use Amazon EventBridge to automatically invoke the Lambda function every minute.

B : Modify the processing application to publish the data to an Amazon Kinesis data stream. Create an Amazon Managed Service for Apache Flink (previously known as Amazon Kinesis Data Analytics) application to detect drops in network usage.

C : Replace the Aurora database with an Amazon DynamoDB table. Create an AWS Lambda function to query the DynamoDB table for drops in network usage every minute. Use DynamoDB Accelerator (DAX) between the processing application and DynamoDB table.

D : Create an AWS Lambda function within the Database Activity Streams feature of Aurora to detect drops in network usage.

Answer: B

Question 5

A company stores sensitive documents in an Amazon S3 bucket. They need to ensure that these documents can only be accessed by requests originating from a specific range of IP addresses within their corporate network. The company wants to enforce this policy at the bucket level.

Which approach should the company use to restrict access to the S3 bucket based on the originating IP address?

A : Apply an S3 bucket policy that includes a condition to allow access only from the specified IP address range.

B : Implement IAM user policies to restrict access to the S3 bucket based on the IP address.

C : Set up a Security Group attached to the S3 bucket to allow traffic only from the specified IP range.

D : Use a Network Access Control List (NACL) to restrict access to the S3 bucket for the specific IP range.

Answer: A

Free Amazon Data-Engineer-Associate Practice Exams Questions 2026 - TheExamsLabs