Free Amazon Data-Engineer-Associate Exam Questions
Try our Free Demo Practice Tests for Comprehensive Data-Engineer-Associate Exam 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: May 21, 2026
-
Rated: 4.9 |
-
Online Users: 1164
-
Question 1
-
A company's security team mandates that their Amazon RDS databases should only accept connections from specific, known IP addresses to ensure security. As a data engineer, you are tasked with implementing this requirement for an RDS instance that will be accessed by multiple clients located in different geographical locations, each with a fixed set of IP addresses.
Which of the following would be the most effective and secure way to comply with this security requirement?
Answer: D
-
A company's security team mandates that their Amazon RDS databases should only accept connections from specific, known IP addresses to ensure security. As a data engineer, you are tasked with implementing this requirement for an RDS instance that will be accessed by multiple clients located in different geographical locations, each with a fixed set of IP addresses.
-
Question 2
-
A data engineer is launching an Amazon EMR cluster. The data that the data engineer needs to load into thenew cluster is currently in an Amazon S3 bucket. The data engineer needs to ensure that data is encryptedboth at rest and in transit.The data that is in the S3 bucket is encrypted by an AWS Key Management Service (AWS KMS) key. Thedata engineer has an Amazon S3 path that has a Privacy Enhanced Mail (PEM) file.Which solution will meet these requirements?
Answer: C
-
A data engineer is launching an Amazon EMR cluster. The data that the data engineer needs to load into thenew cluster is currently in an Amazon S3 bucket. The data engineer needs to ensure that data is encryptedboth at rest and in transit.The data that is in the S3 bucket is encrypted by an AWS Key Management Service (AWS KMS) key. Thedata engineer has an Amazon S3 path that has a Privacy Enhanced Mail (PEM) file.Which solution will meet these requirements?
-
Question 3
-
A Data Engineering Consultant has been approached by a fintech company, AlphaFinance, which offers investment portfolio tracking for their customers. They want to create a daily report that shows the average value of all portfolios for the last 30 days, grouped by investment type (e.g., stocks, bonds, real estate). The data for each customer's portfolio is stored in an Amazon Redshift cluster, updated daily.
Which approach should the consultant recommend to efficiently derive this report?
Answer: A
-
A Data Engineering Consultant has been approached by a fintech company, AlphaFinance, which offers investment portfolio tracking for their customers. They want to create a daily report that shows the average value of all portfolios for the last 30 days, grouped by investment type (e.g., stocks, bonds, real estate). The data for each customer's portfolio is stored in an Amazon Redshift cluster, updated daily.
-
Question 4
-
A data engineer is designing a new data lake architecture for a company. The data engineer plans to useApache Iceberg tables and AWS Glue Data Catalog to achieve fast query performance and enhanced metadatahandling. The data engineer needs to query historical data for trend analysis and optimize storage costs for alarge volume of event data.Which solution will meet these requirements with the LEAST development effort?
Answer: A
-
A data engineer is designing a new data lake architecture for a company. The data engineer plans to useApache Iceberg tables and AWS Glue Data Catalog to achieve fast query performance and enhanced metadatahandling. The data engineer needs to query historical data for trend analysis and optimize storage costs for alarge volume of event data.Which solution will meet these requirements with the LEAST development effort?
-
Question 5
-
A data engineer needs to build an enterprise data catalog based on the company's Amazon S3 buckets andAmazon RDS databases. The data catalog must include storage format metadata for the data in the catalog.Which solution will meet these requirements with the LEAST effort?
Answer: B
-
A data engineer needs to build an enterprise data catalog based on the company's Amazon S3 buckets andAmazon RDS databases. The data catalog must include storage format metadata for the data in the catalog.Which solution will meet these requirements with the LEAST effort?