Month End Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: pass65

Marketing-Cloud-Consultant Salesforce Certified Marketing Cloud ConsultantSFMCExam (SP25) Questions and Answers

Questions 4

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?

Options:

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.

Buy Now
Questions 5

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

Buy Now
Questions 6

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?

Options:

A.

Individual ID

B.

Contact ID

C.

CampaignMember ID

D.

External ID

Buy Now
Questions 7

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?

Options:

A.

Verification Activity

B.

Script Activity

C.

Query Activity

D.

Stop Activity

Buy Now
Questions 8

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?

Options:

A.

Use Data Designer in Contact Builder to relate the two data extensions.

B.

Utilize Entry Data on a Decision Split within Journey Builder.

C.

Create a Data Relationship in Email Studio to relate the two data extensions.

D.

Configure activities within Automation Studio to update the purchase data.

Buy Now
Questions 9

Northern Trail Outfitters wants to send a 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 comes from

D.

How to determine engagement

Buy Now
Questions 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 withthankyou_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

Buy Now
Questions 11

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?

Options:

A.

Select 'US' as the sending country in SMS activity.

B.

Format the phone field in Salesforce as +1[phonenumber].

C.

Select 'Normalize Phone Number' in Journey settings.

D.

Configure the phone field in Salesforce as US locale.

Buy Now
Questions 12

Northern Trail Outfitters wants to send an email to one million contacts in Sales Cloud. The criteria to segment contacts include using 10+ fields to segment.

Which process should the consultant utilize for a reliable send method?

Options:

A.

Query Synchronized Data Extensions using a query activity to a Salesforce Data Extension, then send via Email Studio Send Flow

B.

Import Salesforce Report through an import activity to a Salesforce Data Extension, then send to data extension using Email Studio email send

C.

Assign the one million contacts from the report to a Salesforce campaign, and use a Single Stepjourney with Salesforce Campaign as an entry event

D.

Send to a Salesforce Report from Marketing Cloud using Email Studio Send Flow

Buy Now
Questions 13

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?

Options:

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

Buy Now
Questions 14

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.

Buy Now
Questions 15

A customer wants to send an email confirming opt-in when someone signs up for their emails via a form on their website. The email should arrive within a few minutes of completing the form, and all of the form data needs to be stored in Marketing Cloud to personalize the outgoing email.The customer has access to a developer for working with APIs, but they want to be able to change the email creative without involving the developer.

What should a consultant recommend?

Options:

A.

Use the WSProxy via SSJS to deploy the email after capturing form data.

B.

Use a SQL Query activity in Automation Studio to run hourly and deploy emails.

C.

Use a Send Email activity in Automation Studio to run hourly and deploy emails.

D.

Use a Triggered Send Data Extension to capture form data and deploy the email.

Buy Now
Questions 16

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?

Options:

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

Buy Now
Questions 17

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?

Options:

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.

Buy Now
Questions 18

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%%

Buy Now
Questions 19

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

Buy Now
Questions 20

Northern Trail Outfitters upgraded their Marketing Cloud account which now includes a Sender Authentication Package (SAP). They send regularly 300,000 messages.

What should they be aware of with respect to sender reputation?

Options:

A.

They should have one dedicated IP address for every 100,000 messages sent per month.

B.

They should have a shared IP since their volume is under 500,000 messages per month.

C.

They should have one SAP for transactional sends and another for commercial sends.

D.

They should send at least 250,000 messages per month to maintain their sender reputation.

Buy Now
Questions 21

A new Marketing Cloud (MC) customer wants to now implement a Sales Cloud instance to go along with their MC instance. The MC has been live for a year now, where the primary key for records has been the Email Address.

Which two options would prevent the customer from duplicating records? (Choose 2 answers)

Options:

A.

Upload CSV with Migrated Subscriber Keys to All Subscribers.

B.

Get existing records updated with new Keys sourced from Sales Cloud instance.

