A data lake on S3 contains thousands of Parquet files. An architect needs to run a simple SQL query to extract a subset of data from these files without loading them into a database. Which service/feature is most efficient?

Direct Answer (Verified)Reviewed by Sunny (Senior Cloud Engineer)

Correct Answer: S3 Select or Amazon Athena

Athena is a serverless interactive query service that allows you to analyze data directly in S3 using SQL....

📋Part of AWS Certified Solutions Architect – Associate (SAA-C03) · AWS Certification Practice
Real Exam ScenarioAmazon S3

A data lake on S3 contains thousands of Parquet files. An architect needs to run a simple SQL query to extract a subset of data from these files without loading them into a database. Which service/feature is most efficient?

✓ Correct Answer & ExplanationAmazon S3

Correct Answer

S3 Select or Amazon Athena

Why This Answer Is Correct

Athena is a serverless interactive query service that allows you to analyze data directly in S3 using SQL.

📚 What This Question Tests

This question evaluates your knowledge of Amazon S3 — a core concept tested in AWS Certified Solutions Architect – Associate (SAA-C03). Understanding Amazon S3 is essential for designing scalable, secure, and cost-effective cloud architectures. Mastery of this topic will help you answer scenario-based questions confidently on exam day.