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: Jul 22, 2026
-
Rated: 4.9 |
-
Online Users: 1164
-
Question 1
-
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?
Answer: D
-
A company has a production AWS account that runs company workloads. The company's security team
-
Question 2
-
As a Cloud Data Engineer, you have been tasked with optimizing an AWS Glue job that processes large datasets using Apache Spark. The job currently uses standard Spark DataFrames, but you are considering switching to AWS Glue DynamicFrames for better handling of schema variations and errors in the data.
Which of the following benefits is a primary advantage of using Glue DynamicFrames over standard Spark DataFrames in this scenario?
Answer: B
-
As a Cloud Data Engineer, you have been tasked with optimizing an AWS Glue job that processes large datasets using Apache Spark. The job currently uses standard Spark DataFrames, but you are considering switching to AWS Glue DynamicFrames for better handling of schema variations and errors in the data.
-
Question 3
-
An analytics team frequently runs complex Amazon Athena queries on a dataset stored in an Amazon S3 bucket, with AWS Glue Data Catalog serving as the metadata repository. They've identified a slowdown in Athena query plans and attribute it to the excessive number of S3 partitions. The team needs to enhance query performance and reduce the time Athena takes in query planning.
Which two measures should the team take to meet these performance goals? (Select TWO.)
Answer: B,E
-
An analytics team frequently runs complex Amazon Athena queries on a dataset stored in an Amazon S3 bucket, with AWS Glue Data Catalog serving as the metadata repository. They've identified a slowdown in Athena query plans and attribute it to the excessive number of S3 partitions. The team needs to enhance query performance and reduce the time Athena takes in query planning.
-
Question 4
-
A company uses Amazon Redshift as its data warehouse. Data encoding is applied to the existing tables of the
data warehouse. A data engineer discovers that the compression encoding applied to some of the tables is not
the best fit for the data.
The data engineer needs to improve the data encoding for the tables that have sub-optimal encoding.
Which solution will meet this requirement?
Answer: B
-
A company uses Amazon Redshift as its data warehouse. Data encoding is applied to the existing tables of the
-
Question 5
-
A data engineer needs to build an extract, transform, and load (ETL) job. The ETL job will process daily incoming .csv files that users upload to an Amazon S3 bucket. The size of each S3 object is less than 100 MB. Which solution will meet these requirements MOST cost-effectively?
Answer: D
-