What is the MOST appropriate AWS solution to transform data with SQL in the data lake?
Multiple choice — select one answer
Answer choices
Architectural breakdown & explanation
Athena queries S3 with Presto/Trino SQL.
Correct answer(s): a. 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.