An organization wants to analyze why their Amazon Athena queries are running slowly. They want to see exactly how much data was scanned for each query and identifying any 'full table scans' on large datasets. Where can they find this granular query performance data?

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

Correct Answer: Athena Query History and CloudWatch Metrics (ProcessedBytes)

Athena provides per-query metrics in the console and via CloudWatch, which are essential for identifying inefficient queries that increase costs....

📋Part of AWS Certified Solutions Architect – Professional (SAP-C02) · AWS Certification Practice
Real Exam ScenarioAmazon S3

An organization wants to analyze why their Amazon Athena queries are running slowly. They want to see exactly how much data was scanned for each query and identifying any 'full table scans' on large datasets. Where can they find this granular query performance data?

✓ Correct Answer & ExplanationAmazon S3

Correct Answer

Athena Query History and CloudWatch Metrics (ProcessedBytes)

Why This Answer Is Correct

Athena provides per-query metrics in the console and via CloudWatch, which are essential for identifying inefficient queries that increase costs.

📚 What This Question Tests

This question evaluates your knowledge of Amazon S3 — a core concept tested in AWS Certified Solutions Architect – Professional (SAP-C02). 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.