C.

Continue as normal, as Marketing Cloud Contact Models will dedupe keys by Email Address.

D.

Purge the current records and carry on with new keys sourced from Sales Cloud.

Buy Now
Questions 22

Northern Trail Outfitters and its subsidiaries use Sales Cloud and Marketing Cloud to send customers frequent email communications about new products and updates on their portfolios. They have noticed the messaging and branding being sent varies greatly and would like to create a better customer experience.

What extension product should be considered to unify the messaging and branding of these communications while still allowing personalization and timing of campaigns?

Options:

A.

Einstein Content Selection

B.

Distributed Sending

C.

Marketing Cloud Connect

D.

Distributed Marketing

Buy Now
Questions 23

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

Options:

A.

Journey Data

B.

Salesforce Data

C.

Contact Data

D.

Entry Data

Buy Now
Questions 24

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?

Options:

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.

Buy Now
Questions 25

Northern Trail Outfitters (NTO) wants to personalize emails and display different content based on customer points. NTO has limited development expertise and chooses to use dynamic content.

What should the consultant consider when building dynamic content rules?

Options:

A.

Create a custom list and add all fields required for personalization.

B.

Standardize field naming across all sendable data extensions.

C.

Create a synchronized data extension to keep all fields required for personalization up-to-date.

D.

Build rules before uploading the respective content.

Buy Now
Questions 26

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?

Options:

A.

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

B.

Tracking Data will not be returned to the Sales Cloud email recipient.

C.

The customer will be able to use Reports and Campaigns as audiences.

D.

The customer will be unable to use synchronized data extensions.

Buy Now
Questions 27

Scenario:

A B2B customer notices they have a large number of subscribers marked as 'Held'. During troubleshooting, they realize these were soft bounces from overwhelming the email servers of many of the small companies with which they do business.

What step(s) should the customer take to move those subscribers back to 'Active'?

Options:

A.

Extract subscribers who have a status of 'Held', then import subscribers as 'Active'.

B.

Use Contact Builder to mass update all 'Held' subscribers to 'Active' status.

C.

Subscribers with a status of 'Held' should be re-enabled by contacting support.

D.

Use a SQL query to change all subscribers with a status of 'Held' to 'Active' in All Subscribers.

Buy Now
Questions 28

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

Buy Now
Questions 29

Northern Trail Outfitters injects outcomes into 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; Query 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 on Journey System Data View for email send in 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.

Buy Now
Questions 30

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 2 answers)

Options:

A.

Filter Activity

B.

Entry Source Filter

C.

SQL Query

D.

Decision Split

Buy Now
Questions 31

Northern Trail Outfitters wants to provide near real-time data in a 30-day welcome journey.

Which data setup should they use for decision splits?

Options:

A.

Journey Data queried from main data extension

B.

Contact Data mapped through Salesforce Marketing Cloud Profile Attributes

C.

Journey Data using CRM Report Import Activity to Salesforce Data Extension

D.

Contact Data using Synchronized Data Sources

Buy Now
Questions 32

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?

Buy Now
Questions 33

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?

Options:

A.

Salesforce Campaign Entry Source on the Lead Object

B.

Salesforce Data Entry Source on the Contact Object

C.

Salesforce Data Entry Source on the Account Object

D.

Welcome Email Configuration on the Account Object

Buy Now
Questions 34

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?

Options:

A.

Automation Studio and Interaction Builder

B.

Journey Builder

C.

Automation Studio

D.

Automation Studio and Journey Builder

Buy Now
Questions 35

Scenario:

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?

Options:

A.

Select 'Normalize Phone Number' in Journey settings.

B.

Format the phone field in Salesforce as +1[phonenumber].

C.

Select 'US' as the sending country in SMS activity.

D.

Configure the phone field in Salesforce as US locale.

Buy Now
Questions 36

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?

Options:

A.

Configuration Manager

B.

