SFMC Email Specialist (exam 2)

When building an email audience, a marketer first runs a query to update a data extension referenced in the audience query. Which configuration should be used to ensure the exclusion is updated before the audience query runs?. In the step with the two SQL activities, place a wait step between them. Place the audience SQL Query Activity in a step after the exclusion SQL Query Activity. Place the audience SQL Query Activity below the exclusion SQL Query Activity.

Northern Trail Outfitters (NTO) receives a daily file drop of customers who have made recent purchases. NTO would like to send out a thank you email the first time they Show up in the file drop. How should Journey Builder be configured to meet this requirement?. Configure Journey Settings to 'allow no re-entry’. Configure Journey Email Send to dedupe on email address. Configure Journey Entry Event to 'allow no re-entry.'.

Northern trail Outfitters’ marketing department wants to review last year’s holiday engagement to this year’s engagement. What should they use to access the historical engagement data?. SQL activity using data views. Audit Trail extract. Tracking Data extract.

A marketer needs to send emails to all 20 members of the creative team for proofing as a part of an email campaign. Which Preview & Test Content Personalization option should be used?. Based on Recipient test Data Extension. Based on Subscriber Preview List or Data Extension. Based on Preview.

Northern Trail Outfitters (NTO) wants to test Einstein Recommendations against the company's static product recommendations in a product return confirmation email. Next, NTO needs to evaluate the results and choose the winning option for future confirmations. Which journey type is best suited to run this test?. Single Send. Multi-Step. Transactional Send.

A global marketing team has created an email using Content Builder Approvals and shared it with multiple business units in their Enterprise. Even though the email was approved, additional changes are needed. What is the first action that should be taken to make the edits?. Unshare the email. Cancel send using email. Update email approval status.

Northern Trail Outfitters wants to use a specific IP address and a subdomain of order subdomain for all of its transactional emails. What should be configured to accomplish this request?. Delivery Profile. Send Classification. Sender Profile.

Northern Trail Outfitters (NTO) needs a quick listing of all email sends from the past calendar year across all business units. It should include basic metrics for each send. Which out-of-the-box report provides what NTO needs?. Email Sends by User. Email Performance Over Time. Account Send Summary.

Northern Trail Outfitters historically received a bulk data file from a vendor once per day in its Marketing Cloud SFTP. The vendor is updating its sending cadence and will be delivering files over approximately eight hours throughout the day. The files will maintain the same naming convention and include a timestamp. Which update should be implemented to the automation to process the files as they are received while minimizing rework?. Implement an API to start an automation with every file transfer. Replace the Schedule with File Drop and use a filename pattern. Replicate the automation and schedule them to execute every eight hours.

The marketing team at a bank needs to receive a file of all subscribers who were sent payment reminder emails and opened them each week. The file needs to be encrypted and placed on the bank's external SFTP. How should the scheduled automation be configured to achieve this?. Filter Activity > File Transfer Activity > Data Extract Activity. Filter Activity > SQL Query Activity > File Transfer Activity. SQL Query Activity > Data Extract Activity > File Transfer Activity.

Northern Trail Outfitters just launched a new line of tents and sent a targeted email campaign to introduce the product to its customers. Where in Email Studio could they see the performance summary of the recent email send?. Send Performance tab. Overview tab within Tracking. Job Links tab within Tracking.

An email marketing team is setting up a campaign to message customers who register for an event. The registration data is being gathered in another system and will be passed to Marketing Cloud daily, and updates made to the customers' registration information will be reflected in the same file. How should the import of event registration data be configured?. Use the Import Activity to overwrite the records in the data extension. Use the Import Wizard to add new records into the data extension. Use the Import Wizard to overwrite the records in the data extension.

Northern Trail Outfitters wants to utilize an Amazon s3 bucket to import data into Marketing Cloud Data Extensions. What should be used to achieve this?. Ingest API. Import Wizard. Import Activity.

Northern Trail Outfitters (NTO) has expanded into 15 new countries and needs to send localized content. NTO works with an agency to provide the translations, but they lack email developer resources. What should NTO do to create and send localized content at scale?. Leverage templates with AMP script. Leverage Enhanced Dynamic Content. Leverage Multilingual Content Blocks.

A marketing manager notices emails clustered with images that are inconsistent with branding guidelines. Which step should they take to restrict the types of content within the content slot?. Under user permissions, select limited template access. Configure Content Blocks to only be usable within approved templates. Configure restrictions within a Content Area for approval block types.

The CMO at Northern Trail Outfitter (NTO) has tasked the marketer with tracking the performance of NTO's welcome and post purchase journeys. Which action should the marketer take to evaluate journey performance?. Define a goal for each journey. Review opens and clicks activity summaries. Export the journey email analytics.

