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: 513
-
Updated On: Jun 04, 2025
-
Rated: 4.9 |
-
Online Users: 1026
-
Question 1
-
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 2
-
A financial services company is storing time-series data in a relational database hosted on Amazon RDS. The company wants to improve query performance for reports that are run on a monthly basis, which involve large scans over historical data. The solution should optimize costs and maintain current data integrity constraints.
Which approach should the company take?
Answer: A
-
A financial services company is storing time-series data in a relational database hosted on Amazon RDS. The company wants to improve query performance for reports that are run on a monthly basis, which involve large scans over historical data. The solution should optimize costs and maintain current data integrity constraints.
-
Question 3
-
A company receives test results from testing facilities that are located around the world. The company storesthe test results in millions of 1 KB JSON files in an Amazon S3 bucket. A data engineer needs to process thefiles, convert them into Apache Parquet format, and load them into Amazon Redshift tables. The dataengineer uses AWS Glue to process the files, AWS Step Functions to orchestrate the processes, and AmazonEventBridge to schedule jobs.The company recently added more testing facilities. The time required to process files is increasing. The dataengineer must reduce the data processing time.Which solution will MOST reduce the data processing time?
Answer: B
-
A company receives test results from testing facilities that are located around the world. The company storesthe test results in millions of 1 KB JSON files in an Amazon S3 bucket. A data engineer needs to process thefiles, convert them into Apache Parquet format, and load them into Amazon Redshift tables. The dataengineer uses AWS Glue to process the files, AWS Step Functions to orchestrate the processes, and AmazonEventBridge to schedule jobs.The company recently added more testing facilities. The time required to process files is increasing. The dataengineer must reduce the data processing time.Which solution will MOST reduce the data processing time?
-
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
-
The Cloud Data Engineering team at an e-commerce company is tasked with analyzing historical sales data stored in CSV files in Amazon S3. They require a solution that allows them to directly query this data for their daily sales report, which will include product names, quantities sold, and total sales amounts. The solution should enable them to perform this task without the overhead of cluster management or data loading processes.
Which two steps are essential to set up this process (Select TWO)
Answer: D,E
-
The Cloud Data Engineering team at an e-commerce company is tasked with analyzing historical sales data stored in CSV files in Amazon S3. They require a solution that allows them to directly query this data for their daily sales report, which will include product names, quantities sold, and total sales amounts. The solution should enable them to perform this task without the overhead of cluster management or data loading processes.