Salesforce marketing cloud consultant practice test

Northern Trail Outfitters has acquired a new company and is importing customer data to Marketing
Cloud. They want to ensure commercial emails are not sent to email addresses who have previously
opted-out.
Which feature should they use?

• A. Exclusion Script
• B. Auto-suppression List
• C. Suppression List
• D. Exclusion List

A school corporation uses one contact per parent/child combination, updating the email address
based on who they are sending to. However, they would tike to pull data on which email addresses
receive which emails.
What functionality could be used to accomplish this?

• A. Recent Email Send Report
• B. Data Views
• C. Send Log
• D. Tracking Extract

Northern Trail Outfitters has master data extension of 880,000 subscribers they want to randomly
split into 11 groups to test different messaging strategies.
How could this be accomplished?

• A. Use Automation Studio with a random split activity.
• B. Create a random data extension within Email Studio.
• C. Create a random data extension within Contact Builder.
• D. Use Journey Builder with a random split activity.

A small restaurant franchise wants to implement Marketing Cloud to support their franchise owners.
The corporate office the advertising copy and subscriber list. The owners of franchised stores add a
customized local message to the marketing campaign.
What hierarchy should be recommended?

• A. One parent business unit and a child business unit for franchise owners.
• B. One parent business unit and a child business unit for each franchise owners
• C. One business unit.
• D. A parent business unit for each franchise owner

Northern Trail Outfitters wants to set up an automation that imports a file and sends an email to the
contacts when the file is dropped on the SFTP. The name of the file will change, though it will always
start with thankyou_customers.
How would they set up the Import Activity to know the name of the file?

• A. Set File Naming Pattern to %%AUTOMATED_FILENAME%%
• B. Set File Naming Pattern to %%BASEFILENAME_FROM_TRIGGER%%
• C. Filename is automatically passed to Import Activity with File Drop Automations
• D. Check the 'Use filename from Automation' checkbox

Northern Trail Outfitters received a complaint today from a customer who received an email after
unsubscribing last week. Today's email was sent using Marketing Cloud Connect (MCC), though last
week was sent when an external system dropped a file on the Marketing Cloud SFTP and triggered a
User-Initiated Send through an automation.
What could be the reason the customer received the email through MCC?

• A. The previous send's user needed to have edit permissions in Salesforce,
• B. Email Opt Out is only updated if the send originates in Salesforce.
• C. The previous send used Email Address as a Subscriber Key.
• D. The Email Opt Out field needs to be added to the Contact Page Layout.

A customer wants to create a loyalty program by Identifying all subscribers who clicked on a link
within any email sent within the last six months.
What should be recommended?

• A. Create and execute a SQL Query against the _Click data view.
• B. Create and execute a Tracking Extract.
• C. Create and execute a Subscriber Engagement report.
• D. Create and execute a Data Filter on the_Click data view.

A customer wants to create a mobile app that requires users to log in or register before accessing
their dat
a. Their source of truth Is Sales Cloud which Is connected to Marketing Cloud. Users who log In with
existing credentials will have their device associated with their ContactKey. Users who register with
the mobile app will not have their devices associated with a ContactKey for up to 24 hours.
What consideration should a consultant provide to the customer?

• A. User device data is unavailable in Contact Builder for up to 48 hours.
• B. All mobile app users will create additional Contacts in Marketing Cloud.
• C. Existing users will create additional Contacts in Marketing Cloud.
• D. Newly registered users will create additional Contacts in Marketing Cloud.

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

Northern Trail Outfitters has a file that drops intermittently to their SFTP account. Once this file
drops, they want to be able to have it immediately imported and then segmented to enter a specific
journey depending on the data inside the file.
Which two options would meet these requirements?
Choose 2 answers

• A. Scheduled Automation
• B. File Drop Automation
• C. SQL Query
• D. Decision Split