Which AWS service provides an interactive query interface to analyze data in Amazon S3 using SQL?

Which AWS service provides an interactive query interface to analyze data in Amazon S3 using SQL?

• A. Amazon Lake Formation
• B. AWS Data Exchange
• C. Amazon EMR
• D. Amazon Athena

Answer: (D)

Running SQL against data stored in S3 without managing servers is what Amazon Athena does. It’s a serverless, on-demand query service designed to analyze data directly in S3. You point Athena at your S3 data, define a schema (via the AWS Glue Data Catalog or Athena’s own metadata), and start querying with SQL. It automatically scales to your workload and you pay only for the data scanned by each query. This makes it ideal for ad-hoc analytics, data exploration, and quick dashboards over your data lake. Other options serve different purposes. Lake Formation focuses on governance and access control for data lakes, not the interactive query experience. Data Exchange is for sharing datasets. EMR is a managed cluster for big data processing (with Hive/Spark SQL), which requires provisioning infrastructure and isn’t as lightweight for ad-hoc, serverless querying of S3 data.

Running SQL against data stored in S3 without managing servers is what Amazon Athena does. It’s a serverless, on-demand query service designed to analyze data directly in S3. You point Athena at your S3 data, define a schema (via the AWS Glue Data Catalog or Athena’s own metadata), and start querying with SQL. It automatically scales to your workload and you pay only for the data scanned by each query. This makes it ideal for ad-hoc analytics, data exploration, and quick dashboards over your data lake.

Other options serve different purposes. Lake Formation focuses on governance and access control for data lakes, not the interactive query experience. Data Exchange is for sharing datasets. EMR is a managed cluster for big data processing (with Hive/Spark SQL), which requires provisioning infrastructure and isn’t as lightweight for ad-hoc, serverless querying of S3 data.