AWS Certified Data Engineer - Associate DEA-C01 Exam Questions and Answers (Page: 7)

QUESTION: 31

A company is building an analytics solution. The solution uses Amazon S3 for data lake storage and Amazon Redshift for a data warehouse. The company wants to use Amazon Redshift Spectrum to query the data that is in Amazon S3.
Which actions will provide the FASTEST queries? (Choose two.)

Use gzip compression to compress individual files to sizes that are between 1 GB and 5 GB.
Use a columnar storage file format.
Partition the data based on the most common query predicates.
Split the data into files that are less than 10 KB.
Use file formats that are not splittable.

Answer(s): B,C

Reveal Solution Next Question

QUESTION: 32

A company uses Amazon RDS to store transactional data. The company runs an RDS DB instance in a private subnet. A developer wrote an AWS Lambda function with default settings to insert, update, or delete data in the DB instance.
The developer needs to give the Lambda function the ability to connect to the DB instance privately without using the public internet.
Which combination of steps will meet this requirement with the LEAST operational overhead? (Choose two.)

Turn on the public access setting for the DB instance.
Update the security group of the DB instance to allow only Lambda function invocations on the database port.
Configure the Lambda function to run in the same subnet that the DB instance uses.
Attach the same security group to the Lambda function and the DB instance. Include a self-referencing rule that allows access through the database port.
Update the network ACL of the private subnet to include a self-referencing rule that allows access through the database port.

Answer(s): C,D

Reveal Solution Next Question

QUESTION: 33

A company has a frontend ReactJS website that uses Amazon API Gateway to invoke REST APIs. The APIs perform the functionality of the website. A data engineer needs to write a Python script that can be occasionally invoked through API Gateway. The code must return results to API Gateway.
Which solution will meet these requirements with the LEAST operational overhead?

Deploy a custom Python script on an Amazon Elastic Container Service (Amazon ECS) cluster.
Create an AWS Lambda Python function with provisioned concurrency.
Deploy a custom Python script that can integrate with API Gateway on Amazon Elastic Kubernetes Service (Amazon EKS).
Create an AWS Lambda function. Ensure that the function is warm by scheduling an Amazon EventBridge rule to invoke the Lambda function every 5 minutes by using mock events.

Answer(s): B

Reveal Solution Next Question

QUESTION: 34

A company has a production AWS account that runs company workloads. The company's security team created a security AWS account to store and analyze security logs from the production AWS account. The security logs in the production AWS account are stored in Amazon CloudWatch Logs.
The company needs to use Amazon Kinesis Data Streams to deliver the security logs to the security AWS account.
Which solution will meet these requirements?

Create a destination data stream in the production AWS account. In the security AWS account, create an IAM role that has cross-account permissions to Kinesis Data Streams in the production AWS account.
Create a destination data stream in the security AWS account. Create an IAM role and a trust policy to grant CloudWatch Logs the permission to put data into the stream. Create a subscription filter in the security AWS account.
Create a destination data stream in the production AWS account. In the production AWS account, create an IAM role that has cross-account permissions to Kinesis Data Streams in the security AWS account.
Create a destination data stream in the security AWS account. Create an IAM role and a trust policy to grant CloudWatch Logs the permission to put data into the stream. Create a subscription filter in the production AWS account.

Answer(s): D

Reveal Solution Next Question

QUESTION: 35

A company uses Amazon S3 to store semi-structured data in a transactional data lake. Some of the data files are small, but other data files are tens of terabytes.
A data engineer must perform a change data capture (CDC) operation to identify changed data from the data source. The data source sends a full snapshot as a JSON file every day and ingests the changed data into the data lake.
Which solution will capture the changed data MOST cost-effectively?

Create an AWS Lambda function to identify the changes between the previous data and the current data. Configure the Lambda function to ingest the changes into the data lake.
Ingest the data into Amazon RDS for MySQL. Use AWS Database Migration Service (AWS DMS) to write the changed data to the data lake.
Use an open source data lake format to merge the data source with the S3 data lake to insert the new data and update the existing data.
Ingest the data into an Amazon Aurora MySQL DB instance that runs Aurora Serverless. Use AWS Database Migration Service (AWS DMS) to write the changed data to the data lake.

Answer(s): C

Reveal Solution Next Question

Amazon AWS Certified Data Engineer - Associate DEA-C01 Exam (page: 7) Amazon AWS Certified Data Engineer - Associate DEA-C01 Updated on: 15-Feb-2026

QUESTION: 31

QUESTION: 32

QUESTION: 33

QUESTION: 34

QUESTION: 35

Amazon AWS Certified Data Engineer - Associate DEA-C01 Exam (page: 7)
Amazon AWS Certified Data Engineer - Associate DEA-C01
Updated on: 15-Feb-2026