Free Amazon AWS-DEA-C01 Exam Questions

Become Amazon Certified with updated AWS-DEA-C01 exam questions and correct answers

Page: 1 / 117

Total 583 Questions | Updated On: Aug 11, 2026

Add To Cart

Question 1

A data engineering team at an online retail company is optimizing the performance of their Amazon Redshift data warehouse. The warehouse contains a large sales table with millions of rows and a smaller products table. Queries often join these two tables, and the team wants to optimize the query performance, especially for these join operations.

Which Redshift distribution style should the team use for the sales and products tables to enhance query performance?

A : Configure the sales table to ALL distribution and the products table to EVEN distribution.

B : Configure the sales table to AUTO distribution and the products table to ALL distribution.

C : Configure the sales table to EVEN distribution and the products table to KEY distribution.

D : Configure KEY distribution for both the sales and products tables based on the join column.

Answer: B

Question 2

A company wants to migrate a data warehouse from Teradata to Amazon Redshift. Which solution will meet this requirement with the LEAST operational effort?

A : Use AWS Database Migration Service (AWS DMS) Schema Conversion to migrate the schema. Use AWS DMS to migrate the data.

B : Use the AWS Schema Conversion Tool (AWS SCT) to migrate the schema. Use AWS Database Migration Service (AWS DMS) to migrate the data.

C : Use AWS Database Migration Service (AWS DMS) to migrate the data. Use automatic schema conversion.

D : Manually export the schema definition from Teradata. Apply the schema to the Amazon Redshift database. Use AWS Database Migration Service (AWS DMS) to migrate the data.

Answer: B

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?

A : Amazon Managed Workflows for Apache Airflow (Amazon MWAA)

B : AWS Step Functions

C : AWS Glue

D : Amazon EventBridge

Answer: A

Question 4

A data engineer needs to reformat newly acquired .csv data in an S3 bucket for more efficient analytics. The data includes timestamps, and older data is removed daily. What is the most cost-effective AWS solution to transform and optimize this data for query performance?

A : Set up a daily Lambda function to convert and partition the .csv data into Parquet format within S3.

B : Use AWS Glue to convert the .csv data to Apache Parquet and partition it by timestamp.

C : Configure an EMR Spark job to transform the .csv files into Parquet, partitioned by the creation timestamp.

D : Run an Athena CTAS query to convert the data to Parquet format with Snappy compression, partitioned by timestamp.

Answer: D

Question 5

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?

A : Use a larger worker type.

B : Increase the number of workers in the AWS Glue ETL jobs.

C : Use the AWS Glue DynamicFrame grouping option.

D : Enable AWS Glue auto scaling.

Answer: D

Page: 1 / 117

Total 583 Questions | Updated On: Aug 11, 2026

Add To Cart