SFMC Consultant 2023 - Deck B

Question 1

An employee in a customer’s IT department is responsible for maintaining the Login IP Whitelist and SFTP locations in Marketing Cloud. The IT Director has asked that this employee be given the minimum permissions necessary to complete only these tasks.
How should the Consultant configure the IT employee’s account?

A. Administrator role, with all Content and Subscriber permissions disabled
B. Marketing Cloud Security Administrator role with account-wide access
C. Data Manager role with access to only the Parent Business Unit
D. Custom role with limited Administrator permissions enabled

Answer 1

A. Administrator role, with all Content and Subscriber permissions disabled

Question 2

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 two.)

A. Next keyword was not specified on the outbound message.
B. Response contained “stop” in the message content.
C. Responses are not sent within 24 hours of the outbound message.
D. Responses are sent after the 60 minute conversation window.

Answer 2

A. Next keyword was not specified on the outbound message.

D. Responses are sent after the 60 minute conversation window.

Question 3

Northern Trail Outfitters configured Marketing Cloud Connect with their Community Cloud instance and wants to ensure contacts who have not provided consent will only receive transactional communication. This process should be automated based on the change of the HasOptedOutOfEmail field in Community Cloud, which is the consent master. Emails will be sent from both the Marketing Cloud and Community Cloud user interfaces.
What should a consultant consider when fulfilling this requirement?
A. The contact consent status is required to be imported to All Subscribers via API or Automation.
B. The Community Cloud connection only supports Users and not Contacts or Leads.
C. The HasOptedOutOfEmail field should be selected at send time via Marketing Cloud Connect.
D. Transactional and Commercial sends are treated the same by Marketing Cloud Connec

Answer 3

C. The HasOptedOutOfEmail field should be selected at send time via Marketing Cloud Connect.

Question 4

Northern Trail Outfitters stores birthdate on the contact object in the Salesforce CRM. They want to inject the contact into a journey on their birthday.
Which two Journey Builder entry process configurations allow for an injection using the customer’s birthday? (Choose two.)
A. An automation with query activity using Contact object Synchronized Data Extension then Journey Entry Activity
B. Journey Builder Date Based Event using Contact Data related to Synchronized Data Source Attribute Group
C. DMP Entry Event from Audience Studio using Date of Birthday equal to Today Segmentation
D. Salesforce Data Entry event with filter criteria on Contact Object where `Date of Birthday equal to Today’

Answer 4

C. DMP Entry Event from Audience Studio using Date of Birthday equal to Today Segmentation
D. Salesforce Data Entry event with filter criteria on Contact Object where `Date of Birthday equal to Today’

Question 5

A data team wants to automate the sync of Unsubscribes from their enterprise account to their external CRM in one consolidated file. They need to find subscribers in their Marketing Cloud account and their unsubscribe data for child business units.
Which two data views would they use to achieve this? (Choose two.)
A. _Subscribers
B. _Complaint
C. _Unsubscribe
D. _BusinessUnitUnsubscribes

Answer 5

C. _Unsubscribe
D. _BusinessUnitUnsubscribes

Reference: https://help.salesforce.com/articleView? id=sf.mc_as_data_view_businessunitunsubscribes.htm&type=5

Question 6

Northern Trail Outfitters wants to automate the daily segmentation of their master subscriber data extension into smaller data extensions based on subscriber preferences.
Which two Automation Studio activities could they choose from to segment their data into existing data extensions? (Choose two.)
A. Script Activity
B. Refresh Group Activity
C. Publish Audience Activity
D. Query Activity

Answer 6

B. Refresh Group Activity

D. Query Activity

Question 7

A customer asks why the send time values within an email are not being added to a Send Log. Which two actions would successfully write send time variables to their Send Log? (Choose two.)
A. Ensure the values to log exist in the Additional Email Attributes.
B. Match an AMPscript variable name to a Send Log field.
C. Enable send logging to a data extension during send process.
D. Use the WriteToLog() AMPscript function the content.

Answer 7

B. Match an AMPscript variable name to a Send Log field.
C. Enable send logging to a data extension during send process.

Reference: https://help.salesforce.com/articleView?id=000333925&type=1&mode=1

Question 8

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?
A. Salesforce Data Entry Source on the Contact Object
B. Salesforce Campaign Entry Source on the Lead Object
C. Salesforce Data Entry Source on the Account Object
D. Welcome Email Configuration on the Account Object

