The consultant should consider moving old data out of the CRMinto a data warehouse as a data management strategy for the Advancement office that plans to use Salesforce and Marketing Cloud to engage its alumni, donors, and university supporters and wants to retain all contact data and email activity, including Individual Email Result (IER) data, but also wants to avoid unnecessary data storage. Moving old data out of the CRM into a data warehouse means transferring historical or inactive data from Salesforce into another system that can store large amounts of data for analysis or reporting purposes. Moving old data out of the CRM into a data warehouse can help the Advancement office retain all contact data and email activity, including IER data, but also avoid unnecessary data storage by reducing the amount of data in Salesforce and improving performance and efficiency. Creating a Force.com Query Plan for old data, using Data Studio to process old data, or using Data Loader to export old data are not data management strategies that can meet the Advancement office’s needs. References:

https://developer.salesforce.com/docs/atlas.en-us.salesforce_large_data_volumes_bp.meta/salesforce_large_data_volumes_bp/ldv_deployments_introduction.htm

https://help.salesforce.com/s/articleView?id=sf.mc_co_data_management_best_practices.htm &type=5