A company needs to use SQL syntax to perform a direct query of objects in an Amazon S3 bucket. Which AWS service can the company use to meet this requirement?

Question

Options

• AAWS Glue
• BAmazon Athena
• CAWS Lambda
• DAmazon Kinesis

• A
  4% (1)
• B
  88% (23)
• D
  8% (2)

Explanation

Amazon Athena is specifically designed to allow users to run SQL queries directly against data stored in Amazon S3 without needing to load it into a database first - making it the perfect fit for this requirement. It is serverless, requires no infrastructure setup, and uses standard SQL syntax to analyze structured, semi-structured, or unstructured data in S3.

Why the distractors are wrong:

• AWS Glue (A) is an ETL (Extract, Transform, Load) service used to prepare and move data; while it can work alongside Athena, it doesn't directly query S3 using SQL.
• AWS Lambda (C) is a serverless compute service for running code in response to events; it has no built-in SQL querying capability for S3.
• Amazon Kinesis (D) is a real-time data streaming service used to collect and process large streams of data, not for running SQL queries on S3 objects.

Memory tip: Think of Athena as the "ask questions directly" service - just like the Greek goddess of wisdom, Athena gives you the wisdom (insights) to query your S3 data directly with SQL, no database required. If a question mentions SQL + S3 + direct query, the answer is always Athena.

No community discussion yet for this question.