Question 300
A team faces the following situation: A business wants to run SQL queries directly against datasets stored in S3 without administering database servers. Which AWS approach best fits?
Explanation
Correct Answer
Use Athena with an appropriate table definition for the data. This is the best high-level recommendation for the stated situation. Amazon Athena supports serverless SQL queries over appropriately cataloged data in S3. The key business clue is: Look for ad hoc SQL analysis of S3-resident data rather than a transactional database. A suitable choice is: Use Athena with an appropriate table definition for the data. An expected result is: Analysts run supported SQL queries over the S3 objects. Important limitation: Query costs and performance still depend on data layout and scanned volume.
Incorrect Answers
Amazon SageMaker AI provides managed capabilities for the machine learning lifecycle. That addresses a different mechanism; this question turns on Use Athena with an appropriate table definition for the.
AWS Glue provides managed data integration, cataloging, and ETL capabilities. That observation may hold without resolving the relevant issue: Use Athena with an appropriate table definition for the.
Amazon QuickSight provides business intelligence dashboards and visual analytics. This is different from the required Use Athena with an appropriate table definition for the result.