Marketing-Cloud-Consultant Practice Test

A financial company wans to use Marketing Cloud to send late payment notices to
accounts whose payment due date lapsed the previous week. The company has shared
the following:
*Payment.csv will arrive on the Enhanced SFTP each Monday at 1 a.m.
*Payments.csv will be encrypted.
*Payments.csv will contain data from the previous week.
*Late payment notices will be sent each Monday at noon.
*They need to receive a file containing customers who opened or clicked on the late
payment notice email within five days after send.
Which automation sequence represents a viable solution?

A.

File Transfer > Import File > Filter > Wait > Send Email > SQL Query > Wait > Data
Extract > File Transfer

B.

Import File > File Transfer > SQL Query > Wait > Send Email > Wait > SQL Query >
Data Extract > File Transfer

C.

File Transfer > File Transfer > Import File > SQL Query > Wait > Send Email > SQL
Query > File Transfer

D.

File Transfer > Import File > Filter > Wait > Send Email > Wait > SQL Query > Data
Extract > File Transfer

Northern Trail Outfitters (NTO) wants its monthly distributor newsletter email to appear to
be sent on behalf of the subscriber’s account representative without segmenting the
audience by sales representative.
In which two ways could this distributor-specific sender profile be configured in a MarketingCloud account with Sender Authentication Package implemented?
Choose 2 answers

A.

Pick “Choose from list,” selecting the From Name and From Email values from the list of
account users.

B.

Match the external keys of the sender profile and data extension containing account
representative details.

C.

Utilize AMPscript data extension lookups to dynamically populate the From Name and
From Email values.

D.

Use substitution strings to populate the From Name and From Email values in the
sender profile.

A customer needs to link demographic information to its model in Contact Builder.
What type of relationship should be used?

A.

One-to-Many

B.

One-to-One

C.

Many-to-One

D.

Many-to-Many

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?

A.

Query Activity > API Event > Automation Studio Activities

B.

Import Activity > Decision > Journey Activities

C.

Query Activity > Data Extension Entry Source > Journey Activates

D.

Salesforce Entry Event > Query Activity > Automation Studio Activities

Which three statements are correct regarding the automation tools in Marketing Cloud?
Choose 3 answers

A.

Automation Studio and Journey Builder allow users to repeat an interaction indefinitely.

B.

Journey Builder allows users to inject Contacts from a data extension which is updated
by Automation Studio.

C.

Journey Builder allows users to update a contact record in a journey or import data into
a data extension.

D.

Automation Studio and Journey Builder allow users to define a wait activity based on
duration.

E.

Automation Studio and Journey Builder allow users to define the parameters of a send
within the tool.