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: Dec 05, 2025
-
Rated: 4.9 |
-
Online Users: 1164
-
Question 1
-
A company is using Amazon Redshift for their business analytics and reporting purposes. They frequently need to run analytical queries on their historical data stored in a PostgreSQL database hosted on Amazon RDS. The company wants to analyze this historical data in conjunction with their current data warehouse data without moving or duplicating the data.
Which Redshift feature should the company use to meet this requirement?
Answer: A
-
A company is using Amazon Redshift for their business analytics and reporting purposes. They frequently need to run analytical queries on their historical data stored in a PostgreSQL database hosted on Amazon RDS. The company wants to analyze this historical data in conjunction with their current data warehouse data without moving or duplicating the data.
-
Question 2
-
A company receives a data file from a partner each day in an Amazon S3 bucket. The company uses a daily
AW5 Glue extract, transform, and load (ETL) pipeline to clean and transform each data file. The output of the
ETL pipeline is written to a CSV file named Dairy.csv in a second 53 bucket.
Occasionally, the daily data file is empty or is missing values for required fields. When the file is missing
data, the company can use the previous day's CSV file.
A data engineer needs to ensure that the previous day's data file is overwritten only if the new daily file is
complete and valid.
Which solution will meet these requirements with the LEAST effort?
Answer: B
-
A company receives a data file from a partner each day in an Amazon S3 bucket. The company uses a daily
-
Question 3
-
A market research firm collects extensive survey data in .csv format, stored with numerous columns. The data analysts primarily focus on a subset of columns for most of their queries. The firm needs an efficient way to ingest this data into their Amazon S3 data lake to facilitate cost-effective querying with Amazon Athena, especially given that full file scans are rare.
Which method should the data engineer use to ingest the survey data into the S3 data lake to optimize for Athena querying and cost efficiency?
Answer: A
-
A market research firm collects extensive survey data in .csv format, stored with numerous columns. The data analysts primarily focus on a subset of columns for most of their queries. The firm needs an efficient way to ingest this data into their Amazon S3 data lake to facilitate cost-effective querying with Amazon Athena, especially given that full file scans are rare.
-
Question 4
-
A company is using AWS Glue to manage their data catalog for various data sources. They have an Amazon S3 bucket that receives a continuous stream of JSON files, which are saved in a nested directory structure based on the ingestion date (e.g., year=2023/month=04/day=05). Each JSON file structure differs slightly from others, causing issues with schema consistency in the Glue Data Catalog.
To ensure accurate schema detection and consistent query results in downstream services like Amazon Athena and Amazon Redshift Spectrum, what should the company do?
Answer: A
-
A company is using AWS Glue to manage their data catalog for various data sources. They have an Amazon S3 bucket that receives a continuous stream of JSON files, which are saved in a nested directory structure based on the ingestion date (e.g., year=2023/month=04/day=05). Each JSON file structure differs slightly from others, causing issues with schema consistency in the Glue Data Catalog.
-
Question 5
-
A company has completed a full database load to their S3 data lake and is now using AWS Database Migration Service (DMS) to stream ongoing change data capture (CDC) updates. They need an effective method to apply these CDC updates, including deletes and upserts, to their structured data in S3.
What is the most efficient and transactionally consistent approach for applying these updates?
Answer: D
-
A company has completed a full database load to their S3 data lake and is now using AWS Database Migration Service (DMS) to stream ongoing change data capture (CDC) updates. They need an effective method to apply these CDC updates, including deletes and upserts, to their structured data in S3.