Answer 8

C. Salesforce Data Entry Source on the Account Object

Question 9

Northern Trail Outfitters has created child business units (BU) for their different regional offices. They want to limit subscriber records by BU, so users who are assigned to a BU can only view and send to Subscriber records in their region. A Profile Attribute named Region' associates a subscriber to a geographical region. How could they ensure subscribers with a matching Region’ Profile Attribute value are available in each BU?
A. Create a list in each BU and add subscribers with a matching Region to the list.
B. Open the Profile Attribute Properties for the Region' Profile Attribute and select the Filter Subscribers by Attribute’ option.
C. Create a measure for each corresponding Region' Profile Attribute and include the measure in a Filtered Data Extension for each BU. D. Select Define Subscriber Filter’ for each BU on the BU Setup page and configure a condition to match the corresponding Profile Attribute.

Answer 9

D. Select `Define Subscriber Filter’ for each BU on the BU Setup page and configure a condition to match the corresponding Profile Attribute.

Question 10

Northern Trail Outfitters wants to set up an automation that imports a file and sends an email to the contacts when the file is dropped on the SFTP. The name of the file will change, though it will always start with thankyou_customers.
How would they set up the Import Activity to know the name of the file?
A. Filename is automatically passed to Import Activity with File Drop Automations
B. Set File Naming Pattern to %%AUTOMATED_FILENAME%%
C. Check the `Use filename from Automation’ checkbox
D. Set File Naming Pattern to %%BASEFILENAME_FROM_TRIGGER%%

Answer 10

D. Set File Naming Pattern to %%BASEFILENAME_FROM_TRIGGER%%

Reference: https://help.salesforce.com/articleView? id=sf.mc_as_ftp_and_triggered_automation_scenario.htm&type=5

Question 11

Northern Trail Outfitters (NTO) uses Campaigns in Sales Cloud to help calculate ROI on marketing
campaigns. They want to automatically display Campaign Member email behavior on the Campaign record for email messages sent to a Campaign through Marketing Cloud Connect. NTO currently uses the Campaign Member Status field to track custom statuses on Campaigns and they do not want to alter it.
Which two recommendations should the consultant make to help meet these requirements? (Choose two.)
A. Create a Process in Process Builder to update a custom field with the values.
B. Configure Campaign Member Integration to map the tracking values.
C. Change the Campaign Member Status fields to correspond to tracking.
D. Use the custom Activity field installed with the Managed Package.

Answer 11

A. Create a Process in Process Builder to update a custom field with the values.

C. Change the Campaign Member Status fields to correspond to tracking.

Question 12

A customer has curated a list of known email addresses belonging to competitors. They want to ensure none of these competitors receive their emails.
What should a consultant recommend?
A. Create an auto-suppression list populated with the known email addresses.
B. Create an exclusion list with the known email addresses.
C. Populate a list using a query to exclude the subscriber key.
D. Create an auto-suppression list populated with subscriber keys.

Answer 12

B. Create an exclusion list with the known email addresses.

Question 13

Northern Trail Outfitters is interested in a solution to automate a process. They currently pull data into a spreadsheet to import into a data extension for sending. The data warehouse can be configured to place a file daily on an SFTP.
Which three questions are relevant to determining a solution? (Choose three.)
A. Does someone need to be notified if an error happens on import?
B. Will the file have more than 5,000 rows?
C. Does the file have demographic data?
D. Is the data file a delta or a historical file?
E. Will the data file be placed on the SFTP at the same time daily?

Answer 13

A. Does someone need to be notified if an error happens on import?

D. Is the data file a delta or a historical file?
E. Will the data file be placed on the SFTP at the same time daily?

Question 14

Northern Trail Outfitters (NTO) wants to implement a cross-channel automated marketing solution that provides real-time messaging on a customer by customer basis. They have limited resources to manage this on their own once the initial implementation has been completed. Which three details should be verified to properly guide a solution they can manage after the initial implementation? (Choose three.)

A. Does NTO have personnel to configure the (sub)domain for sending emails?
B. Is the necessary data currently stored in a centralized location?
C. Does NTO have people with Marketing Cloud skills and/or certifications within the team?
D. Does NTO need a declarative-only approach?
E. What size should the team responsible for the implementation after go-live be?

Answer 14

