Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Solutions Architect - Associate SAA-C03 All Questions

View all questions & answers for the AWS Certified Solutions Architect - Associate SAA-C03 exam
Go to Exam

Exam AWS Certified Solutions Architect - Associate SAA-C03 topic 1 question 643 discussion

Exam question from Amazon's AWS Certified Solutions Architect - Associate SAA-C03
Question #: 643
Topic #: 1
[All AWS Certified Solutions Architect - Associate SAA-C03 Questions]

A company runs several websites on AWS for its different brands. Each website generates tens of gigabytes of web traffic logs each day. A solutions architect needs to design a scalable solution to give the company's developers the ability to analyze traffic patterns across all the company's websites. This analysis by the developers will occur on demand once a week over the course of several months. The solution must support queries with standard SQL.

Which solution will meet these requirements MOST cost-effectively?

  • A. Store the logs in Amazon S3. Use Amazon Athena tor analysis.
  • B. Store the logs in Amazon RDS. Use a database client for analysis.
  • C. Store the logs in Amazon OpenSearch Service. Use OpenSearch Service for analysis.
  • D. Store the logs in an Amazon EMR cluster Use a supported open-source framework for SQL-based analysis.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by potomac at Nov. 7, 2023, 3:23 p.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 (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
KennethNg923
4 months ago
Selected Answer: A
standard SQL + analyze traffic
upvoted 1 times
...
awsgeek75
9 months ago
Selected Answer: A
Scalable + "The solution must support queries with standard SQL" = A B not scalable C OpenSearch is like ElasticSearch so does not support SQL syntax D EMR is processing not storage. Map-Reduce can use SQL like syntax but this option does not solve scalable storage issues. You normally run EMR on some stored data
upvoted 4 times
cedser8
7 months, 2 weeks ago
OpenSearch can support SQL queries, https://docs.aws.amazon.com/opensearch-service/latest/developerguide/sql-support.html
upvoted 1 times
...
...
pentium75
9 months, 2 weeks ago
Selected Answer: A
Difficult question because both A and C meet the requirements. (OpenSearch does "support queries with standard SQL".) Still, native S3 storage is slightly cheaper than storage for OpenSearch. Also, Athena does not incur additional cost while OpenSearch does. Question asks for cost efficiency, thus A. D is out, not only because of the cost but also because you do not 'store logs in (!) an Amazon EMR cluster'; you can use (!) an EMR cluster to analyze data that is stored elsewhere.
upvoted 2 times
pentium75
9 months, 2 weeks ago
And descriptions of both products, Athena as well as OpenSearch, state that you can use them to "analyze" data.
upvoted 2 times
...
...
pavan2302
9 months, 4 weeks ago
Selected Answer: C
https://docs.aws.amazon.com/opensearch-service/latest/developerguide/cold-storage.html
upvoted 1 times
pentium75
9 months, 2 weeks ago
Seems that even cold storage is still more expensive than S3.
upvoted 1 times
...
...
TariqKipkemei
10 months, 2 weeks ago
Selected Answer: A
solution must support queries with standard SQL = Amazon S3 with Athena
upvoted 3 times
...
NickGordon
11 months, 1 week ago
Selected Answer: A
A, most cost effective
upvoted 2 times
...
potomac
11 months, 1 week ago
Selected Answer: A
option D (using Amazon EMR with an open-source framework) may be overkill for the relatively simple SQL-based analysis.
upvoted 1 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
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