A company stores sensor data in Amazon S3. A data scientist wants to explore the data using SQL without moving it. Which AWS service should they use?
Athena queries data directly in S3 using SQL.
Why this answer
Amazon Athena is the correct choice because it is a serverless interactive query service that allows you to analyze data directly in Amazon S3 using standard SQL without any data movement or infrastructure management. Athena uses Presto under the hood and charges only for the data scanned per query, making it ideal for ad-hoc exploratory analysis on sensor data stored in S3.
Exam trap
The trap here is that candidates often confuse Amazon Athena with Amazon EMR or Redshift, thinking they need a full cluster or data warehouse for SQL queries, but Athena is specifically designed for serverless, direct S3 querying with no data movement.
How to eliminate wrong answers
Option A is wrong because Amazon EMR is a managed big data platform that requires provisioning and managing clusters (e.g., Hadoop, Spark), which involves moving or processing data in a separate compute layer, not querying it directly in S3 with SQL without setup. Option B is wrong because Amazon Redshift is a data warehouse that requires loading data from S3 into its own storage before querying, violating the 'without moving it' requirement. Option C is wrong because Amazon QuickSight is a business intelligence (BI) visualization tool, not a SQL query engine; it can connect to Athena but cannot directly run SQL queries on S3 data on its own.