A. Does NTO have personnel to configure the (sub)domain for sending emails?

C. Does NTO have people with Marketing Cloud skills and/or certifications within the team?

E. What size should the team responsible for the implementation after go-live be?

Question 15

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?
A. Transactional email send with the event notification service response to determine and trigger an API call to an SMS message
B. Multiple path journey with engagement split if password reset link clicked; if link not clicked, then SMS Password Reset activity
C. Triggered send definition, and use API response to determine and send API call to trigger an SMS password reset
D. Triggered send definition and use data extract Not Sent to a data extension then send SMS to those failed sends

Answer 15

A. Transactional email send with the event notification service response to determine and trigger an API call to an SMS message

Question 16

Northern Trail Outfitters wants to connect relational data into their Journey without overloading the entry data.
How should they connect the data?
A. Data Designer
B. Entry Source Data Extension
C. Contact Configuration
D. Data Relationships

Answer 16

B. Entry Source Data Extension

Reference: https://help.salesforce.com/articleView?id=000314015&language=en_US&mode=1&type=1

Question 17

A company is leveraging Marketing Cloud Connect to trigger near real-time communication in Journey Builder via Salesforce Entry Events. They would like to set up another business unit specifically for their new European subsidiary and also leverage Salesforce Entry Events. They want to continue to use one Sales Cloud instance for all regions, but the head of the European marketing team wants to guarantee European customers are never visible to the users of the existing business unit for data privacy reasons, just as they are in Sales Cloud. The integration user in Sales Cloud has the profile “System Administrator”.

What action should the consultant take to accomplish this?
A. Enable the Scope By User setting in Salesforce Integration tab
B. Implement a custom integration to support this requirement
C. Once users are integrated Salesforce Entry Events automatically filter contacts based on Sales Cloud permissions
D. Ensure each business unit has a different Integration User with the relevant roles in Sales Cloud

Answer 17

A. Enable the Scope By User setting in Salesforce Integration tab

Question 18

A new customer requests assistance in selecting a data model that can scale with the brand as it grows. They want a configuration where they can easily add new attributes as needed to their daily CRM imports and use it right away for dynamic content. They would also like to use the data available as referential data in triggered sends for personalization as needed. The customer will send to a minimum of 1,000,000 subscribers.
Which data entry model should meet their needs?
A. Import into a Data Extension
B. Journey Data Source
C. Import into a List
D. API Data Extension Injection

Answer 18

A. Import into a Data Extension

Question 19

Northern Trail Outfitters’ marketing team is made up of a marketing manager, a communications specialist, and a graphic designer. The team is new to Marketing Cloud and has very little coding experience. Currently, they use Excel and VLOOKUP to segment their email audiences and import them into Marketing Cloud.
What solution should be recommended to allow for long-term self-sufficiency in segmentation?
A. Attribute Groups
B. Publication Lists
C. Query Activities
D. Data Filters

Answer 19

D. Data Filters

Question 20

A customer wants to limit the number of emails a subscriber receives to a maximum of one email every 14 days. After the 14-day period, the subscriber is eligible to receive the next message.
What should a consultant recommend to meet these criteria?
A. Query all subscribers from the Sent Data View when creating the send.
B. Create an exclusion data extension populated with the identified subscribers.
C. Create a suppression list populated with the identified subscribers.
D. Import the identified subscribers into a list when creating the send.

Answer 20

A. Query all subscribers from the Sent Data View when creating the send.

Question 21

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?
A. Refresh Mobile Filtered List and Outbound Send
B. Import Mobile Contacts and Outbound Send
C. Import Mobile Contacts and Send SMS
D. Refresh Mobile Filtered List and Send SMS

Answer 21

C. Import Mobile Contacts and Send SMS

Question 22

A customer wants to use Sales Cloud as a system of record for email messages sent from Marketing Cloud; however, the customer only sends from custom objects and cannot use the Contact ID or Lead ID as the Contact Key in Marketing Cloud.
What is the implication of this data model when using Marketing Cloud Connect?
A. The customer will be unable to use synchronized data extensions.
B. Email Sends will fail if the Contact ID or Lead ID is not included.
C. Tracking Data will not be returned to the Sales Cloud email recipient.
D. The customer will be able to use Reports and Campaigns as audiences.

Answer 22

B. Email Sends will fail if the Contact ID or Lead ID is not included.

