Northern Trail Outfitters wants to know the number of Contacts in their account. This
information needs to be emailed to their Chief Marketing Officer on a weekly basis.
What could be configured to meet this request?

A.

Configure the Contact Extract Activity in Automation Studio

B.

Query the _Subscriber Data View and Extract it weekly

C.

Query the _Contact Data View and transfer it weekly

D.

Schedule the Contacts Counts Standard Report

An online retailer would like to utilize Journey Builder interactions for sending postpurchase
communications to their customers.
What Contact Entry mode best fits this scenario?

A.

No re-entry

B.

Re-entry anytime

C.

Re-entry only after existing

D.

Re-entry after time

Northern Trail outfitters needs to reduce the amount of work when managing messages to
customers, but cannot add any more personnel due to budget constraints. There has been
an increased number of customer purchases on their website, and the team currently
sends batch order confirmations.
What solution will decrease manual workloads on the team and will improve their
customers' experience?

A.

A scheduled automation to send emails to customers who made a purchase daily

B.

A triggered automation to send emails to customers who have made a purchase

C.

A triggered message to send an email as soon as a customer completes a purchase

D.

A user-initiated message to send an email to customers who made a purchase daily

How do I set up an individual who manages Marketing Cloud operations across channels,
mobile, and social? Choose two.

A.

Marketing Channel Manager Role

B.

Regional or Local Administrator Role

C.

Marketing Cloud Administrator Role

D.

Email marketing manager role

North Trail Outfitters (NTO) wants to automate the sending of shipping notices and a
customer survey.
*Shipping notices will be sent once a day.
*The shipping file will be placed on the FTP sometime after 4:00 p.m.
*The shipping data will be stored in the shipping Notice data extension.
*A field in the data extension will contain the shipping data.
*The survey needs to be sent at 9:00 a.m., exactly 10 days after the customers order ships.
Which workflow would most effectively enable NTO to do this?

A.

Option A

B.

Option B

C.

Option C

D.

Option D

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?

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 marketer want to personalize an email with real-time weather information from the Sunny
Sky API.
What tool should be used to parse and display the response within the email?

A.

Node.JS

B.

Apex

C.

SSJS

D.

GTL

NTO wants to import files at certain standard times, but occasionally a file will be dropped
on a Friday if the 30th of the month falls on a weekend.
What is the flow?

A.

Triggered Import - user initiated send (not scheduled)

A daily deal website is concerned with their sender reputation and needs consistent
visibility into subscribers who report their email as spam.
How can they determine which subscribers reported their email as spam so they can flag
those records in their customer service database?

A.

An automation that queries the Complaint data view.

B.

An automation that generates the Unsubscribe Event Extract.

C.

An automation that queries the Unsubscribe data view.

D.

An automation that generates the Complaint Tracking Extract.

Northern Trail Outfitters wants to send an email to one million contacts in Sales Cloud. The
criteria to segment contacts include using 10+ fields to segment.
Which process should the consultant utilize for a reliable send method?

A.

Query Synchronized Data Extensions using a query activity to a Salesforce Data
Extension, then send via Email Studio Send Flow

B.

Import Salesforce Report through an import activity to a Salesforce Data Extension, then
send to data extension using Email Studio email send

C.

Assign the one million contacts from the report to a Salesforce campaign, and use a
Single Step journey with Salesforce Campaign as an entry event

D.

Send to a Salesforce Report from Marketing Cloud using Email Studio Send Flow