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: Apr 21, 2026
-
Rated: 4.9 |
-
Online Users: 1164
-
Question 1
-
A data engineer must manage the ingestion of real-time streaming data into AWS. The data engineer wants to perform real-time analytics on the incoming streaming data by using time-based aggregations over a window of up to 30 minutes. The data engineer needs a solution that is highly fault tolerant. Which solution will meet these requirements with the LEAST operational overhead?
Answer: A
-
-
Question 2
-
A Cloud Data Engineering Consultant is tasked with setting up a centralized logging solution for multiple AWS Lambda functions used by a client's serverless application. The application has critical real-time processing components, and the engineering consultant must ensure that logging is set up to capture and respond to error conditions rapidly. The logs must be analyzed for specific error patterns, and notifications must be sent out when these patterns are detected.
Which of the following steps should the Cloud Data Engineering Consultant take to establish a robust logging and notification system using Amazon CloudWatch Logs? (Select TWO)
Answer: A,C
-
A Cloud Data Engineering Consultant is tasked with setting up a centralized logging solution for multiple AWS Lambda functions used by a client's serverless application. The application has critical real-time processing components, and the engineering consultant must ensure that logging is set up to capture and respond to error conditions rapidly. The logs must be analyzed for specific error patterns, and notifications must be sent out when these patterns are detected.
-
Question 3
-
A Data Engineering Consultant is working on an AWS Lambda function that processes streaming data from Amazon Kinesis Data Streams. The function experiences unpredictable performance, sometimes processing records very quickly and at other times being significantly slower, causing a backlog of data in the stream.
What approach should the consultant take to ensure more consistent processing performance?
Answer: A
-
A Data Engineering Consultant is working on an AWS Lambda function that processes streaming data from Amazon Kinesis Data Streams. The function experiences unpredictable performance, sometimes processing records very quickly and at other times being significantly slower, causing a backlog of data in the stream.
-
Question 4
-
A company generates reports from 30 tables in an Amazon Redshift data warehouse. The data source is anoperational Amazon Aurora MySQL database that contains 100 tables. Currently, the company refreshes alldata from Aurora to Redshift every hour, which causes delays in report generation.Which combination of steps will meet these requirements with the LEAST operational overhead? (SelectTWO.)
Answer: A,C
-
A company generates reports from 30 tables in an Amazon Redshift data warehouse. The data source is anoperational Amazon Aurora MySQL database that contains 100 tables. Currently, the company refreshes alldata from Aurora to Redshift every hour, which causes delays in report generation.Which combination of steps will meet these requirements with the LEAST operational overhead? (SelectTWO.)
-
Question 5
-
An e-commerce company uses Amazon RDS for PostgreSQL to manage their product inventory. The database contains a table named products with columns id, name, price, and quantity_in_stock. The company needs to write an SQL query to find all products that have a price greater than $50 and a quantity in stock less than 100.
Which SQL query should the company use to retrieve the correct data from the products table in their PostgreSQL database?
Answer: B
-
An e-commerce company uses Amazon RDS for PostgreSQL to manage their product inventory. The database contains a table named products with columns id, name, price, and quantity_in_stock. The company needs to write an SQL query to find all products that have a price greater than $50 and a quantity in stock less than 100.