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:
Which SQL statement should the consultant use?
A) SELECT T1.CustomerID, T1.FirstName, T1. EmailAddress, T2.OrderlD, T2.0rderDate, T2.ShippedDate FROM ' Subscribers OUTER JOIN OrderTable ON Subscribers.CustomerlD=OrderTable.CustomerlD
B) SELECT * FROM Subscribers WHERE CustomerlD, FirstName, EmailAddress, OrderlD, OrderDate, ShippedDate - JOIN OrderTable On CustomerlD=CustomerlD
C) SELECT CustomerlD, FirstName, EmailAddress, OrderlD, OrderDate, ShippedDate FROM Subscribers INNER JOIN OrderTable ON CustomerlD=CustomerlD
D) SELECT T1.CustomerID, T1.FirstName, T1.EmailAddress, T2.OrderlD, T2.OrderDate, T2.ShippedDate FROM Subscribers T1 INNER JOIN OrderTable T2 ON T1.CustomerID=T2.CustomerID
A bank wants to send out a series of emails to new customers that open a checking or savings account. The emails will be used to educate and inform customers regarding their current account and other bank offerings
• Data for the campaign will be in two data extensions: Customer and New Accounts
• The Customer data extension is currently used for multiple campaigns and is updated at 1:00 a.m.
• The New Accounts data is encrypted and will be placed on the FTP at 10:00 p.m.
Which automated workflow meets the customer's requirements?
A. A scheduled automation that starts at 2:00 a.m. that executes Data Extract Activity, Import Activity, Query Activity, Wait Activity, and Send Email Activity.
B. A triggered automation that executes File Transfer Activity, Import Activity, Query Activity, Wait Activity, and Send Email Activity.
C. A scheduled automation that starts at 2:00 a.m. that executes File Transfer Activity, Import Activity, Query Activity, Wait Activity, and Send Email Activity.
D. A scheduled automation that starts at 12:00 a.m. and executes a File Transfer Activity, Import Activity, Query Activities, Wait Activity, and Send Email Activity.
A company collects subscriptions on its website. It does the following:
• Compiles that subscription list in a database in the website Content Management System (CMS).
• Posts this encrypted list to Marketing Cloud nightly at 11 p.m.
• Uses Marketing Cloud as the database of record.
• Sends up to five emails a week based on subscriber engagement with prior sends.
Which automation sequence (excluding waits) should cover these requirements?
A. File Transfer, Data Extract, Filters, Sends
B. File Transfer, Query, Measures, Sends
C. File Transfer, Import, Measures, Sends
D. File Transfer, Import, Query, Sends
A customer wants to automate the process of sending a series of welcome emails based on the Subscriber's data. Emails should be sent weekly for up to five weeks. If a subscriber makes a purchase, they should stop receiving welcome emails. A Boolean flag should be set in the data extension if the subscriber makes it through the welcome series.
Which steps should be used to accomplish this in Journey Builder?
A. Define Goal, Send Email, Wait, Decision Split
B. Random Split, Send Email, Wait, Define Goal
C. Define Goal, Update Contact Data, Send Email, Wait
D. Update Contact Data, Wait, Send Email, Join
A customer has an eCommerce site and Imports data into three data extensions daily; 'Orders', 'Order_Details' and 'Products'
The data extension contains 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
What two actions should be taken in Data Designer?
A. Create a one-to-one relationship between Orders and order_Details
B. Create a one-to-one relationship between the contact record and Order_Details
C. Create a one-to-one relationship between Order_Details and Products
D. Create a one-to-many relationship between Orders and Order_Details
An existing triggered send needs to be updated with new content. Select the correct sequence:
A. Pause message interaction, Edit message content, Publish changes, Start triggered email interaction
B. Edit message content, Pause message interaction, Publish changes, Start triggered email interaction
C. Start triggered email interaction, Pause message interaction, Edit message content, Publish changes
D. Publish changes, Pause message interaction, Edit message content, Start triggered email interaction