Northern Trail Outfitters uses a Salesforce Data Entry Source in their Journey that injects Salesforce Orders when they are either created or updated with a status of New, Currently Knitting Shipped, and Complete. Their Journey works when orders are created, but they notice that it does not inject customers when their status is updated.
What could be causing this?

How do you use data designer to link the web analytics data to your subscriber data?

Northern Trail Outfitters (NTO) wants to import recent customer transaction data from their data warehouse into Marketing Cloud on a nightly basis. They plan to create a File Drop Automation to trigger an automation when a data file is transferred from the data warehouse to the import folder in their Enhanced FTP account. NTO notes that user passwords expire every 90 days and they do not want to update their file transfer script on the data warehouse each time a password changes and they do not want to compromise security.
Which solution should the consultant recommend?

Northern Trail Outfitters maintains their primary customer identity in their ERP system but managers their customer service via Service Cloud. Customer data is updated in real-time based on changes in the ERP, and the ERP customer ID serves as the Customer Key. They want to leverage Synchronized Data Extensions to import data about cases from Service Cloud every 15 minutes.
What consideration should be made before implementing this solution?

A consultant needs to send an email to subscribers who have made a purchase. The data used for the send exists on two data extensions--Subscribers and OrderTable, and the customer would like to include key information from both tables, such as:
* CustomerlD
* FirstName
* EmailAddress
* OrderlD
* OrderDate
* ShippedDate
Which SQL statement should the consultant use?