Labour Day Special 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exams65

Salesforce Certified Marketing Cloud Consultant Exam (SP23) Question and Answers

Salesforce Certified Marketing Cloud Consultant Exam (SP23)

Last Update May 7, 2024
Total Questions : 156

We are offering FREE Marketing-Cloud-Consultant Salesforce exam questions. All you do is to just go and sign up. Give your details, prepare Marketing-Cloud-Consultant free exam questions and then go for complete pool of Salesforce Certified Marketing Cloud Consultant Exam (SP23) test questions that will help you more.

Marketing-Cloud-Consultant pdf

Marketing-Cloud-Consultant PDF

$35  $99.99
Marketing-Cloud-Consultant Engine

Marketing-Cloud-Consultant Testing Engine

$42  $119.99
Marketing-Cloud-Consultant PDF + Engine

Marketing-Cloud-Consultant PDF + Testing Engine

$56  $159.99
Questions 1

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?

Options:

A.  

Set File Naming Pattern to %%AUTOMATED_FILENAME%%

B.  

Set File Naming Pattern to %%BASEFILENAME_FROM_TRIGGER%%

C.  

Filename is automatically passed to Import Activity with File Drop Automations

D.  

Check the 'Use filename from Automation' checkbox

Discussion 0
Questions 2

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?

Options:

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?

Discussion 0
Questions 3

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?

Options:

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.

Discussion 0
Questions 4

Northern Trail Outfitters (NTO) has been storing web behavior to a data extension for several years. They have indicated with several hundred millions of 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)

Options:

A.  

Clear data from the current data extension completely, then reconfigure a Retention Period via Email Studio.

B.  

Delete data from the data extension prior to twelve months ago, then configure a Retention Period via Contact Builder.

C.  

Reconfigure the current data extension as-is with a Retention Period via Contact Builder.

D.  

Replace the current data extension with a new data extension configured with a Retention Period.

Discussion 0
Questions 5

Northern Trail Outfitters (NTO) stores customer purchase data m 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 mort than 1,000 records are ever imported through this automation, and would also like to prevent the sendable date extension from being updated that day.

Which solution ts appropriate in this situation?

Options:

A.  

Split the existing activities into two separate automations.

B.  

Implement a Wait Activity to wait until the data extension is populated with records.

C.  

Place a Verification Activity between the import and SQL Query activity.

D.  

Write a custom SSJS script to

E.  

validate the row count of the staging data extension and send a notification email.

Discussion 0
Questions 6

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?

Options:

A.  

Triggered send definition and use data extract Not Sent to a data extension then send SMS to those failed sends

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.  

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

Discussion 0
Questions 7

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

Options:

A.  

Import Activity

B.  

Verification Activity

C.  

Data Extract Activity

D.  

Filter Activity

Discussion 0
Questions 8

Northern Trail Outfitters wants to capture dietary preferences for Contacts who have registered for an upcoming launch event. They have created a data extension of Contacts who have registered for the event and will send them an SMS message from MobileConnect asking them to reply with their dietary preference. When Contact reply to SMS message, the response message will be inserted into a data extension using AMPscript.

Which two MobileConnect templates should be used to send the SMS message and capture the responses?

Options:

A.  

Text Response

B.  

Info Capture

C.  

Outbound

D.  

Data Capture

Discussion 0
Questions 9

A customer is starting a new children's fashion brand and wants to use a dedicated business unit within their existing Enterprise 2.0 account. They anticipate many of their current Enterprise contacts will subscribe to the children's brand, however, they want to separate subscriber opt-outs of the Enterprise and children's brands. The customer has minimal technical resources available for implementation and support.

What should a consultant recommend to meet these criteria?

Options:

A.  

Select "Use separate 'Subscription Center' for this business unit" in Settings

B.  

Create attributes for each child business unit in "Profile Management" to record unsubscribes

C.  

Create a Business Unit Filter in 'All Subscribers' List to record unsubscribes

