Exam DEA-C01 All QuestionsBrowse all questions from this exam
Go to Exam
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?

    Correct Answer: C

    Amazon Athena is a serverless query service that directly queries data stored in Amazon S3 using SQL, making it a suitable and cost-effective solution. It supports partitioning which optimizes query performance by scanning only the necessary data. Additionally, Athena handles consistency in query results and ensures durability with its managed execution, meeting the requirements for the ACID properties. You only pay for the queries you run and the data scanned, keeping costs low without needing to manage infrastructure.

Discussion
Ja13Option: 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.

androloginOption: B

Athena is cost effective as it only charges for queries run

HunkyBunky

C - cheapest solution in this case

Bmaster

C is good.