ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Data Engineer - Associate DEA-C01 All Questions

View all questions & answers for the AWS Certified Data Engineer - Associate DEA-C01 exam
Go to Exam

Exam AWS Certified Data Engineer - Associate DEA-C01 topic 1 question 111 discussion

Exam question from Amazon's AWS Certified Data Engineer - Associate DEA-C01
Question #: 111
Topic #: 1
[All AWS Certified Data Engineer - Associate DEA-C01 Questions]

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
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by Bmaster at June 29, 2024, 8:52 a.m.
Disclaimers:
  • - ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
  • - Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Ja13
Highly Voted 10 months, 2 weeks ago
Selected Answer: 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.
upvoted 5 times
...
EJGisME
Most Recent 8 months ago
Selected Answer: C
C. Amazon Athena
upvoted 2 times
...
EJGisME
8 months, 1 week ago
Selected Answer: C
Amazon Redshift Spectrum is not serverless.
upvoted 2 times
...
andrologin
9 months, 4 weeks ago
Selected Answer: B
Athena is cost effective as it only charges for queries run
upvoted 2 times
...
HunkyBunky
10 months, 2 weeks ago
C - cheapest solution in this case
upvoted 1 times
...
Bmaster
10 months, 2 weeks ago
C is good.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago