data-engineer video for a media company is using Amazon Redshift to store and analyze large volumes of log data from their web application. They ingest hundreds
A media company is using Amazon Redshift to store and analyze large volumes of log data from their web application. They ingest hundreds of gigabytes of data daily into the Redshift cluster, but they are experiencing performance degradation in their queries due to the growing data volume. The company needs a cost-effective solution to manage storage growth while maintaining high query performance. Which of the following solutions should the data engineer implement to optimize storage and improve query performance?