A company needs to process a one-time batch of 10 TB of log data. The transformation is complex and requires custom Spark code. The data is stored in S3, and the output will be written back to S3. The team wants to minimize cost and does not need a persistent cluster. Which service should they use?

AWS Lambda with Python to process the data.

Amazon EMR with a transient cluster using Spot Instances.

Amazon Redshift with a COPY command and SQL transformations.

A data engineer is troubleshooting a slow-running Amazon EMR job. Which approach is most effective for identifying performance bottlenecks?

Increase the number of nodes in the cluster

Review the Spark UI to analyze stage execution times and resource usage

Check the S3 bucket permissions

An AWS Glue ETL job fails with an 'OutOfMemoryError'. What is the most likely cause and a common solution?

The job has a schema mismatch; fix the schema in the Data Catalog

The S3 bucket is in a different region; copy the data to the same region

The job is running out of memory; increase the number of DPUs or worker type

The job has a network connectivity issue; check the VPC configuration

AWSCertified Data Engineer - Associate

Domain 1Objective 2

Task 1.2: Transform and Process Data DEA-C01 Practice Questions (Page 6)

Part of the Content Domain 1: Data Ingestion and Transformation domain, which accounts for 34% of the DEA-C01 exam. AWS does not publish an official question count, but from its 130-minute exam (~50–85 total, ~17–29 in this domain), expect 4–7 from this objective — we provide 29 practice questions to prepare you well beyond it. (estimate)

29questions here

6free pages

10concepts

34%of the exam

Questions 26–29

26expert · hard
A company needs to process a one-time batch of 10 TB of log data. The transformation is complex and requires custom Spark code. The data is stored in S3, and the output will be written back to S3. The team wants to minimize cost and does not need a persistent cluster. Which service should they use?
Select an answer first
27foundation · easy
A data engineer is troubleshooting a slow-running Amazon EMR job. Which approach is most effective for identifying performance bottlenecks?
Select an answer first
28foundation · easy
Which AWS service is commonly used to run SQL queries directly on data stored in Amazon S3 using JDBC/ODBC drivers?
Select an answer first
29foundation · easy
An AWS Glue ETL job fails with an 'OutOfMemoryError'. What is the most likely cause and a common solution?
Select an answer first

Finished these 4 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack to DEA-C01

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by AWS. “DEA-C01” is a trademark of its owner, used for identification only.

Task 1.2: Transform and Process Data DEA-C01 Practice Questions (Page 6)

Questions 26–29

A company needs to process a one-time batch of 10 TB of log data. The transformation is complex and requires custom Spark code. The data is stored in S3, and the output will be written back to S3. The team wants to minimize cost and does not need a persistent cluster. Which service should they use?

A data engineer is troubleshooting a slow-running Amazon EMR job. Which approach is most effective for identifying performance bottlenecks?

Which AWS service is commonly used to run SQL queries directly on data stored in Amazon S3 using JDBC/ODBC drivers?

An AWS Glue ETL job fails with an 'OutOfMemoryError'. What is the most likely cause and a common solution?

Keep studying — Content Domain 1: Data Ingestion and Transformation