Free Amazon AWS-DEA-C01 Exam Questions
Try our Free Demo Practice Tests for Comprehensive AWS-DEA-C01 Exam Preparation
-
Amazon AWS-DEA-C01 Exam Questions
-
Provided By: Amazon
- Exam: AWS Certified Data Engineer - Associate
- Certification: AWS Certified Data Engineer
-
Total Questions: 582
-
Updated On: May 24, 2026
-
Rated: 4.9 |
-
Online Users: 1164
-
Question 1
-
A sales company uses AWS Glue ETL to collect, process, and ingest data into an Amazon S3 bucket. The
AWS Glue pipeline creates a new file in the S3 bucket every hour. File sizes vary from 200 KB to 300 KB.
The company wants to build a sales prediction model by using data from the previous 5 years. The historic
data includes 44,000 files.
The company builds a second AWS Glue ETL pipeline by using the smallest worker type. The second
pipeline retrieves the historic files from the S3 bucket and processes the files for downstream analysis. The
company notices significant performance issues with the second ETL pipeline.
The company needs to improve the performance of the second pipeline.
Which solution will meet this requirement MOST cost-effectively?
Answer: D
-
A sales company uses AWS Glue ETL to collect, process, and ingest data into an Amazon S3 bucket. The
AWS Glue pipeline creates a new file in the S3 bucket every hour. File sizes vary from 200 KB to 300 KB.
The company wants to build a sales prediction model by using data from the previous 5 years. The historic
data includes 44,000 files.
The company builds a second AWS Glue ETL pipeline by using the smallest worker type. The second
pipeline retrieves the historic files from the S3 bucket and processes the files for downstream analysis. The
company notices significant performance issues with the second ETL pipeline.
The company needs to improve the performance of the second pipeline.
Which solution will meet this requirement MOST cost-effectively?
-
Question 2
-
A company wants to migrate a data warehouse from Teradata to Amazon Redshift. Which solution will meet
this requirement with the LEAST operational effort?
Answer: B
-
A company wants to migrate a data warehouse from Teradata to Amazon Redshift. Which solution will meet
this requirement with the LEAST operational effort?
-
Question 3
-
A data engineer has two datasets that contain sales information for multiple cities and states. One dataset is
named reference, and the other dataset is named primary.
The data engineer needs a solution to determine whether a specific set of values in the city and state columns
of the primary dataset exactly match the same specific values in the reference dataset. The data engineer
wants to use Data Quality Definition Language (DQDL) rules in an AWS Glue Data Quality job.
Which rule will meet these requirements?
Answer: A
-
A data engineer has two datasets that contain sales information for multiple cities and states. One dataset is
named reference, and the other dataset is named primary.
The data engineer needs a solution to determine whether a specific set of values in the city and state columns
of the primary dataset exactly match the same specific values in the reference dataset. The data engineer
wants to use Data Quality Definition Language (DQDL) rules in an AWS Glue Data Quality job.
Which rule will meet these requirements?
-
Question 4
-
A telecommunications company collects network usage data throughout each day at a rate of several thousanddata points each second. The company runs an application to process the usage data in real time. Thecompany 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 identifysudden drops in network usage so the company can take immediate remedial actions.Which solution will meet this requirement with the LEAST latency?
Answer: B
-
A telecommunications company collects network usage data throughout each day at a rate of several thousanddata points each second. The company runs an application to process the usage data in real time. Thecompany 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 identifysudden drops in network usage so the company can take immediate remedial actions.Which solution will meet this requirement with the LEAST latency?
-
Question 5
-
A retail company's Data Engineering Team is tasked with refining their Amazon Redshift cluster to facilitate analysis in a separate testing environment, utilizing the primary cluster's data. The new testing process will engage the secondary cluster for a duration of 3 hours biweekly. The team is evaluating the most cost-effective solution to meet this requirement.
Which method would be the most economical for the company to implement?
Answer: B
-
A retail company's Data Engineering Team is tasked with refining their Amazon Redshift cluster to facilitate analysis in a separate testing environment, utilizing the primary cluster's data. The new testing process will engage the secondary cluster for a duration of 3 hours biweekly. The team is evaluating the most cost-effective solution to meet this requirement.