Q37 — AWS SAA-C03 Ch.6

Question 37 of 65 | ← Chapter 6

Q402. 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 for analysis ✓
• B. Store the logs in Amazon RDS. Use a database client for analysis
• C. Store the logs in Amazon OpenSearch Service (Amazon Elasticsearch Service). Use Amazon OpenSearch Service (Amazon Elasticsearch Service) for analysis.
• D. Store the logs in an Amazon EMR cluster. Use a supported open-source framework for SQL-based analysis.

Correct Answer: A. Store the logs in Amazon S3. Use Amazon Athena for analysis

Explanation

Storing the logs in Amazon S3 and using Amazon Athena for analysis is the most cost-effective solution for this scenario. Amazon S3 provides durable and scalable storage for the web traffic logs. Amazon Athena allows developers to analyze the logs using standard SQL queries without the need for managing infrastructure or provisioning resources. This on-demand analysis can be performed once a week over several months, providing flexibility and cost-effectiveness. Additionally, Amazon Athena integrates seamlessly with Amazon S3, making it a suitable choice for analyzing large volumes of web traffic logs.