A company runs several brands' websites on AWS. Each site produces tens of gigabytes of web traffic logs daily. Developers need a scalable, cost-effective solution to analyze traffic across all sites on demand once a week for several months. The solution must support standard SQL queries. Which solution is the MOST cost-effective?

Storing logs in Amazon S3 is highly cost-effective for large volumes of data, as S3 offers cheap, scalable storage. Amazon Athena, a serverless query service, allows you to analyze data directly in S3 using standard SQL. This combination is ideal for infrequent, on-demand analysis because you only pay for the data scanned by Athena queries, making it very cost-effective for weekly analysis over several months. Storing logs in Amazon RDS is not suitable due to the high volume of data (tens of gigabytes daily) and the cost associated with relational databases for log storage and analysis. Amazon OpenSearch Service is good for real-time log analysis and search, but it's more expensive for infrequent, batch analysis of historical data. An Amazon EMR cluster provides powerful big data processing, but it's more complex and expensive to manage and operate for weekly, on-demand analysis compared to serverless Athena.