To export a data file to its SFTP containing all subscribers who did not receive their intended email in the last
24 hours, Northern Trail Outfitters should use a Data Extract Activity in their automation. A Data Extract Activity is an activity that allows marketers to extract data from Marketing Cloud and place it in a file on an Enhanced FTP location or an external SFTP location. The Data Extract Activity can use different extract types, such as Tracking Extract or Data Extension Extract, to export different types of data. References:
https://help.salesforce.com/s/articleView?id=sf.mc_as_data_extract_activity.htm&type=5

Creating and enabling a BLOCKOUT window in MobileConnect can be used to prevent SMS messages from being sent during certain hours of the day. A BLOCKOUT window is a time period during which no messages are sent or received by MobileConnect, regardless of when they were scheduled or triggered.
References: https://help.salesforce.com/s/articleView?id=sf.mc_moc_blockout_window.htm&type=5

To provide near real-time data in a 30-day welcome journey, Northern Trail Outfitters should use contact data using synchronized data sources. This will allow them to access the most up-to-date data from their CRM system in decision splits and other journey activities. Journey data is static and based on the entry source data extension, which may not reflect recent changes in CRM. Contact data mapped through profile attributes or imported from CRM reports may not be as timely or accurate as synchronized data sources. References:
https://help.salesforce.com/s/articleView?id=sf.mc_co_synchronized_data_sources.htm&type=5 https://help.
salesforce.com/s/articleView?id=sf.mc_jb_decision_split.htm&type=5

To diagnose the issue of failed Salesforce Triggered Sends, the consultant should ensure the System User is assigned the Standard User Profile. The System User is a user account that Marketing Cloud Connect uses to communicate with Sales Cloud. The System User needs to have the Standard User Profile or a custom profile with similar permissions to enable Salesforce Triggered Sends. References: https://help.salesforce.com/s
/articleView?id=sf.mc_co_troubleshoot_marketing_cloud_connect_configuration_issues.htm&type=5

Import File activity can be used to import the unsub file from the SFTP to a data extension. Query activity can be used to query the data extension and update the status of the subscribers in All Subscribers list to Unsubscribed. Data Extract and File Transfer activities are not needed for this process. References:
https://help.salesforce.com/articleView?id=sf.mc_as_import_file_activity.htm&type=5 https://help.salesforce.
com/articleView?id=sf.mc_as_query_activity.htm&type=5