SFMC Email Specialist Certification Exam Actual Questions and Answers with Complete Solution.

SFMC Email Specialist Certification Exam Actual Questions and Answers with Complete Solution. 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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. 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 - ANSWER C. Automation Studio File Drop Automation Northern Trail Outfitters stores Last Name in a data extension.