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

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

Submit Cancel

awsgeek75

Highly Voted 1 year, 7 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 6 times

cedser8

1 year, 5 months ago

OpenSearch can support SQL queries, https://docs.aws.amazon.com/opensearch-service/latest/developerguide/sql-support.html

upvoted 2 times

...

tch

Most Recent 7 months ago

Selected Answer: A

Amazon Athena is an interactive analytics service that makes it simple to analyze data in Amazon Simple Storage Service (S3) using SQL. Athena is serverless, so there is no infrastructure to set up or manage, and you can start analyzing data immediately. You don’t even need to load your data into Athena; it works directly with data stored in Amazon S3. Amazon Athena for SQL uses Trino and Presto with full standard SQL support and works with various standard data formats, including CSV, JSON, Apache ORC, Apache Parquet, and Apache Avro. Athena for Apache Spark supports SQL and allows you to use Apache Spark, an open-source, distributed processing system used for big data workloads. To get started, log in to the Athena Management Console and start interacting with your data using the query editor or notebooks.

upvoted 1 times

...

KennethNg923

1 year, 2 months ago

Selected Answer: A

standard SQL + analyze traffic

upvoted 2 times

...

pentium75

1 year, 7 months 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 3 times