Question 1 · choose 1
An analyst wants to run standard SQL queries directly against CSV and Parquet files already stored in Amazon S3. She does not want to load the data into a database or manage any servers, and she wants to pay only for the queries she runs. Which service fits?
- AAmazon Kinesis Data Streams
- BAmazon Quick Sight
- CAmazon Athena
- DAmazon SageMaker AI
Show the answer and why
AAmazon Kinesis Data Streams
Incorrect
Kinesis Data Streams collects and processes streaming data in real time. It does not query files already sitting in S3.
BAmazon Quick Sight
Incorrect
Quick Sight builds interactive dashboards and visualizations for business intelligence. It is not the SQL query engine over S3 files.
CAmazon Athena
Correct
Athena is a serverless, interactive query service for analyzing data directly in Amazon S3 with standard SQL; you pay only for the queries you run.
DAmazon SageMaker AI
Incorrect
SageMaker AI is for building, training and deploying machine learning models, not for ad-hoc SQL over files.
Point a query engine at the files where they are: Athena reads S3 directly, with no cluster to run and no data to load first.
AWS documentation