Reference: https://help.salesforce.com/articleView?id=sf.mc_co_salesforce_data_extensions.htm&type=5

Question 23

Northern Trail Outfitters (NTO) imports a file daily into Marketing Cloud of customers who have bought a tent from their website that day. They want to set up a month-long welcome Journey which sends emails specific to the purchase such as the type of tent, the available accessories for the tent, and care of the tent at different points throughout the Journey. NTO also recognizes that due to their competitive prices, they have had customers 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?
A. Entry Data
B. Journey Data
C. Salesforce Data
D. Contact Data

Answer 23

B. Journey Data

Reference: https://help.salesforce.com/articleView?id=sf.mc_jb_journey_settings.htm&type=5

Question 24

Northern Trail Outfitters sends a monthly loyalty balance email to inform members of their current points balance. Emails are segmented based on loyalty status, and no segment should contain more than 2500 contacts for any send.
What should be used to prevent emails from being sent if they exceed 2500 contacts?
A. Query Activity
B. Script Activity
C. Stop Activity
D. Verification Activity

Answer 24

D. Verification Activity

Question 25

Northern Trail Outfitters wants to improve their personalization of goods and services using an expansive set of data.
What product facilitates the sharing of first, second, and third-party data between data gathering partners?
A. Data Studio
B. Personalization Builder
C. Contact Builder
D. Interaction Studio

Answer 25

A. Data Studio

Reference: https://www.salesforce.com/ap/products/marketing-cloud/data-sharing/

Question 26

Northern Trail Outfitters has configured Reply Mail Management to handle manual unsubscribe requests. However, they have received complaints from customers who are still getting marketing emails despite having sent multiple unsubscribe replies including phrases like “take me off your list” or “opt out”.
How could this behavior be corrected?
A. Ensure “Common Misspellings” is selected as one of the Reply Filters
B. Ensure the DNS Record Redirect is correctly configured
C. Ensure the two phrases are added to a filtered keyword list
D. Ensure the two phrases are added to the “Filtered Keywords” data extension

Answer 26

D. Ensure the two phrases are added to the “Filtered Keywords” data extension

Question 27

Northern Trail Outfitters (NTO) is creating a birthday journey and one of the requirements is to divert anyone who has redeemed the promotional code before reminder emails are sent on the 15th and 20th of each month. Their transactional information, which includes redeemed promo codes, is housed in a separate data extension than the one used for journey injection. NTO needs to use an attribute to attribute comparison on the customer number field in the journey source and transaction data extensions.
Which activity would they use to accomplish this?
A. Decision Split Activity using both Contact and Journey Data
B. Decision Split Activity using only Journey Data
C. Einstein Split Activity
D. Decision Split Activity using only Contact Data

Answer 27

D. Decision Split Activity using only Contact Data

Question 28

