Free Amazon AWS-DEA-C01 Exam Questions

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

Page: 1 / 117

Total 582 Questions | Updated On: Apr 01, 2026

Add To Cart

Question 1

An analyst is using Amazon Athena and needs to create a new table in the Parquet format with SNAPPY compression from an existing table named old_table. The task requires the correct syntax for a Create Table As Select (CTAS) statement in Athena. Which of the following SQL statements correctly achieves this objective?

A : CREATE NEW TABLE new_tableFROM old_tableWITH FORMAT AS 'Parquet' AND COMPRESSION AS 'SNAPPY';

B : CREATE TABLE new_tableSET FORMAT = 'Parquet', COMPRESSION = 'SNAPPY'AS SELECT *FROM old_table;

C : CREATE TABLE new_table ASSELECT *FROM old_tableUSING ('format' = 'Parquet', 'compression' = 'SNAPPY');

D : CREATE TABLE new_tableWITH ( format = 'Parquet', write_compression = 'SNAPPY')AS SELECT *FROM old_table;

Answer: D

Question 2

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 3

A mobile app tracks user activity data, which is continuously streamed to Amazon Kinesis Data Streams. The app requires a solution to process this data in real-time and update user profiles stored in Amazon DynamoDB based on the activity data.

What combination of AWS services should be used for real-time processing of the stream and updating the user profiles in DynamoDB?

A : Use AWS Lambda to process data from Kinesis Data Streams and update records in Amazon DynamoDB.

B : Configure Amazon EMR to handle stream processing and update DynamoDB with batch jobs.

C : Deploy Amazon EC2 instances to consume and process the stream, then write to DynamoDB.

D : Use AWS Glue to extract and transform streaming data, and load into DynamoDB.

Answer: A

Question 4

A data engineer needs to use AWS Step Functions to design an orchestration workflow. The workflow must parallel process a large collection of data files and apply a specific transformation to each file. Which Step Functions state should the data engineer use to meet these requirements?

A : Parallel state

B : Choice state

C : Map state

D : Wait state

Answer: C

Question 5

A company needs to partition the Amazon S3 storage that the company uses for a data lake. The partitioning will use a path of the S3 object keys in the following format:

s3://bucket/prefix/year=2023/month=01/day=01

A data engineer must ensure that the AWS Glue Data Catalog synchronizes with the S3 storage when the company adds new partitions to the bucket.

Which solution will meet these requirements with the LEAST latency?

A : Manually run the AWS Glue CreatePartition API twice each day.

B : Run the MSCK REPAIR TABLE command from the AWS Glue console.

C : Schedule an AWS Glue crawler to run every morning.

D : Use code that writes data to Amazon S3 to invoke the Boto3 AWS Glue create_partition API call.

Answer: B

Page: 1 / 117

Total 582 Questions | Updated On: Apr 01, 2026

Add To Cart