Answer-first summary for fast verification
Answer: Amazon Athena
Option C is CORRECT because Amazon Athena is a serverless query service that allows you to run SQL queries directly on data stored in Amazon S3. Athena supports data partitioning and can efficiently query data stored in separate S3 buckets. Athena also integrates with the AWS Glue Data Catalog, which helps manage the metadata and maintain the ACID properties of the data.
Author: Ritesh Yadav
Ultimate access to all questions.
Question 15/60
A marketing company uses Amazon S3 to store clickstream data. The company queries the data at the end of each day by using a SQL JOIN clause on S3 objects that are stored in separate buckets.
The company creates key performance indicators (KPIs) based on the objects. The company needs a serverless solution that will give users the ability to query data by partitioning the data. The solution must maintain the atomicity, consistency, isolation, and durability (ACID) properties of the data.
Which solution will meet these requirements MOST cost-effectively?
A
Amazon S3 Select
B
Amazon Redshift Spectrum
C
Amazon Athena
D
Amazon EMR
No comments yet.