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 24, 2026

Add To Cart

Question 1

A company created an extract, transform, and load (ETL) data pipeline in AWS Glue. A data engineer must

crawl a table that is in Microsoft SQL Server. The data engineer needs to extract, transform, and load the

output of the crawl to an Amazon S3 bucket. The data engineer also must orchestrate the data pipeline.

Which AWS service or feature will meet these requirements MOST cost-effectively?

A : AWS Step Functions

B : AWS Glue workflows

C : AWS Glue Studio

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

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

As a Data Engineer, you've been given the task of enhancing the performance of a business analytics application. This application predominantly performs complex, read-intensive queries against large, historical datasets.

The data is currently housed in a MySQL database on Amazon RDS. However, due to the increasing dataset size and query complexity, query performance has significantly degraded. To address this issue, you are considering implementing Amazon ElastiCache.

Which caching strategy would be most effective in this scenario to improve query performance?

A : Use ElastiCache for Memcached implementing an Invalidation strategy, where cache entries are invalidated or updated whenever the database write operations occur.

B : Implement ElastiCache for Redis using a Lazy-Loading strategy, loading data into the cache only when it is requested.

C : Utilize ElastiCache for Memcached with a Write-Through caching strategy, ensuring data is written to both the cache and the database simultaneously.

D : Deploy ElastiCache for Redis with a Write-Around caching strategy, where data is written directly to the database and only the data read from the database is cached.

Answer: B

Question 4

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

Question 5

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

Page: 1 / 117

Total 583 Questions | Updated On: Aug 24, 2026

Add To Cart