D.  

Select "Subscribers will be unsubscribed from this business unity only" in Settings

Discussion 0
Questions 10

Northern Trail Outfitters in interested in a solution to automate a process. They currently pull data into a spreadsheet to import into a 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 3 answers

Options:

A.  

Is the data file a delta or a historical file

B.  

Does the data extension have a data relationship?

C.  

Will the file have more than 5,000 rows?

D.  

Will the data file be placed on the SFTP at the same time daily?

E.  

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

Discussion 0
Questions 11

Northern Trail Outfitters want a simple segmentation strategy for identifying subscribers for their emails.

What solution should they use?

Options:

A.  

List model and Groups in Single Send Journeys.

B.  

Attribute group in Contact Builder for segmentation.

C.  

Relational data extensions with primary keys to match subscribers with their data

D.  

Data Extension Entry Source in journey Builder with a filter

Discussion 0
Questions 12

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?

Options:

A.  

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

B.  

Create and execute a Tracking Extract.

C.  

Create and execute a Subscriber Engagement report.

D.  

Create and execute a Data Filter on the_Click data view.

Discussion 0
Questions 13

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?

Options:

A.  

%%view_as_webpage%%

B.  

%%view_email_url%%

C.  

%%vawp%%

D.  

%%view_online%%

Discussion 0
Questions 14

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?

Options:

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.

Discussion 0
Questions 15

A customer wants to set up a real-time, API-driven way to be alerted when transactional messages fail to send out of Marketing Cloud. They are currently in the process of hiring a full-time developer but want an implementation in place for the developer to maintain.

What should the customer have in place to ensure this solution can be implemented?

Options:

A.  

A Transactional Journey with the Not Sent Notification activity included

B.  

A Datorama instance to ingest their data

C.  

An external system to receive and confirm callback and subscriptions

D.  

An Interaction Studio instance to ingest their data

Discussion 0
Questions 16

Northern Trail Outfitters wants to target all customers who have registered to receive Push Notifications. Their app uses the Mobile Push SDK.

In which two ways should this segment be created?

Options:

A.  

Using Mobile Studio, create a Mobile Push Filtered List then filter on the MobilePush Demographics attribute group.

B.  

Using Automation Studio, query the_MobilePushDemographics Data View and save this to a data extension.

C.  

Using Journey Builder, target the entire customer database then filter using MobilePush Demographics attribute group.

D.  

Using Contact Builder, create a Filter Data Extension from AB Contact where there is record in MobilePush Demographics.

Discussion 0
Questions 17

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?

Options:

A.  

Use an Import Activity in Automation studio to filter the data as a Data Extension Entry Source.

B.  

Use a Query Activity in Automation Studio to create a segment before entering the journey.

C.  

Use a Contact Data Entry Source to segment the data configured in Attribute Groups in Contact Builder.

D.  

Use a Data Extension Entry Source with an applied filter based on recent member activity.

Discussion 0
Questions 18

Northern Trail Outfitters (NTO) wants to send out a communication to subscribers who have not made a purchase the last six months. Customer are often opted-in to 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?

Options:

A.  

Query Activity > API Event > Automation Studio Activities

B.  

Import Activity > Decision > Journey Activities

C.  

Query Activity > Data Extension Entry Source > Journey Activates

D.  

Salesforce Entry Event > Query Activity > Automation Studio Activities

Discussion 0
Questions 19

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?

Options:

A.  

SOAP API Calls updating objects

B.  

CreateSalesforceObject() AMPscript

C.  

Login Calls

D.  

Bulk API

Discussion 0
Questions 20

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?

Options:

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.

Discussion 0
Questions 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?

Options:

A.  

Refresh Mobile Filtered List and Outbound Send

B.  

Import Mobile Contacts and Outbound Send

C.  

Refresh Mobile Filtered List and Send SMS

D.  

Import Mobile Contacts and Send SMS

