SFMC Consultant 2023 Flashcards
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?
A. All mobile app users will create additional Contacts in Marketing Cloud.
B. User device data is unavailable in Contact Builder for up to 24 hours.
C. Existing users will create additional Contacts in Marketing Cloud.
D. Newly registered users will create additional Contacts in Marketing Cloud.
D. Newly registered users will create additional Contacts in Marketing Cloud.
NTO wants not only to send to their best customers, but also those most likely to buy.
What data will be helpful to send out an email which increases purchase frequency? Choose All that apply
A. last purchase date
B. proximity to store
C. lifetime purchase value
D. conversion rate
A. last purchase date
C. lifetime purchase value
D. conversion rate
Northern Trail Outfitters is noticing a gradual decline in the percentage of conversions per emails sent in their digital marketing campaign. A new initiative is being adopted to reverse the trend
What action should be taken to increase subscriber engagement?
Choose 2 answers
A. Increase volume of emails to a wider audience.
B. Increase the use of dynamic content in emails.
C. Adopt a Cart Abandonment Email Campaign.
D. Introduce more identity verification steps in check out process.
B. Increase the use of dynamic content in emails.
C. Adopt a Cart Abandonment Email Campaign.
f I want to introduce a new line of footwear. I am excluding anyone who does not have shoe as an attribute listed in their preference center. I plan to send the emails daily. After a short time, I notice many people updating their preferences, and less emails are going out.
What is the issue causing less emails to go out? Select one.
A. High Watermark if journey builder
B. Preference center is too strict C. Deliverability issues on account D. Email frequency too high
A. High Watermark if journey builder
A customer frequently holds seminars and other events to interface with their customers. They plan to do the following:
- Use SmartCapture forms to write data into event registration data extensions.
- Cross-reference the records in each registration data extension with corresponding invitation email
sends. - Send a follow-up email to customers who click on the registration link in the invitation email, but do not
complete registration.
Which skill is needed to build an efficient solution?
A. AMPscript
B. SQL
C. HTML
D. CSS
A. AMPscript
A company collects subscriptions on its website. It does the following:
- Compiles that subscription list in a database in the website Content Management System (CMS).
- Posts this encrypted list to Marketing Cloud nightly at 11 p.m.
- Uses Marketing Cloud as the database of record.
- Sends up to five emails a week based on subscriber engagement with prior sends.
Which automation sequence (excluding waits) should cover these requirements?
A. File Transfer > Import File > Measures > Send Email
B. File Transfer > Import File > SQL Query > Send Email
C. File Transfer > SQL Query > Measures > Send Email
D. File Transfer > Data Extract > Filters > Send Email
B. File Transfer > Import File > SQL Query > Send Email
Which data object should be used in conjunction with data extensions to create an opt- down strategy for customers?
A. Profile attributes
B. Preference attributes
C. Publication Lists
D. Preference Lists
C. Publication Lists
What are two ways Contact builder can alter the data in Data Extensions?
A. Add Single Record
B. Extract Data
C. Clear Records
A. Add Single Record
C. Clear Records
A customer wants to automate the process of sending a series of welcome emails based on the Subscriber’s data. Emails should be sent weekly for up to five weeks. If a subscriber makes a purchase, they should stop receiving welcome emails. A Boolean flag should be set in the data extension if the subscriber makes it through the welcome series.
Which steps should be used to accomplish this in Journey Builder?
A. Define Goal, Send Email, Wait, Decision Split
B. Random Split, Send Email, Wait, Define Goal
C. Define Goal, Update Contact Data, Send Email, Wait
D. Update Contact Data, Wait, Send Email, Join
C. Define Goal, Update Contact Data, Send Email, Wait
Northern Trail Outfitters wants to know the number of Contacts in their account. This information needs to be emailed to their Chief Marketing Officer on a weekly basis.
What could be configured to meet this request?
A. Configure the Contact Extract Activity in Automation Studio
B. Query the _Subscriber Data View and Extract it weekly
C. Query the _Contact Data View and transfer it weekly
D. Schedule the Contacts Counts Standard Report
D. Schedule the Contacts Counts Standard Report
How do I set up an individual who manages Marketing Cloud operations across channels, mobile, and social? Choose two.
A. Marketing Channel Manager Role
B. Regional or Local Administrator Role
C. Marketing Cloud Administrator Role D. Email marketing manager role
A. Marketing Channel Manager Role
C. Marketing Cloud Administrator Role D. Email marketing manager role
A customer wants to send a quarterly reengagement email to subscribers who have NOT opened in the previous three months. The customer’s plans are to:
1. Use an existing Paste HTML email for the first send.
2. Make only minor changes to the email creative for future sends.
3. Send to the subscriber list.
4. Deploy emails manually for now, but possibly automate in the future.
Which send method should be used?
A. Guided Send
B. Triggered Send
C. Send Flow Activity
D. Send Email Activity
C. Send Flow Activity
The Northern Trail Outfitters’ (NTO) marketing team is launching a new email campaign. NTO’s Email Specialist wants to perform quality assurance checks on the email prior to send using the Send Preview functionality.
Which three items does Preview and Test check for in an email message? Choose 3 answers
A. Correct syntax is used on any AMPscript in the email’s code.
B. Personalization strings map to attributes or data extension fields.
C. Grammar and spelling in the email text is correct.
D. Each content block specified in a dynamic content rule exists.
E. Words or phrases used may trigger spam filters.
A. Correct syntax is used on any AMPscript in the email’s code.
B. Personalization strings map to attributes or data extension fields.
D. Each content block specified in a dynamic content rule exists.
A customer has an email newsletter to send out, but wants to deliver it with a targeted message for customers within a specified age range. These data have been defined in attributes from a sign-up landing page.
How should the customer individualize the email content?
A. Personalization Strings
B. Substitution Strings
C. Dynamic Content Areas
D. Guide Template Language
C. Dynamic Content Areas
Northern Trail Outfitters wants to send special discount offer to engaged customers on their email list. What should be resolved prior to generating the audience?
A. What the offer will be
B. When to send the email
C. Who the offer come from
D. How to determine engagement
A. What the offer will be
A customer has three data extensions that need to be added to Contact Builder
- Customers contains customer information
- Orders contains order information
- Products contains product information
How should these data extensions be linked within an Attribute Group? Choose 2
A. Customer Data <one-to-> Customers <one-to-> Orders <one-to-> Products
B. Customer Data <one-to-> Customers <one-to-> Orders <one-to-> Products
C. Customer Data <one-to-> Customers <one-to-> Orders <one-to-> Products
D. Customer Data <one-to-> Products <one-to-> Orders <one-to-> Customers</one-to-></one-to-></one-to-></one-to-></one-to-></one-to-></one-to-></one-to-></one-to-></one-to-></one-to-></one-to->
B. Customer Data <one-to-> Customers <one-to-> Orders <one-to-> Products</one-to-></one-to-></one-to->
D. Customer Data <one-to-> Products <one-to-> Orders <one-to-> Customers</one-to-></one-to-></one-to->
A customer wants to display a subscriber’s first name and the date of send in its monthly newsletter, subscriber first name data is stored in data extension that won’t be used in the send definition.
Which option should be in this scenario?
A. Personalization strings
B. Guide Template Language
C. SQL Query
D. AMPscript
D. AMPscript
A customer is interested in designing a solution to ensure that subscribers only receive categories of emails that they want to receive. The built-in subscription center will be used as part of the solution.
Which feature should be utilised to make this happen?
A. Publication Lists
B. Subscriber Keys
C. Profile Center
D. Send Logging
A. Publication Lists
Northern Trail Outfitters wants to include a ‘view online’ link in an email template to enable users to view a web page version of the email.
Which personalization string should they include as the href attribute in the link?
A. %%view_as_webpage%%
B. %%view_email_url%%
C. %%vawp%%
D. %%view_online%%
A. %%view_as_webpage%%
NTO has to import a file that will be different every time. What method should be used?
A. Update
B. Overwrite
C. Add and Update D. Add Only
B. Overwrite
Northern Trail Outfitters recently upgraded their preference center to allow customers to indicate which products they are interested in and to have the ability to opt up and down in send volume. They would like to configure the Delivery Options in a Journey Builder Email Activity to take these new data points into account.
Which two options could allow them to meet the requirement? Choose 2 answers
A. Suppression List
B. Publication List
C. Auto-Suppression List
D. Domain Exclusion
A. Suppression List
B. Publication List
A retail company does business in both the United States and Canada. They have a loyalty program in
which a customer can enroll. The company will provide a pre-segmented customer file, per campaign, which has a “Version” data field indicating the type of email the customer is to receive.
Which two questions should be asked to determine a data/segmentation strategy?
Choose 2 answers
A. Will customers be able to sign up for the loyalty program at the store?
B. Is the purpose of these emails for acquisition or retention or transactional?
C. Will multiple languages be used, with a “From Name” lookup table needed?
D. Will version values/meanings change, precluding reusable AMPscript?
C. Will multiple languages be used, with a “From Name” lookup table needed?
D. Will version values/meanings change, precluding reusable AMPscript?
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?
A. Salesforce Data Entry, SQL Query Activity, Task Activity
B. Scheduled Automation, SQL Query Activity; Data Extension Entry, Task Activity
C. API Event Entry, SQL Query Activity, Task Activity
D. Scheduled Automation, Filter Activity; Data Extension Entry, Contact Activity
B. Scheduled Automation, SQL Query Activity; Data Extension Entry, Task Activity
A customer manages their field technicians in Salesforce CRM connected to Marketing Cloud. Once an appointment with a contact is scheduled for the technician through CRM, the notification message should be sent to the contact informing them about the scheduled visit date. When the notification is sent the “Confirmation sent” checkbox on the appointment record should be updated in CRM.
All appointments scheduled on a given day will have their status updated in CRM at the end of business hours. The Appointment object does not have a direct relationship with the contact.
What solution would a consultant recommend to address this use case?
A. Configure journey with Data Extension entry source; use Automation Studio activities to refresh the audience and Journey Builder activities to send notification and update CRM record(s)
B. Configure journey with API Event entry source, Process Builder to trigger event; use Journey Builder activities to send notification and update CRM record(s)
C. Configure Salesforce Send with Salesforce data extension, using Automation Studio activities to refresh the audience; send notification and SSJS activity to update CRM record(s)
D. Configure journey with Salesforce Data entry source; use Journey Builder activities to send notification and update CRM record(s)
B. Configure journey with API Event entry source, Process Builder to trigger event; use Journey Builder activities to send notification and update CRM record(s)