After a design review, leadership requires the team to transform data with SQL in the data lake. Which approach is MOST reliable? 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): c. 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.