Northern Trail Outfitters has a data extension that stores all of their orders. They want to send out a daily email for orders with their status changed to `shipped’ that day through a journey.
Which two methods should be used to filter entry into the journey? (Choose two.)
A. Entry Source Filter
B. Decision Split
C. SQL Query
D. Filter Activity

Answer 28

A. Entry Source Filter

C. SQL Query

Reference: https://deselect.com/what-is-journey-builder-in-salesforce-marketing-cloud/

Question 29

A customer wants to create a loyalty program by identifying all subscribers who clicked on a link within any email sent within the last six months.
What should be recommended?
A. Create and execute a Data Filter on the _Click data view.
B. Create and execute a Subscriber Engagement report.
C. Create and execute a SQL Query against the _Click data view.
D. Create and execute a Tracking Extract.

Answer 29

C. Create and execute a SQL Query against the _Click data view.

Question 30

Northern Trail Outfitters wants to suppress their highly engaged email subscribers (multiple opens and clicks for a target campaign) from active display campaigns to reduce overall cost and eliminate unnecessary targeting to the user.
What should be recommended?
A. Google Analytics 360
B. Data Studio
C. Einstein Engagement Scoring
D. Audience Studio

Answer 30

C. Einstein Engagement Scoring

Question 31

Northern Trail Outfitters is using a triggered send to send customers their order confirmations. Their commerce platform provides a JSON payload for order details. What would they use to format the JSON within the email?
A. TransformJSON() AMPscript Function
B. ParseJSON content block within Content Builder
C. BuildRowSetFromJSON() AMPscript Function
D. SSJS platform function ParseJSON

Answer 31

D. SSJS platform function ParseJSON

Reference: https://salesforce.stackexchange.com/questions/34945/can-ampscript-parse-json

Question 32

A customer wants to send SMS messages as part of a Journey. They are concerned the messages will deploy when subscribers are asleep. If a subscriber qualifies to receive an SMS message as part of the journey between 1 am. and 6am, the customer prefers the message to not be sent.
What solution should a consultant recommend to meet the criteria?
A. Run a SQL Query at 12:30 a.m. to create a suppression list.
B. Run an Import Definition at 12 a.m. to create a suppression list.
C. Create a Journey Goal to exit subscribers from the Journey.
D. Create and enable a BLOCKOUT window In MobileConnect.

Answer 32

D. Create and enable a BLOCKOUT window In MobileConnect.

Question 33

A marketer at Northern Trail Outfitters (NTO) wants to send important updates to customers about products they have previously purchased. The marketer has little experience with coding. Also, the information is spread across multiple data extensions and is imported nightly from NTO’s e-commerce platform - Contacts, Orders, Order Items, and Products.
Which design should a consultant recommend for segmentation?
A. Combine the data outside of Marketing Cloud and upload it into a Sendable Data Extension.
B. Establish data relationships and create Data Filters for the marketer to modify.
C. Create SQL Query Activities for the marketer to modify.
D. Link the data extensions in an Attribute Group.

Answer 33

B. Establish data relationships and create Data Filters for the marketer to modify.

Question 34

A customer has a robust Sales Cloud org with several custom objects. Historically, they have created complex reports, referencing many custom objects, to target subscribers and exported them to another email system for deployment. With the implementation of Marketing Cloud Connect, the customer wants to simplify the sending process using Marketing Cloud with as little additional setup as possible.
What should a consultant recommend to meet this criteria?

A. Continue to build reports in Sales Cloud and import it to Marketing Cloud for sending.
B. Create a Journey and use Salesforce Data and the Reports object as the Entry Source.
C. Sync all custom objects to Marketing Cloud and recreate the reports for sending.
D. Continue to build reports in Sales Cloud and select the reports in Marketing Cloud.

Answer 34

A. Continue to build reports in Sales Cloud and import it to Marketing Cloud for sending.

Question 35

A customer’s web developer team is creating a form that will leverage a Marketing Cloud REST API endpoint to upsert rows into a data extension.
How should the consultant create an installed package in Marketing Cloud to facilitate this functionality?
A. Enable the package for all business units in the Marketing Cloud account.
B. Create a separate installed package for each individual web form.
C. Instruct the web team to store the client ID and secret in the client-side code.
D. Ensure the package scope includes Read and Write permissions for data extensions.

Answer 35

D. Ensure the package scope includes Read and Write permissions for data extensions.

Question 36

An analytics team wants to get hourly updates on email metrics (send, open, click) to provide timely next best actions to the sales team.
What method should the team use?
A. Send Logs
B. Data views
C. Tracking Extracts
D. Scheduled Reports

Answer 36

D. Scheduled Reports

Question 37

Northern Trail Outfitters is growing and acquiring other organizations, each with its own instance of Sales Cloud. They are debating whether to upgrade Marketing Cloud Connect to Multi-Org.
What consideration could be provided to help with the decision?
A. Shared Salesforce Data Extensions will be enabled in up to 5 business units.
B. Custom profile and subscription centers will not be required.
C. Once an account is upgraded to Multi-Org, it cannot be turned off.
D. Existing accounts cannot be upgraded to Multi-Org.

Answer 37

C. Once an account is upgraded to Multi-Org, it cannot be turned off.

Question 38

Northern Trail Outfitters wants to include the body of marketing email replies captured by Reply Mail Management (RMM) within auto-forwarded messages to their Customer Success team.
How could they accomplish this?
A. Check the Include Replies as Attachments box in the RMM settings.
B. Use RMM dynamic content blocks to render the email reply body.
C. Query the RMM data view for the reply body and reference it from a data extension.
D. Use RMM personalization strings to render the email reply body.

Answer 38

D. Use RMM personalization strings to render the email reply body.

Question 39

Northern Trail Outfitters (NTO) wants to send an email to all Contacts who have signed up for its newsletter, but have not joined its loyalty program. NTO has created a report in Sales Cloud which it will select using a Send Flow in Content Builder.
Which field name should be included in the report in addition to email address?
A. Individual ID
B. Contact ID
C. CampaignMember ID
D. External ID

Answer 39

B. Contact ID

Question 40

A customer wants to integrate a new dataset with pre-existing contacts. This data will be updated via separate data feeds from the main contact information.
What data model configuration should be recommended?
A. Create additional attribute fields in the main contact data extension.
B. Create new Salesforce data extension and link it to the other data extensions.
C. Create a new data extension and link it to the other data extensions.
D. Create a new data extension and link It as a new population.

Answer 40

C. Create a new data extension and link it to the other data extensions.

Question 41

Northern Trail Outfitters (NTO) plans on sending SMS and push notifications together with emails as part of a new customer onboarding journey.
What should a consultant recommend as a unique identifier for each subscriber?
A. A common field like Physical Address for Contact Key.
B. A number field such as subscriber’s phone number for Contact Key.
C. An email address for Contact Key.
D. A GUID or another generated ID for Contact Key.

Answer 41

B. A number field such as subscriber’s phone number for Contact Key.

Question 42

Northern Trail Outfitters (NTO) wants email subscribers to adopt their app. They are investigating using MobileConnect features since over 90% of their subscribers provide a Mobile Phone Number when registering.
Which three considerations should be made before implementing MobileConnect? Choose 3 answers
A. Long and Short Codes are not available for all countries.
B. NTO would be charged by mobile operators directly for messages.
C. Inbound messaging only works with local Long or Short Codes.
D. Not all countries are supported by MobileConnect.
E. Opting in for messages can only be done via inbound message.

Answer 42

C. Inbound messaging only works with local Long or Short Codes.
D. Not all countries are supported by MobileConnect.
E. Opting in for messages can only be done via inbound message.

Question 43

A customer is connecting Sales Cloud with Marketing Cloud. The connection was successful, however, the team is unable to view or sync Sales Cloud objects in Contact Builder.
How should a consultant begin troubleshooting the connection?
A. Create and send an email in Email Studio to test the connection and validate tracking.
B. Validate Marketing Cloud and Sales Cloud users have access to the business unit.
C. Create new Marketing Cloud and Sales Cloud users and perform a new installation.
D. Validate Marketing Cloud and Sales Cloud permissions for the connecting users.

Answer 43

D. Validate Marketing Cloud and Sales Cloud permissions for the connecting users.

Question 44

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?
A. Smart Capture form on website
B. Salesforce Triggered Sends
C. File import to data extension
D. Batch file dropped to SFTP

Answer 44

B. Salesforce Triggered Sends

Question 45

Northern Trail Outfitters wants to target Contacts in an abandoned cart Journey with a Facebook ad. An Ad Campaign Activity has been added to the Journey canvas.
Which extension product should be enabled to use the Ad Campaign Activity?
A. Interaction Studio
B. Social Studio
C. Advertising Studio
D. Audience Studio

Answer 45

C. Advertising Studio

Question 46

Northern Trail Outfitters (NTO) is saving each Email Address in its SendLog which is quickly increasing in size. NTO’s marketers want to pull data from the SendLog for troubleshooting based on email address when a subscriber either does not receive an email or receives the wrong email.
Which design should the consultant recommend to perform their analysis?
A. Set up and pull data from a SendLog Archive Data Extension.
B. Filter data using a Filter Activity on SendLog Data Extension.
C. Set up and pull data from _Sent and .Subscriber Data Views.
D. Set up and pull data from Tracking Extracts in Automation Studio.

Answer 46

C. Set up and pull data from _Sent and .Subscriber Data Views.

Question 47

Northern Trail Outfitters is investigating implementing MobileConnect to allow SMS messaging in their UK, Germany, and Swiss subsidiaries. Each subsidiary has its own business unit and they are trying to
determine if a single long code could be used for all markets.
What functionality would tie to additional long code Implementation?
A. Do they need to support UTF-8 characters in their SMS?
B. Do they need to support different From Names by country?
C. Do they need to have independent reporting on SMS sends by country?
D. Do they need to support inbound messages in each country?

Answer 47

D. Do they need to support inbound messages in each country?

Question 48

Northern Trail Outfitters (NTO) is the holding company of three subsidiaries: Universal Containers, Ursa Major Solar, and Cloud Kicks. NTO recently purchased Marketing Cloud and has asked its consultant to recommend a scalable business unit (BU) hierarchy. They don’t plan on executing any marketing campaigns on behalf of the NTO holding company, but NTO employees would like access to all subscribers and aggregate reporting. Additionally, each subsidiary business will be regularly running campaigns and should have their own branding, content, and subscribers.
Which solution should the consultant recommend?
A. One parent BU and two child BUs with their own Sender Authentication Packages.
B. One parent BU with three additional private domains.
C. One parent BU and one child BU
D. One parent BU and three child BUs with their own Sender Authentication Packages.

Answer 48

D. One parent BU and three child BUs with their own Sender Authentication Packages.

Question 49

Northern Trail Outfitters wants to use Marketing Cloud to send notifications to customers when their orders are ready for in-store pickup. The notifications can be either SMS or email depending on their communications preference.
How should the consultant set this up?
A. Create an Outbound Message in MobileConnect with AMPscript in body to trigger an email confirmation as a fallback.
B. Journey Builder Transactional Send Journey.
C. Automation with a Send SMS and Send Email activity in separate consecutive steps.
D. Journey Builder multi-step journey with an API entry event and a decision split.

Answer 49

B. Journey Builder Transactional Send Journey.

Question 50

Northern Trail Outfitters has a file that drops intermittently to their SFTP account. Once this file drops, they want to be able to have it immediately imported and then segmented to enter a specific journey depending on the data inside the file.
Which two options would meet these requirements? Choose 2 answers
A. Scheduled Automation
B. File Drop Automation
C. SQL Query
D. Decision Split

Answer 50

B. File Drop Automation
C. SQL Query

Question 51

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?
A. Data Extract with the Data Extension Extract type > File Transfer to Safehouse > File Transfer unzip > SQL Query
B. SQL Query > Data Extract with the Data Extension Extract type > File Transfer to Safehouse > Import File
C. Data Extract with the Tracking Extract type > File Transfer from Safehouse > File Transfer unzip > Import File
D. Data Factory Utility > File Transfer from Safehouse > Import File > Data Extract with Tracking Extract type

Answer 51

C. Data Extract with the Tracking Extract type > File Transfer from Safehouse > File Transfer unzip > Import File

Question 52

ABC Company wants to automate the sending of shipping notices and a customer survey.
1. Shipping notices will be sent once a day.
2. The shipping file will be placed on the FTP some time after 4:00 p.m.
3. The shipping data will be sorted in the Shipping Notice data extension.
4. A field in the data extension will contain the shipping date.
5. The survey needs to be sent at 9:00 a.m., exactly 10 days after the customer’s order ships.

Which workflow would most effectively enable ABC Company to do this?

A. Automation 1: Triggered Import File -> Filter -> Send Email -> Wait-> Filter -> Send Email
B. Automation 1: Scheduled to run daily at 7:00 PM Import File -> Filter -> Send Email -> Wait -> Filter-> Send Email
C. Automation 1: Scheduled to run daily at 7:00 PM Automation 2: Scheduled to run daily at 9:00 AM Import File -> Filter -> Send Email -> Filter -> Send Email
D. Automation 1: Triggered Automation 2: Scheduled to run daily at 9:00 AM Import File -> Filter -> Send Email -> Filter -> Send Email

Answer 52

A. Automation 1: Triggered Import File -> Filter -> Send Email -> Wait-> Filter -> Send Email

If a question is related to automation and it mentions that a file will be available in the FTP always at a specific time, your answer will be an option with a scheduled automation. Scheduled automations are used when you know the time a file is pushed into FTP and it always runs at a scheduled time. If a question is related to automation and there is an uncertainty when the file will be pushed to FTP (ex; a day before last working day / if a date falls on a weekend, it will be available on last Friday etc.), your answer will be an option with a Triggered Automation.
Triggered Automations are fired as soon as a file hits a specific location within FTP. Transfer activity is involved when file is encrypted.

Question 53

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 SMS 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?

A. Select ‘Normalize Phone Number* in Journey settings.
B. Format the phone field in Salesforce as +l[phonenumber],
C. Select ‘US’ as the sending country in SMS activity.
D. Configure the phone field in Salesforce as US locale.

Answer 53

B. Format the phone field in Salesforce as +l[phonenumber],

Question 54

A customer wants to limit the number of emails a subscriber receives to a maximum of one email every 14 days. After the 14-day period, the subscriber is eligible to receive the next message.
What should a consultant recommend to meet this criteria?
A. Import the identified subscribers into a list when creating the send.
B. Create an exclusion data extension populated with the identified subscribers.
C. Query contacts from the Einstein Engagement Frequency data extension when creating the send.
D. Create a suppression list populated with the identified subscribers.

Answer 54

C. Query contacts from the Einstein Engagem

Question 55

A customer has a business requirement to exclude email addresses of certain contacts In their loyalty program from the 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?
A. Publication list
B. Exclusion data extension
C. Auto-suppression list
D. Suppression list

Answer 55

C. Auto-suppression list

Question 56

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?
A. Implement two separate Marketing Cloud instances.
B. Ensure test sends are done from data extensions with attribute ‘Is Testing1.
C. Create one or more additional business units for testing.
D. Use Subscriber Filter per business unit to filter production from test data.

Answer 56

A. Implement two separate Marketing Cloud instances.

Question 57

A customer indicates their point-of-sale system can be configured to upload a file every fifteen minutes. The filename is not consistent for each upload. Their consultant recommends they use a File Drop Automation.
Which two considerations should be made? Choose 2 answers
A. They may utilize an external FTP site.
B. The directory is unable to be used by another File Drop Automation.
C. The directory used by the file trigger should be inside the import directory.
D. The directory cannot contain more than five file triggers.

Answer 57

B. The directory is unable to be used by another File Drop Automation.
C. The directory used by the file trigger should be inside the import directory.

Question 58

Which customers would benefit most from purchasing a Sender Authentication Package (SAP)?
A. A growing consumer brand that expects to send 500,000 emails per month and would like email branding to be consistent with its domain,
B. A nonprofit organization that sends roughly 50,000 newsletter emails per month.
C. A growing retailer that currently leverages Marketing Cloud’s MobileConnect and MobilePush.
D. A customer who wants to share another IP within their account structure and is unconcerned about

Answer 58

A. A growing consumer brand that expects to send 500,000 emails per month and would like email branding to be consistent with its domain,

Question 59

Northern Trail Outfitters uses separate Marketing Cloud accounts as environments for development, UAT, and production. They want to test all automations and Journeys In each environment prior to launching in production.
Which extension product should be used to speed up the migration of data extensions and Journey Builder configurations between each environment?
A. Configuration Manager
B. Change Sets
C. Deployment Manager
D. Ant Migration Tool

Answer 59

C. Deployment Manager

Question 60

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?

A. Use Journey Builder to process and segment the new customers, and for the campaign sends and decisioning.
B. Use Automation Studio to process and segment the new customers, and use Journey Builder for the campaign sends and decisioning.
C. Use Automation Studio to process and segment the new customers, and use Email Studio for the campaign sends and decisioning.
D. Use Automation Studio to process and segment the new customers, and for the campaign sends and decisioning.

Answer 60

C. Use Automation Studio to process and segment the new customers, and use Email Studio for the campaign sends and decisioning.

Question 61

A customer has curated a list of known email addresses belonging to competitors. They want to ensure none of these competitors receive their emails.
What should a consultant recommend’
A. Create an auto-suppression list populated with subscriber keys.
B. Populate a list using a query to exclude the subscriber key.
C. Create an exclusion list with the known email addresses.
D. Create an auto-suppression list populated with the known email addresses.

Answer 61

D. Create an auto-suppression list populated with the known email addresses.

Question 62

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. Journey Settings > No re-entry
B. Contact Evaluation > Evaluate all records
C. Contact Evaluation > Evaluate new records only
D. Journey Settings > Use email attribute from Contacts

Answer 62

C. Contact Evaluation > Evaluate new records only

Question 63

Northern Trail Outfitters wants to monitor available coupon codes and sends a notification to their email specialist instructing them to request more codes for importing if the available coupon count falls below 500 available codes.
Which two activities would be automation? Choose 2 answers
A. Import Activity
B. Verification Activity
C. Data Extract Activity
D. Filter Activity

Answer 63

B. Verification Activity

D. Filter Activity

Question 64

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?
A. Automation Studio and Interaction Builder
B. Journey Builder
C. Automation Studio
D. Automation Studio and Journey Builder

Answer 64

D. Automation Studio and Journey Builder