Analysts need ad-hoc SQL over years of CloudTrail and app logs landed as Parquet on S3 without standing up a permanent warehouse cluster. Which approach fits?
Select an answer to reveal the explanation.
Short Explanation
The logs already live in the lake as Parquet. Point Athena at S3 and run SQL—no forever warehouse cluster to babysit.
Full Explanation
Athena is a serverless interactive query service for data in S3, ideal for ad-hoc SQL on Parquet logs without provisioning a warehouse. DynamoDB Scans are not an analytics lake pattern; a permanent single EC2 Hadoop host adds ops burden; API Gateway mapping templates are not a SQL engine.