Northern Trail Outfitters (NTO) experienced a 24-hour website outage beginning on a peak shopping day, as a result, a number of logged-in customer's shopping sessions were disrupted. When the site is back online, the retailer would like to encourage those shoppers to return the site and continue their shopping.
What action should Northern Trail Outfitters (NTO) take?

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:
CustomerID, FirstName, EmailAddress, OrderID, OrderDate, ShippedDate.
Which SQL statement should the consultant use?

Northern Trail Outfitters (NTO) wants to use dynamic content within their emails to provide customers with more personalized communications. This includes using a Dynamic Sender Profile to customize the From Name and From Email Address to use the regional store managers' information. If a new manager is assigned to a region, NTO wants to update the information in one place.
What data should a consultant ensure exists within Marketing Cloud in order to facilitate this?

A customer has an eCommerce site and imports Data into three data extensions daily: 'Orders,'
'Order_Details,' and 'Products.' The data extensions contain the following information:
*Orders: OrderId, CustomerId, OrderNumber, OrderDate, OrderTotal, GrandTotal
*Order_Details: ProductId, OrderId, Qty, UnitPrice, ExtendedPrice, Discount
*Products: ProductId, SKU, Name, Description, Cost, Price
Which two relationships should be established in Data Designer? Choose 2 answers

Northern Trail Outfitters (NTO) wants to send out a communication to subscribers who have not made a purchase the last six months. Customer are often opted-in to more than one messaging channel. NTO would like to be able to communicate the same message across all channels.
Which flow would meet their needs?