Change Sets

C.

Deployment Manager

D.

Ant Migration Tool

Buy Now
Questions 37

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?

Options:

A.

Create additional attribute fields in the main contact data extension.

B.

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

C.

Create new Salesforce data and link it to the other data extensions.

D.

Create a new data extension and link it as a new population.

Buy Now
Questions 38

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?

Options:

A.

Lookup AMPscript function

B.

LookupRows AMPscript function

C.

Dynamic Content Block

D.

Enhanced Dynamic Content Block

Buy Now
Questions 39

Northern Trail Outfitters (NTO) is using Einstein Content Selection to populate its emails with personalized product images at send time. These emails typically see high engagement, but because of the frequency of these emails, a customer could see the same image asset several times within a 2-week span.

How should NTO marketers ensure there's a limit to the number of times a particular image asset can be chosen for a customer?

Options:

A.

Ask the content team to create more images in order to diversify the asset pool.

B.

Set a Fallback Asset.

C.

Utilize Einstein Engagement Frequency to send the emails less often.

D.

Set Fatigue Rules for the product Asset Classes.

Buy Now
Questions 40

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 Evaluation > Evaluate all records

D.

Journey Settings > Use email attribute from Contacts

Buy Now
Questions 41

A customer manually imports records for sending. Each record contains a warehouse ID that is shared between Marketing Cloud and a third-party system. The customer does not have developer resources, but wants to include the warehouse ID in their tracking parameters so that the third-party system can identify the subscriber.

What should a consultant recommend?

Options:

A.

Use personalization strings created by selecting the data extension.

B.

Use AMPscript variables created from each field in the data extension.

C.

Use Dynamic Content rules to select a content area for each subscriber.

D.

Use Guide Template Language created for each field in the data extension.

Buy Now
Questions 42

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)

Options:

A.

Synchronized Data Sources only push data every 15 minutes

B.

ContactID was used as Subscriber Key

C.

Email Address was used as Subscriber Key

D.

Individual Level Tracking was not selected in Marketing Cloud Configuration

Buy Now
Questions 43

Northern Trail Outfitters wants its emails to be redirected to Marketing Cloud servers for processing.

Which configuration setting should the consultant recommend?

Options:

A.

Reply Mail Management

B.

Private Domains

C.

Sender Authentication Package

D.

Custom Delivery Profiles

Buy Now
Questions 44

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?

Options:

A.

Use Automation Studio to capture positive response and a Case Activity to create a new case in Service Cloud.

B.

Use an Engagement Split to capture positive or negative responses, and a Case Activity to create a new case in Service Cloud.

C.

Use an Engagement Split to capture positive or negative responses, and a Custom Activity to create a new case in Service Cloud.

D.

Use an AppExchange package to create a customized API integration between Marketing Cloud and Service Cloud.

Buy Now
Questions 45

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?

Options:

A.

Use a text-response message template with embedded AMPscript to capture the response.

B.

Use an info capture message template to capture the response.

C.

Use an outbound message template with embedded AMPscript to capture the response.

D.

Use a vote/survey message template to capture the response.

Buy Now
Questions 46

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

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.

Buy Now
Questions 47

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)

Options:

A.

Journey Builder Decision Splits provide a method to access data of Tokenized data natively.

B.

Personalization Strings still allow PII to be displayed within an email.

C.

Service Level Agreements for email sends are unsupported with the inclusion of outside servers.

D.

Tokenized Sending should be combined with field-level data encryption for additional security.

Buy Now
Exam Name: Salesforce Certified Marketing Cloud ConsultantSFMCExam (SP25)
Last Update: Apr 27, 2025
Questions: 159

PDF + Testing Engine

$57.75  $164.99

Testing Engine

$43.75  $124.99
buy now Marketing-Cloud-Consultant testing engine

PDF (Q&A)

$36.75  $104.99
buy now Marketing-Cloud-Consultant pdf