To inform NTO's marketing manager if more than 1,000 records are ever imported through this automation, and prevent the sendable data extension from being updated that day, the consultant should place a Verification Activity between the import and SQL Query activity. A Verification Activity is an activity that allows marketers to verify if certain conditions are met before proceeding with the next activity in an automation. For example, a Verification Activity can check if the number of records in a data extension is above or below a specified threshold, and send an email notification or stop the automation based on the result.References:https://help.salesforce.com/s/articleView?id=sf.mc_as_verification_activity.htm&type=5

To filter records entering a journey based on an updated status field ("shipped"), the marketer should use:
* An Entry Source Filter to limit which contacts actually enter the journey at the point of entry (e.g., only those whose order status is 'shipped' today).
* An SQL Query to preprocess or segment records within a Data Extension before injecting them into the journey.
Filter Activity is used inside Automation Studio (not at the journey entry point), and Decision Splits occur after entry - not before.
-
Exact Extracts from Salesforce Documentation:
Source: Salesforce Help - Entry Source Filters
# "An entry source filter defines criteria that records must meet before entering a journey." Source: Salesforce Help - SQL Query Activities
# "Use SQL Query Activities to select, transform, and filter data from one or more data extensions."
-

To integrate Marketing Cloud with their existing point-of-sale system in order to email purchase receipts to their customers, Northern Trail Outfitters should use MuleSoft Anypoint Platform. MuleSoft Anypoint Platform is a tool that allows marketers to connect and integrate different systems and applications using APIs and connectors. MuleSoft Anypoint Platform can help transform and map data between different formats and protocols, such as JSON and SOAP.
References:https://www.mulesoft.com/platform/anypoint-platform