2026
Northern Trail Outfitters wants to compile a report of Email Metrics across all jobs deployed in the last
six months and correlate those metrics to single subscribers and their corresponding data from data
extensions. What should be used to pull this data per the requirements?
A. List Filter
B. Scheduled Automation
C. SQL Query
D. Standard Tracking Extract - Answers C. SQL Query
NTO wants an upcoming email to include loyalty points available for the subscriber. Loyalty points are
available in a data extension and relate to the subscriber on SuscriberKey.
How could they achieve this personalization?
A. Use the Einstein Content content block in the email
B. Use the %%_subscriberkey%% string in the email
C. Use AMPscript to a do a Lookup()
D. Use a personalization string from the HTML editor tab - Answers C. Use AMPscript to a do a
Lookup()
A marketer needs to split up an audience located in a data extension.
In which two ways could the data extension population be divided w the split action?
A. Random group by percentage
B. Random group by fixed number
C. Clickers by day range
D. Openers by day range - Answers A. Random group by percentage
B. Random group by fixed number
NTO uses a Master Subscriber data extension to manage their subscribers. They send a monthly
educational newsletter as well as a weekly promotional campaign.
How should subscriber preferences be managed?
A. Create a suppression list for each communication type and associate the emails with these
suppression lists during the send
B. Create filters for each communication type and select the resulting data extensions with the emails
during the send
C. Create Boolean profile attributes for each communication type from which to query and populate
audiences for each send
D. Create publication lists for each communication type and associate the emails with the publications
lists during the send - Answers D. Create publication lists for each communication type and associate
the emails with the publications lists during the send
NTo uses Automation Studio to import their Master Subscriber list. They want to enable their regional
marketers to refresh their subscribers from the Master Subscriber list prior to each send. Their
regional marketers are not technical and prefer to avoid writing code.
A. SQL Query
B. Data Extract
C. Filter Activity
D. Script Activity - Answers C. Filter Activity
Once a Measure is created, where could it be leveraged as criteria?
A. Within a SQL Query Activity
B. Within a Data Extract
C. Within a Data Filter
,D. Within a SSJS activity - Answers C. Within a Data Filter
When using a mobile-optimized template, which two items cause the mobile layout to display?
Choose 2
A. The screen size of the device used to view the email
B. CSS @media queries present in the email HTML
C. The email client detection tracking pixel
D. A subscriber attribute that dictates a mobile layout preference - Answers A. The screen size of the
device used to view the email
B. CSS @media queries present in the email HTML
What occurs when a subscriber Master Unsubscribes?
A. Subscriber status is set to 'Unsubscribe on the master list only
B. Subscriber status is set to 'Unsubscribed' on all lists and the master list
C. Subscriber is filtered into an Unsubscribe list
D. Subscriber is added to the global opt-out list - Answers B. Subscriber status is set to 'Unsubscribed'
on all lists and the master list
A marketer needs to update, but not overwrite, a data extension nightly based on data files received
on the SFTP.
What is required for the data to be updated?
A. Subscriber Key
B. Multiple Primary Keys
C. Send Relationship
D. Primary Key - Answers D. Primary Key
Northern Trail Outfitter's marketing team has been tasked with setting up a thank you email
personalized with the subscriber preferences and sent out every time a subscriber makes a purchase.
Which two functionalities and/or tools are available to set this up?
Choose 2
A. Triggered Sends
B. Dynamic Content
C. HTML Paste Emails
D. SMS Sends - Answers A. Triggered Sends
B. Dynamic Content
Northern Trail Outfitters wants to automate data feeds into Marketing Cloud, and are trying to set up
a data import activities that kick off automatically once a file is placed on the SFTP, on a recurring
nightly basis.
What type of automation could be the driver of this data import setup?
A. Data Event Automation
B. Scheduled Automation
C. API Event Automation
D. File Drop Automation - Answers A. Data Event Automation
Northern Trail Outfitters has several files used for daily email sends. These files arrive from a data
warehouse and are sent to the Enhanced SFTP site. The files need to be imported into Marketing
Cloud as soon as they arrive to ensure near real-time engagement. The arrival time of the files vary by
several hours from day-to-day.
What tool should be used to import the files?
A. Contact Builder Import Automation
B. Automation Studio Scheduled Automation
C. Automation Studio File Drop Automation
D. Journey Builder Contact Automation - Answers C. Automation Studio File Drop Automation
Northern Trail Outfitters stores Last Name in a data extension.
, How should the text field be defined?
A. String (100)
B. Char(100)
C. Text(100)
D. VarChar(100) - Answers C. Text(100)
Northern Trail Outfitters is expanding its current welcome series to a global audience. They plan on
using Journey Builder to automate the campaign.
What functionality is required to implement the campaign?
A. Automation Studio
B. Audiences
C. Attributes
D. Data Extensions - Answers A. Automation Studio
During the holiday season, Northern Trail Outfitters wants to send out receipt-based emails
automatically as soon as a transaction completes, regardless of subscriber opt-in status.
How could this be accomplished?
A. Automation Studio and Transactional Send Classifications
B. Journey Builder and Marketing Send Classifications
C. Triggered Sends and Transactional Send Classifications
D. Email Studio batch sends and Marketing Send Classifications - Answers C. Triggered Sends and
Transactional Send Classifications
A marketer is trying to configure a new fil drop automation, but the folder is displayed as "In use/"
and it cannot be selected.
How could the marketer update the configuration to fit their process?
A. Change the extension of the file to .csv
B. Change the name of the file on the SFTP
C. Move the folder into the Import Folder
D. Change the File Drop Set Up and Use a FIlename Pattern - Answers D. Change the File Drop Set Up
and Use a FIlename Pattern
Northern Trail Outfitters has three data extensions used for nightly Abandoned Cart Email. They need
to automate the segmentation of data every night by combining data from these three data
extensions.
How could this be accomplished?
A. Data filer Activity
B. File Transfer Activity
C. SQL Query Activity
D. Import File Activity - Answers C. SQL Query Activity
Northern Trail Outfitters is setting up a new business unit. The requirements for the new
implementation have been defined:
- frequent sends of audiences greater than 500K
- daily imports of large data sets, requiring greater import speeds
- triggered send functionality
-API use at a later date are planned
- multiple subscriber data sets
What subscriber solution should be recommended?
A. Data extensions
B. Data Sync
C. Groups
D. Subscriber Lists - Answers A. Data extensions
Why should the length be included for a text field?
A. Otherwise the field will have a length of 1
B. Text fields must be filled