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 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 2
-
A Data Engineering team is planning to migrate a complex legacy Microsoft SQL Server database to Amazon Aurora MySQL. The existing SQL Server database contains several stored procedures, triggers, and complex joins. The team is concerned about potential compatibility issues and the effort needed to rewrite substantial amounts of SQL code manually. They aim to use AWS services to facilitate an efficient and accurate schema conversion, ensuring minimal downtime and data consistency during the migration process.
What sequence of steps should the team follow using AWS services to achieve this migration?
Answer: B
-
A Data Engineering team is planning to migrate a complex legacy Microsoft SQL Server database to Amazon Aurora MySQL. The existing SQL Server database contains several stored procedures, triggers, and complex joins. The team is concerned about potential compatibility issues and the effort needed to rewrite substantial amounts of SQL code manually. They aim to use AWS services to facilitate an efficient and accurate schema conversion, ensuring minimal downtime and data consistency during the migration process.
-
Question 3
-
A data engineer wants to orchestrate a set of extract, transform, and load (ETL) jobs that run on AWS. TheETL jobs contain tasks that must run Apache Spark jobs on Amazon EMR, make API calls to Salesforce, andload data into Amazon Redshift.The ETL jobs need to handle failures and retries automatically. The data engineer needs to use Python toorchestrate the jobs.Which service will meet these requirements?
Answer: A
-
A data engineer wants to orchestrate a set of extract, transform, and load (ETL) jobs that run on AWS. TheETL jobs contain tasks that must run Apache Spark jobs on Amazon EMR, make API calls to Salesforce, andload data into Amazon Redshift.The ETL jobs need to handle failures and retries automatically. The data engineer needs to use Python toorchestrate the jobs.Which service will meet these requirements?
-
Question 4
-
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 5
-
A company wants to migrate an application and an on-premises Apache Kafka server to AWS. Theapplication processes incremental updates that an on-premises Oracle database sends to the Kafka server. Thecompany wants to use the replatform migration strategy instead of the refactor strategy.Which solution will meet these requirements with the LEAST management overhead?
Answer: D
-
A company wants to migrate an application and an on-premises Apache Kafka server to AWS. Theapplication processes incremental updates that an on-premises Oracle database sends to the Kafka server. Thecompany wants to use the replatform migration strategy instead of the refactor strategy.Which solution will meet these requirements with the LEAST management overhead?