DEA-C01 Domain 1: Data Ingestion and Transformation

Which service should you use to transform data with SQL in the data lake?

Multiple choice — select one answer

Answer choices

  1. a. Amazon Kinesis Data Streams or Firehose
  2. b. Apache Iceberg/Hudi/Delta on Glue or EMR
  3. c. AWS Glue DataBrew
  4. d. Amazon Athena or Spark on Glue

Architectural breakdown & explanation

Athena queries S3 with Presto/Trino SQL.

Correct answer(s): d. Amazon Athena or Spark on Glue

Exam domain: Domain 1: Data Ingestion and Transformation (34% weight on the official guide).

Official documentation & study links

Practice this certification

This page is one question from the AWS Certified Data Engineer – Associate bank. Run a full timed practice exam with domain-weighted random questions in your browser.