Marketing-Cloud-Consultant Practice Test

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