SFMC Email Specialist Certification
UPDATED ACTUAL Exam Questions and
CORRECT Answers
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 - CORRECT ANSWER - 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 - CORRECT ANSWER - 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 - CORRECT ANSWER - 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 - CORRECT ANSWER - 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 - CORRECT ANSWER - 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 - CORRECT ANSWER - 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 - CORRECT ANSWER -
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 - CORRECT ANSWER - 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 - CORRECT ANSWER - 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 - CORRECT ANSWER - 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 - CORRECT ANSWER - 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.
UPDATED ACTUAL Exam Questions and
CORRECT Answers
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 - CORRECT ANSWER - 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 - CORRECT ANSWER - 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 - CORRECT ANSWER - 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 - CORRECT ANSWER - 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 - CORRECT ANSWER - 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 - CORRECT ANSWER - 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 - CORRECT ANSWER -
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 - CORRECT ANSWER - 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 - CORRECT ANSWER - 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 - CORRECT ANSWER - 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 - CORRECT ANSWER - 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.
