Topic 1 Question 111
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?
Amazon S3 Select
Amazon Redshift Spectrum
Amazon Athena
Amazon EMR
ユーザの投票
コメント(6)
- 正解だと思う選択肢: C
C. Amazon Athena
Here's why Amazon Athena is suitable:
Serverless: Amazon Athena is a serverless query service that allows you to run SQL queries directly on data stored in Amazon S3 without the need to manage infrastructure. Partitioning: Athena supports querying data by partitioning, which can significantly improve query performance by limiting the amount of data scanned. ACID Properties: Although Amazon S3 itself does not provide ACID properties, Amazon Athena ensures consistency in query results and durability of the data stored in S3 through its managed query execution. Cost-effective: With Amazon Athena, you only pay for the queries you run and the amount of data scanned, making it a cost-effective choice compared to managing infrastructure or using dedicated services like Amazon Redshift Spectrum or Amazon EMR.
👍 4Ja132024/07/03 - 正解だと思う選択肢: B
Athena is cost effective as it only charges for queries run
👍 2andrologin2024/07/18 - 正解だと思う選択肢: C
Amazon Redshift Spectrum is not serverless.
👍 2EJGisME2024/09/06
シャッフルモード