DEA-C01 Domain 1: Data Ingestion and Transformation

A team must transform data with SQL in the data lake. Which option meets the requirement?

Multiple choice — select one answer

Answer choices

  1. a. AWS Glue DataBrew
  2. b. Scan all data always (not recommended for production workloads)
  3. c. AWS DMS
  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.