Ultimate access to all questions.
A company has set up a web application with AWS WAF logging to Amazon S3 via Amazon Kinesis Data Firehose. They have implemented a daily Amazon Athena query to analyze the previous day's AWS WAF logs, which have a consistent volume. Despite this, the query execution time has been increasing over time. A solutions architect is tasked with designing a solution to prevent this increase in query time while minimizing operational overhead. What is the most effective solution to achieve this goal?