A data engineer is optimizing an Amazon Redshift cluster that stores several years of transaction data. The company has noticed that older data is queried infrequently but needs to be retained for compliance purposes. The newer data is queried frequently for real-time analytics. Which strategy should the engineer implement to balance query performance and cost-effectiveness?