An insurance company has launched a new campaign to target Individuals between 64 and 65 that are not yet enrolled and are opted into email. All subscriber data is stored in one data extension. How should the marketer use low-code to create this segment?. Write a query to create a filtered data extension. Create a data filter on the data extension. Filter the .csv file before import.

Northern trail Outfitters is hiring a third-party vendor to host a web page tied to a promotional sweepstake. The marketing manager would like an email sent from journey as soon as the subscriber submits the form. What should be used to enter this subscriber into a journey?. Contact Event Entry Source. CloudPages Entry Source. API Event Entry Source.

Northern Trail Outfitters (NTO) is using Datorama Reports for Marketing Cloud to report on email and journey performance. Which preconfigured dashboard should NTO review to get an idea of which journeys are performing the best?. Journey Performance by Email Dashboard. Email Performance Dashboard. Email and Journey Overview Dashboard.

Northern Trail Outfitters (NTO) has subscriber’s opt-in to its marketing program via email or SMS. What should NTO configure for its welcome series in Journey Builder to honor the opt-in communication method?. Ensure source channel Is available in subscriber data. Create one Entry Source for each messaging channel. Send both email and SMS to ensure subscribers get NTO's messages.

Northern Trail Outfitters (NTO) is interested in exploring its large volume of send data. NTO wants to dynamically filter, sort, and group the data in one view but is not comfortable writing SQL queries. Which tool should NTO use?. Email Performance Over Time Report. Filter Activity in Automation Studio. Pivot table in Datorama Reports.

The marketing team wants to test various path within journey based on parameters to assess the effectives of a new email campaign. Which tool should be used?. Einstain Engagement Activities. Path Optimizer. A/B Testing.

A marketer is using Preview and Test sending to check that content is ready for an upcoming campaign and notices the Send Log Data Extension is not updating. What is the reason records are NOT being recorded?. A subscriber was not selected in the Subscriber Preview tab. Test sends are rot recorded on the Send Log Data Extension. The send exceeded the maximum test send threshold.

Northern Trail Outfitters wants to report on subscribers who did not receive emails that were included in the sending audience. Which tool should provide a list of subscribers who didn't receive the expected emails?. Not Sent Tracking Extract. _sent Dataview. Subscribers Not Sent To* report.

A healthcare marketer would like an email sent to patients as soon as they request a password reset for their account. Which journey type is the best solution for the marketer to set up?. Multi-Step Journey. Single Send Journey. Transactional Send Journey.

A marketer is asked to create a sendable data extension from various tables including orders, subscribers, and product line items. The resulting data extension will be used as an entry source for a journey. Which tool should help create this table?. Automation Studio. Data Designer. Audience Studio.

Northern Trail Outfitters is looking at solutions that provide warnings/advice automatically about Email Sends using Artificial Intelligence. Which standard tool best does this?. Einstein Copy Insights. Einstein Email Recommendations. Einstein Messaging Insights.

Northern Trail Outfitters third-party point-of-sale software order information in batches of large files. The timing varies throughout the day. Which feature should be used to accommodate this setup?. Triggered Automation. Scheduled Automation. Wait Activity.

The marketer for Northern Trail Outfitters wants to review the tone of subject lines and the effect on engagement for recent sends. Which tool should supply insights into the tone of subject lines?. Einstein Recommendations. Einstein Messaging Insights. Einstein Copy Insights.

An email marketer is creating an email to promote the new Northern trail Outfitters mobile app. Which text should be used for the call-to-action button to drive the most engagement?. Download now. Download out new mobile app here. Out new mobile app.

Leadership at Northern Trail Outfitters wants to see a dashboard showing the success rate of customers that have been through a Welcome Series Journey in the last 7 days. Where should they find this dashboard?. Journey Builder - Journey History. Datorama Reports - Journey Performance. Reports - Journey Engagement.

Northern Trail Outfitters wants multiple business units to access the same data extension within its Enterprise 2.0 account. Where should the data extension reside to achieve this goal?. In the Synchronized Data Extensions folder. In the Data Extensions folder with sharing enabled. In the Shared Data Extensions folder.

Northern Trail Outfitters (NTO) wants to implement a single-audience drip campaign and then, ever time, create new version with tests of random audience splits with different messages. Which tool should NTO use to accomplish these iterative tests?. Contact Builder. Automation Studio. Journey Builder.

Northern Trail Outfitter (NTO) is warming up a new IP address primarily for a new product line. Initially, NTO wants to move some of its lower-volume transactional sends onto this new IP. Where should NTO update the IP configured for these sends?. From Address Management. Delivery Profile. Sender Profile.

