SAA-C03 Q710 · Analytics

Question

A company operates a data lake in Amazon S3. The company wants to query and filter data directly in S3 without downloading objects. Which solution will meet these requirements?

Accepted Answer

**Amazon Athena** is a serverless, interactive query service that lets you analyze data **directly in Amazon S3** using standard SQL.

1. **Requirement: Query and filter data in S3** → Athena is purpose-built for this. You define a schema (table) that points to S3 data, then run SQL queries against it. Athena reads only the data it needs (especially with columnar formats like Parquet/ORC).

2. **Requirement: Without downloading objects** → Athena operates as a query-in-place service. You never need to load, copy, or download data into another system. The data stays in S3; Athena reads it on demand using schema-on-read.

3. **Requirement: Simplicity for a data lake** → Athena integrates natively with the AWS data lake ecosystem. It uses the AWS Glue Data Catalog to store metadata/schemas, m

📖 Explanation

✅ Correct Answer

❌ Wrong Answers

📘 Key Concepts

🏗️ Architecture

⚙️ Operations

💰 Cost

🔒 Security

🎯 Exam Tips