Salesforce Certified Marketing Cloud ConsultantSFMCExam (SP25) Questions and Answers
Northern Trail Outfitters continually adds rows for subscribers to a Data Extension via API, populating subscribers who should receive a monthly payment reminder that day. They want to use Journey Builder to send the payment reminder emails.
What would be required to process the correct subscribers?
A B2B customer has customized journeys they want to use for several key accounts they are trying to sell into.
How could Marketing Cloud Connect be used to initiate these sends when contacts for select accounts are created?
Northern Trail Outfitters is using Journey Builder to send emails to loyalty members based on recent activity. They anticipate that approximately half of their contacts will meet the entry criteria for their journey.
How should they configure their entry source?
Northern Trail Outfitters wants to enable Sales Cloud users to manually create a segment of both lead and contact records that can be targeted through the Send Flow in Content Builder.
What should a consultant recommend for segmentation?
Northern Trail Outfitters wants to control what content is available to certain users and business units. They also want to control what is allowed to be edited and ensure those edits are reviewed prior to being changed.
What should be implemented to achieve these goals?
A customer wants to create a mobile app that requires users to log in or register before accessing their data. 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?
Scenario: NTO is creating a birthday journey and wants to divert contacts who have redeemed a promotional code before sending reminder emails on the 15th and 20th of each month. The transactional information is stored in a separate data extension from the journey's entry source. They need to compare the customer number field between the journey source and transaction data extensions.
Which activity would they use to accomplish this?
Northern Trail Outfitters has recently configured MobileConnect and wants to perform single send-outs from within MobileConnect using data extensions that contain automatically refreshed segments.
Which two fields would need to be added to enable these data extensions for sending? (Choose 2 answers)
Scenario: NTO has configured Reply Mail Management (RMM) to handle manual unsubscribe requests. However, customers are still receiving marketing emails despite sending unsubscribe phrases like "take me off your list" or "opt out".
How could this behavior be corrected?
A consultant explains how a sending domain differs from a customer's primary domain. The customer is evaluating their options around configuring their domain.
Which two questions should their IT team be asked? (Choose 2 answers)
A customer has been having problems with SMS responses getting the default keyword response rather than the appropriate next keyword response.
What are two potential reasons for this unexpected response? (Choose 2 answers)
Northern Trail Outfitters has several business units (BUs) and each BU uses specific data extensions, like Product Information.
How should they configure these data sources?
Northern Trail Outfitters (NTO) has been storing web behavior in a data extension for several years. They have indicated that with several hundred million rows, there has been an impact on performance. NTO indicates they only need to store data from the previous twelve months, which will not exceed eighty million rows.
Which two methods would allow them to utilize a Retention Policy?
Choose 2 answers
Northern Trail Outfitters (NTO) maintains a blog for key outdoor enthusiast influencers to use in sharing their experiences with NTO equipment and the outdoors. NTO also sends out a weekly email newsletter, and they want to include links to the latest blog entries as part of the newsletter.
Which two solutions could pull in the RSS feed at the time of send? (Choose 2 answers)
Northern Trail Outfitters wants to query Marketing Cloud for send data across SMS, Push, and Email.
What would a consultant recommend?
Northern Trail Outfitters (NTO) wants to send out a communication to subscribers who have not made a purchase in the last six months. Customers are often opted into more than one messaging channel. NTO would like to be able to communicate the same message across all channels.
Which flow would meet their needs?
A customer has a business requirement to exclude email addresses of certain contacts in their loyalty program from sends with several sender profiles. These contacts are dynamically identified with the help of the SQL query on a daily basis.
What solution should be recommended to automate exclusion of the identified email addresses from all future sends that use specific sender profiles?
When Northern Trail Outfitters acquires a new customer, it would like to send a series of welcome messages on behalf of the brand with an optimized send time. New customers will be sent to Marketing Cloud via an hourly batch file drop.
Which solution should the consultant recommend?
Northern Trail Outfitters wants to send an email to website visitors who add items to their cart but fail to make a purchase. The email will include a list of products they added to their shopping cart.
A sendable data extension contains the contact info and a session ID for each subscriber who abandoned their cart.
A second data extension contains the session ID and product details (SKU, product name, quantity, price, image URL).
Which feature should be used to display the list of products for each subscriber in this email?
Northern Trail Outfitters sends emails for Password Resets from their web store when requested. An SMS message should be deployed if the password reset email is not sent.
What processes should they utilize to ensure a timely delivery across email and SMS?
Northern Trail Outfitters wants to automate a weekly SMS message to be sent to anyone who has a birthday that week. They have created the Outbound Message in MobileConnect and have a Filtered List created for every contact who provided birth date information.
Which activities would Marketing Cloud use to automate this campaign?
Northern Trail Outfitters wants to send a weekly coupon campaign. They segment their audience using data from several data extensions, which results in an audience size of approximately 200,000 subscribers. They want to send a reminder three days later at the subscribers' optimized send time.
What solution should they use?
Northern Trail Outfitters noticed that clicks are NOT showing up on Contact records in Salesforce.
Which two reasons could be the cause? (Choose 2 answers)
Northern Trail Outfitters wants to implement a Welcome email. New subscribers signing up on their website should receive the email promptly. They are utilizing Marketing Cloud Connect to connect Sales Cloud and Marketing Cloud.
Which solution should capture the new subscribers?
Northern Trail Outfitters has a customer login page on their website and wants to use Marketing Cloud to send an email to customers who need to reset their password. The email needs to be sent as quickly as possible. Their web server should receive a notification when the email is sent.
Which solution should they use?
Northern Trail Outfitters uses a Salesforce Data Entry Source in their Journey that injects Salesforce Orders when they are either created or updated with a status of New, Currently Knitting, Shipped, and Complete.
Their Journey works when orders are created, but they noticed it does not inject customers when their status is updated.
What could be causing this?
Northern Trail Outfitters' account is configured with Multi-Org to leverage two Salesforce CRM accounts. In the Cloud Kicks business unit they want to disconnect the sandbox instance and connect the production instance.
What additional configuration changes should they make?
A customer wants to capture and categorize email Not Sent events and begin identifying trends. They want to keep the data in Marketing Cloud and run queries against the dataset. The customer created a data extension to receive the information.
Which order of Automation Studio activities should be recommended?
Northern Trail Outfitters wants to build an abandoned cart journey which includes a Decision Split that evaluates if a customer has made a purchase after they enter the journey. Customer data is stored in a master data extension and purchase data is stored in a second data extension.
Which two steps should they include to accomplish this journey?
Northern Trail Outfitters received an email about reaching API limits within Salesforce and they think this is caused by the integrated Marketing Cloud account.
Which two types of API calls are counted against the rolling 24-hour limit? (Choose 2 answers)
For security reasons, Northern Trail Outfitters indicates they cannot store PII directly within their Marketing Cloud account. They are considering implementing Tokenized Sending to pull PII from their data warehouse at send time. They indicate they send several large, time-sensitive emails per year.
Which two considerations should be made about Tokenized Sending? (Choose 2 answers)
Northern Trail Outfitters (NTO) wants to use Marketing Cloud to gather customer feedback. If a customer indicates they are unhappy with the service they have received, NTO wants a new case to be created in Service Cloud. NTO is unsure of what is possible within Marketing Cloud but would like to use as much native functionality as possible.
What approach would a consultant recommend?
Northern Trail Outfitters (NTO) imports a file daily into Marketing Cloud of customers who have bought a tent from their website. They want to set up a month-long welcome Journey that sends emails specific to the purchase, such as the type of tent, recommended accessories, and care tips at different points throughout the Journey.
NTO also recognizes that due to their pricing strategy, customers may purchase more than one tent within a month.
What type of data should be used in the Decision Splits in their Journey to make sure the choices reflect the correct tent?
Which customers would benefit most from purchasing a Sender Authentication Package (SAP)?
A customer is using Marketing Cloud Connect but not sending tracking back to Sales Cloud. They want to create a Task on Contact and Lead records for follow-up when someone has not opened five emails in a row.
Which activities could be used to fulfill this requirement?
Scenario:
Northern Trail Outfitters (NTO) uses the SAP domain comms.nto.com and has just opened an office in Australia. They have created a business unit for their new office and want to use the domain comms.nto.com.au to send emails to their Australian customers.
What would be required to enable sending emails from their new domain without impacting deliverability?
Northern Trail Outfitters is using a Salesforce entry event in a Journey to send SMS to contacts located in the United States. They notice new contacts are not receiving messages, and the mobile number in the Salesforce Entry Data Extension was missing the country code.
How could they resolve this issue?
Northern Trail Outfitters (NTO) stores customer purchase data in an external system. NTO ingests this data into Marketing Cloud through a file drop automation. The automation contains an import activity which overwrites a staging data extension, as well as an SQL Query activity which brings this data into a sendable data extension.
NTO's marketing manager wants to be informed if more than 1,000 records are ever imported through this automation and would also like to prevent the sendable data extension from being updated that day.
Which solution is appropriate in this situation?
Northern Trail Outfitters wants to create a query to populate a data extension with email subscribers who belong to a specific publication list.
Which Data View could they use to achieve this?
A real estate agency wants to send out a biweekly newsletter with the list of properties for all new contacts added to a newsletter campaign in their Salesforce CRM. The journey consists of an initial message with property listings and a follow-up to those who have engaged with the content.
The rules around which properties are matched to the contact depend on agent assigned as a contact owner, other agents who might have interacted with the contact, and contact's property interest. The data model has a relationship between Contact → Person Account → Real Estate Agent → Property objects and all of those are available in CRM as well as synchronized to Marketing Cloud.
What solution should be recommended for execution efficiency?
Northern Trail Outfitters has started the process of integrating its Marketing Cloud account and Sales Cloud org through Marketing Cloud Connect.
Which configuration should be utilized for the API user created in Marketing Cloud?
Northern Trail Outfitters (NTO) wants to implement an abandon cart journey. The data for the journey exists in three separate data extensions (DE).
The first DE is populated by web analytics data and does not contain a Subscriber Key or Email Address value.
A Customer Reference DE is updated daily and holds subscriber information.
The third DE is populated by a file sent to the SFTP after five days if the customer has not purchased the abandoned items.
The third DE will be used in the journey for a decision split, and it does not contain a Subscriber Key or Email Address.
If the web analytics file is empty, NTO does not want the automation to finish running.
Which order of activities should be used to fulfill this requirement?
A school corporation uses one contact per parent/child combination, updating the email address based on who they are sending to. However, they would like to pull data on which email addresses receive which emails.
What functionality could be used to accomplish this?
Northern Trail Outfitters is looking to personalize their SMS messages.
Which data source is supported to personalize messages?
Northern Trail Outfitters wants to monitor available coupon codes and send a notification to their email specialist instructing them to request more codes if the available coupon count falls below 500 available codes.
Which two activities would be used in an automation? (Choose 2 answers)
Northern Trail Outfitters (NTO) is launching a new subsidiary brand, Cloud Kicks, within the next six months. Cloud Kicks anticipates sending approximately 50,000 emails per month from a child business unit. NTO will execute a large campaign announcing and associating itself with Cloud Kicks as part of the brand kickoff and is comfortable sharing digital properties with them. Cloud Kicks wants to utilize a custom sending domain, but deliverability is a primary concern.
What approach should be recommended?
A marketer wants to capture open-ended feedback from customers via SMS and write it to a Data Extension.
How could MobileConnect be used to accomplish this?
Northern Trail Outfitters is migrating from a legacy emailing tool to Marketing Cloud. As part of the migration, they have to go through a security review. Their data privacy team has made it clear that the data in the sandbox should never be mixed with data in production during testing cycles.
What recommendation would a consultant provide on the architecture to fulfill this requirement?