A marketer has scheduled an email that was approved in Content Builder Approvals by their manager. The marketer then receives a message from their manager that changes are needed and an email approval has been withdrawn. What should happen with the scheduled send, if no other action is taken?. The Send is paused unit is approved again. The send is canceled when the approval is withdrawn. The originally approved version of the email will be sent.

The data team at Northern Trail Outfitters (NTO) has configured a data extension that contains all customer transactions within the last 90 days. NTO’s marketing team would like to target customers who have purchased a camping tent or foldout camper in the last week; however, for this campaign, they would like to exclude anyone who has a ‘silver status’. Which three tools should be used to segment this data?. SQL Query, Filter Definition, Journey Builder Entry Source. Journey Builder Entry Source, Filter Definition, Segment Builder. SQL Query, Decision Split, Data Designer.

Northern Trail Outfitters (NTO) receives a complaint from a long-time customer who claims that, despite providing an updated email address, they are still receiving emails at an old address. NTO confirms that the customer's new email address is stored in the target data extension. What is preventing the customer from receiving emails at their new address?. The new email address is from an unsupported domain. The email address has not been updated in All Subscribers. The customer has not opted in again with the new address.

Northern Trail Outfitters wants to monitor customer status while they flow through a post-purchase journey. Which configuration is required to make decisions on this data? The status data is connected to the contact in an attribute group. The Update Contact Activity is used to make status updates. The Update Contact Activity Is used to make status updates. The entry sources data extension has a primary key and subscriber key.

Northern Trail Outfitters (NTO) wants to manage subscriber preferences at the communication theme level. NTO'S subscribers are stored in data extensions. Which Marketing Cloud feature should be used to achieve this?. Publication Lists. List Unsubscribes. Journey Builder Sends.

Northern TV-ail Outfitters (NTO) sent a targeted email to 1,000 customers, but the actual number series was 10% less. In troubleshooting the issue, NTO noticed that 100 email addresses contained a typo of "gmail.com instead of "gmail.com". Which Marketing Cloud feature prevented emails from being sent to an invalid domain?. Bounce Mail Management. Auto-Suppression Lists. List Detective.

Northern Trail Outfitters (NTO) has a promotional email intended to be sent to only its high-value customers. NTO wants to implement additional-guardrails to prevent sending the email to more subscribers than intended. Which Activity should be configured in Automation Studio to help?. Send Email. Verification. Wait.

Northern Trail Outfitters is redesigning its brand guidelines and wants to ensure its emails are accessible. Which best practice should the email designer follow to meet accessibility standards?. Minimize whitespace. Build image-based emails. Use contrasting colors.

A marketer is preparing to send out the weekly newsletter, but they're unable to see the email address that they would like to send from. Where should a marketer go to see a list of all email addresses and domains that are verified for sending?. From Address Management. Send Classifications. Domain SSL Certificates.

A marketer typically sends to a filtered data extension that contains their primary audience. They need to target only a portion of this population for an upcoming send. What should they do to further segment their audience?. Copy the filtered data extension and add additional filter criteria. Use the Split option to temporarily add additional filter criteria. Copy the data filter and build a new data extension with additional filter criteria.

A marketer wants to store all the attributes for a triggered send within a data extension. Which configuration is required when creating the data extension for this triggered send information?. Create from template and choose triggered Send Data Extension template. Include Subscriber key and Email address field as primary key. Select the ‘Use for triggered send' checkbox.

Northern Trail Outfitter (NTO) wants to use Marketing Cloud's Subscription Center to allow subscribers to control which types of emails do NOT want to receive. NTO's audiences are contained in data extensions. Which object should be used?. Publication List. Suppression Lists. Exclusion Lists.

Northern Trail Outfitters (NTO) wants to move from a batch process to a real-time process for injecting Contacts into journeys. Which Journey Builder Entry Source should NTO use?. Data Extension. API Event. Date Based Event.

The marketing team wants to ensure each email whitin a journey is sent when the subscriber is most likely to engage with the campaign. What should be configured in the journey so that an email is sent at the best time?. Wait By Attribute before each email. STO activity before each email. Send throttling window configured in each email.

Northern Trail Outfitters has three data extensions used for a 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?. SQL Query Activity. Data Filter Activity. Import File Activity.

Northern Trail Outfitters (NTO) is building a drip campaign in Journey Builder. NTO wants to send emails at the best time for each subscriber. Which activity should be placed before each email activity?. Einstein STO. Einstein Engagement Frequency. Path Optimizer.

Northern Trail Outfitters wants to improve email open rates to increase subscriber engagement and improve deliverability. What action should they take to increase open rates?. Use images, not text, to improve email look and branding. Include relevant preheader text in every email. Add a clear, brief, and urgent call-to-action.

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?. Subscriber Key. Primary key. Send Relationship.