Discussion 0
Questions 22

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?

Options:

A.  

A new Sender Authentication Package should be used for NTO.

B.  

A Private Domain should be applied to the parent business unit.

C.  

A Private Domain should be applied to the child business unit.

D.  

A Sender Authentication Package should be used for CloudKicks.

Discussion 0
Questions 23

Northern Trail Outfitters (NTO) wants to use Case data from Service Cloud as part of their current email messaging campaign. They want to import cases that indicate the customer wants someone to contact them after the case is closed. NTO tracks cases with a checkbox field called "Contact Me".

Options:

A.  

Create data extensions in Marketing Cloud and import the data from Service Cloud using Journey Builder.

B.  

Use Salesforce Data Extensions and Filter Activities in Automation Studio to import and filter the data.

C.  

Use Synchronized Data Extensions on the Case Object with a Boolean filter on the Contact Me field.

D.  

Create Reports in Salesforce filtered by Contact Me equal to True and import using the Import word.

Discussion 0
Questions 24

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?

Options:

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.

Discussion 0
Questions 25

A marketer want to personalize an email with real-time weather information from the Sunny Sky API.

What tool should be used to parse and display the response within the email?

Options:

A.  

Node.JS

B.  

Apex

C.  

SSJS

D.  

GTL

Discussion 0
Questions 26

Which customers would benefit most from purchasing a Sender Authentication Package (SAP)?

Options:

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 branding at this time.

Discussion 0
Questions 27

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?

Options:

A.  

Smart Capture form on website

B.  

Salesforce Triggered Sends

C.  

File import to data extension

D.  

Batch file dropped to SFTP

Discussion 0
Questions 28

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'

Options:

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.

Discussion 0
Questions 29

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?

Options:

A.  

Interaction Studio

B.  

Social Studio

C.  

Advertising Studio

D.  

Audience Studio

Discussion 0
Questions 30

Northern Trail Outfitters injects outcomes journey B based upon email engagement in journey A.

Which method would facilitate this solution?

Options:

A.  

In Automation Studio, use verification activity to verify engagement or email in journey A:Qeuery engagement data extension for journey B injection.

B.  

In journey A, engagement split followed by Update Contact Activity to Boolean field on an engagement data extension: Query engagement data extension for journey B injection.

C.  

In Automation Studio, query activity engagement an journey system data view for email send is journey A; Use resultant data extension for journey B Injection.

D.  

In journey A, engagement split email send. In Automation Studio, query_ journey Activity data view for the Engagement Split Result Boolean field: Use resultant data extension for journey B injection.

Discussion 0
Questions 31

Northern Trail Outfitters is looking to personalize their SMS Messages.

Which data source is supported to personalize messages?

Options:

A.  

Population in Contact Builder

B.  

MobileConnect Demographics

C.  

Data Designer Attribute Group

D.  

Profile Attributes.

Discussion 0
Questions 32

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?

Options:

A.  

What the offer will be

B.  

When to send the email

C.  

Who the offer come from

D.  

How to determine engagement

Discussion 0
Questions 33

A financial services customer wants to send email to customers who log in for the first on a new IP. This message should be deployed as fast as possible due to its sensitive content. The message contain information related to the login IP.

What should a consultant recommend to deploy the email?

Options:

A.  

Inject the subscriber into a Journey.

B.  

Use the Transactional Messaging API.

C.  

Execute a Triggered Emails Interaction.

D.  

Use a User-Initiated Emails Interaction.

Discussion 0
Questions 34

Northern Trail Outfitters is having their regional supplier conference and wants to allow attendees to request event-specific safety notifications, schedule or room changes, and surprise pop-up sessions.

Which solution should they use?

Options:

A.  

Keyword opt in and SMS Messaging

B.  

Smart Capture and Triggered email messaging

C.  

CloudPages opt in to Event Journey

D.  

Existing Email Event Notification Subscription

Discussion 0
Questions 35

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?

Options:

