To review last year's holiday engagement compared to this year's engagement, Northern Trail Outfitters' marketing department should use an SQL activity using data views. Data views in Salesforce Marketing Cloud provide access to detailed tracking information and historical engagement data. By writing SQL queries, the marketing department can extract, compare, and analyze the engagement data from different time periods, enabling them to understand trends and performance.