A marketer was given a list of subscribers with various HTML or Text email preferences. The marketer wants to keep the send simple and NOT split the audiences into two separate sends. What should be selected during the Email Send flow?. Multi-part MINE. Transactional sender profile. Link Traking.

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?. Scheduled automation. List filter. SQL Query Activity.

A marketer has configured a yearly membership renewal journey. This journey is intended to be used for the foreseeable future. Which contact entry mode should be used?. Re-entry at any time. No re-entry. Re-entry only after exiting.

A digital marketing team noticed an increase in unsubscribes and would like to implement a mechanism as an alternative to unsubscribing from all sends. The team currently uses data extensions for sending emails. Which tool should they use?. Suppression lists. Publication lists. List unsubscribe.

Northern Trail Outfitters manually sent an HTML to subscribers which contains a link to the wrong landing page for campaign. Which option minimizes the impact of this error?. Locate the job under Tracking and update the URL in the job links tab. Send another email to the same subscribers containing the correct link. Update the link in the stored email content and it will be pulled in automatically.

Northern Trail Outfitters 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?. Create filters for each communication type and select the resulting data extensions with the emails during the send. Create a suppression list for each communication type and associate the emails with these suppression lists during the send. Create publication lists for each communication type and associate the emails with these publications lists during the send.

Many Northern Trail Outfitters’ subscribers have purchased from their website and receive transactional messages for order confirmations, shipping notifications, and more. What method should they consider to begin sending commercial marketing messages to subscribers?. Begin adding these subscribers to all marketing data extensions and lists. Launch an automation to collect everyone who received a transactional message yesterday and add them to a welcome series. Add links to subscriber profile centers to opt-in to marketing communications in transactional messages.

A marketing team has switched from the Classic Editor to Content Builder in Email Studio. All images, content blocks, and emails were saved in one folder. How should these saved items be found in Content Builder?. Create folders and move content. Add tags to each piece of content. Filter based on content type.

Northern Trail Outfitters has a new VP of Customer Engagement. They would like certain emails to come directly from the new VP’s email address. What is required to send from the new email address?. Ensure the email address is verified for sending. Create a Delivery Profile with the validated address. Ensure the email address has a valid format.

Northern Trail Outfitters recently sent a re-engagement campaign and were very happy with the results. Delivery rate: 90% Open rate: 8% Click rate: 7.6% What statistic from the send stands out?. Delivery rate. Click-through rate. click-to-open rate.

The Northern Trail Outfitters’ email team is creating a reusable content block for its Deals to Run with campaign. They will cross-promote this campaign in other emails in a single-column content area. This content will have one image, with text below it. How could the email team create one content area and reuse it across other emails using Content Builder without writing any custom HTML?. Create a free form content block. Create an image content block. Create an HTML content block.

Northern Trail Outfitters imports subscriber affinity data to drive dynamic content in marketing emails. The affinity data is delivered every 30 minutes via an SFTP file. They want the most updated affinity data to be used prior to deploying emails. What automation flow should be employed to ensure the most relevant email content?. Schedule > Import file > SQL query. File drop > import file > SQL query. Schedule > file transfer > import file > SQL query.

Northern Trail Outfitters wants to automate the exporting of engagement data for all sends into their data warehouse. Which tool would they use?. Schedule reports configured within tracking. SQL query export of _engagement dataview. Tracking data extracts within 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?. Automation studio and transactional send classification. Journey builder and marketing send classification. Triggered sends and transactional send classifications.

Northern Trail Outfitters 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 in subscriber key. How could they achieve this personalization?. Use the %%_subscriberkey%% string in the email. Using AMPscript to do a lookup(). Use a personalization string from the HTML editor tab.

Northern Trail Outfitters (NTO) creates branded templates for use among its distributed marketing teams. NTO wants the template layouts to be customizable while still using Content Builder’s drag-and-drop functionality. How should NTO create their template?. Populate the template with HTML content blocks. Populate the template with free form content blocks. Populate the template with dynamic content blocks.

A marketer is trying to configure a new file 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?. Change the extension of the file to .csv. Change the name of the file on the SFTP. Change the file drop set up to use a filename pattern.

Northern Trail Outfitters (NTO) is launching a new product and is unsure which features to highlight in the promotion. The marketing team has created two versions of their promotional email to test among NTO’s most engaged customers. Which journey builder feature should allow for the best performing email to be sent to the larger audience?. Einstein Content Selection. Engagement Split. Path Optimizer.

What tool should be used to render personalization strings, AMPscript, and dynamic content in an email message before sending it to a subscriber?. Preview and test. Personalization builder. List detective.

Northern Trail Outfitters wants to automate data feeds into Marketing Cloud, and are trying to set up 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?. File drop automation. API event automation. Scheduled automation.