A.  

Mobile Studio

B.  

Advertising Studio

C.  

Google Analytics 360

D.  

Einstein Engagement Scoring

Discussion 0
Questions 36

Northern Trail Outfitters has been using Marketing Cloud for one of their brands for the last year and wants to migrate another brand to their portfolio. The two brands have contrasting target groups and identities so they need the emails and landing pages to have different styles that refrain from mentioning the other brand in any way.

What should be recommended?

Options:

A.  

Create a new business unit for the new brand.

B.  

Request a second SAP for the existing business unit.

C.  

Request a Private Domain to be added to the existing business unit.

D.  

Implement a new SSL Certificate for the new brand.

Discussion 0
Questions 37

A customer wants to improve the previous 10 years purchase data n their Marketing Cloud account. Through discovery, it is determined there are over 200 million records they plan to upload via the REST API, and this volume will continue to grow as the current purchase data is added.

Which two questions should be asked for further discovery?

Choose 2 answers

Options:

A.  

Does their License include time Large Extensions feature?

B.  

How many API calls are expected to be made at the ask hourly rate?

C.  

What time of day are the API calls made?

D.  

Why do they require 10 years’ historical data in Marketing Cloud?

Discussion 0
Questions 38

A customer wants to configure appointment reminders for patients in their clinic. The reminder should be sent day before the appointment date at 10 a.m and the appointment record should be updated in the patient was sent a reminder email.

What solution could be recommended?

Options:

A.  

Create a journey with CRM data source triggered on the reminder data and use Journey Builder activities to send a reminder and update the record in Synchronized Data Extension.

B.  

Create a journey with CRM date based entry source, and use journey Builder activates to send a reminder and update the record in CRM.

C.  

Create a daily scheduled automation to refresh the audience, and use Automation Studio activities to send a reminder with AMPscript in the message to update the record in Synchronized Data Extension.

D.  

Create a daily scheduled automation to refresh the audience, and use Data Extension entry source for a journey with activates a reminder and updates the record in CRM.

Discussion 0
Questions 39

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?

Options:

A.  

Journey settings > No re-entry

B.  

Contact Evaluation > Evaluate new records only

C.  

Contact Evaluate > Evaluate all records

D.  

Journey Settings > Use email attribute from Contacts

Discussion 0
Questions 40

Northern Trail Outfitters has determined they will initially deploy messaging to email and SMS channels, but also plan for social advertising. Customer data originates within their point-of-sale system which communicates to Marketing Cloud in real-time via API. They want to configure their customer data for long-term cleanliness and maintainability.

Which two best practices should be utilized? (Choose 2 answers)

Options:

A.  

Configure Contact Builder to automatically generate a unique subscriber key.

B.  

Define the subscriber key as a unique value that does not relate to a specific channel.

C.  

Regularly merge duplicate contacts to keep tracking data accurately.

D.  

When using an external database of record, utilize that system's identifier as the contact key.

Discussion 0
Questions 41

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

Options:

A.  

Salesforce Data Extension

B.  

Salesforce Report

C.  

Synchronized Data Extension

D.  

Salesforce Campaign

Discussion 0
Questions 42

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?

Options:

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.

Discussion 0
Questions 43

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

Options:

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.

Discussion 0
Questions 44

Northern Trail Outfitters (NTO) wants to find ways to better drive return on investment and growth via their marketing sends. They plan to centralize their analytics data to allow for a more efficient analysis of this data across all of their campaigns. NTO currently has Marketing Cloud, Sales Cloud, and a third-party warehouse service.

What product would help their use case?

Options:

A.  

Report Studio

B.  

Web Analytics Connector

C.  

Interaction Studio

D.  

Datorama

Discussion 0
Questions 45

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?

Options:

A.  

Triggered Send Definition

B.  

Transactional Messaging API

C.  

Multi-Step journey with an API Event entry source

D.  

Single Send journey with an API Event entry source

Discussion 0