Pre-Winter Sale 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Free and Premium Salesforce Marketing-Cloud-Consultant Dumps Questions Answers

Salesforce Certified Marketing Cloud ConsultantSFMCExam (SP25) Questions and Answers

Question 1

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
Question 2

Northern Trail Outfitters (NTO), a longtime Marketing Cloud customer, has decided to adopt Journey Builder to help with the execution of their marketing programs. NTO does not want to duplicate efforts within the platform and has asked if they could stop using Automation Studio entirely.

Which three tasks would a consultant suggest for using Journey Builder instead of Automation Studio? (Choose 3 answers)

Options:

A.

Building simple segmented campaigns without SQL queries

B.

Designing decision logic via an intuitive user interface

C.

Setting behavior-based goals

D.

Processing zipped encrypted files containing subscriber data

E.

Creating customer segments from multiple data extensions

Question 3

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.

Question 4

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 Testing'.

C.

Create one or more additional business units for testing.

D.

Use Subscriber Filter per business unit to filter production from test data.

Question 5

Northern Trail Outfitters (NTO) wants to send using the From Address of marketing@email.nto.com. They will then automatically forward replies to customerservice@nto.com. NTO also wants to include an automatic reply to the customer's email address customer@example.com.

Which email address would appear as the From Address for the automatic reply to the customer?

Options:

A.

customerservice@nto.com

B.

reply@marketingcloud.com

C.

customer@example.com

D.

marketing@email.nto.com

Question 6

A customer has been having problems with SMS responses getting the default keyword response rather than the appropriate next keyword response.

What are two potential reasons for this unexpected response? (Choose 2 answers)

Options:

A.

Responses are not sent within the Conversation Window.

B.

Responses are not sent within 24 hours of the outbound message.

C.

Next keyword was not specified on the outbound message.

D.

Response contained "stop" in the message content.

Question 7

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.

Question 8

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.

Question 9

Northern Trail Outfitters receives a nightly encrypted unsub file to their Marketing Cloud SFTP from a third-party email platform. These files are used to unsubscribe existing subscribers. They do not use Email Address as Subscriber Key.

What Automation Studio Activity sequence should be used to ensure the appropriate subscribers are unsubscribed from the All Subscriber List?

Options:

A.

Import File > Data Extract > File Transfer > Import File

B.

File Transfer > Import File > Query > Data Extract > File Transfer > Import File

C.

Import File > Query > Data Extract > File Transfer > Import File

D.

File Transfer > Import File > Data Extract > File Transfer > Import File

Question 10

Northern Trail Outfitters (NTO) wants to implement an abandon cart journey. The data for the journey exists in three separate data extensions (DE).

    The first DE is populated by web analytics data and does not contain a Subscriber Key or Email Address value.

    A Customer Reference DE is updated daily and holds subscriber information.

    The third DE is populated by a file sent to the SFTP after five days if the customer has not purchased the abandoned items.

    The third DE will be used in the journey for a decision split, and it does not contain a Subscriber Key or Email Address.

    If the web analytics file is empty, NTO does not want the automation to finish running.

Which order of activities should be used to fulfill this requirement?

Options:

A.

Scheduled Automation > Import File Activity > Data Extension Entry > Query Activity for file one > Query Activity for file two

B.

File Drop Automation > Import File Activity > Verification Activity > Query Activity for file one > Query Activity for file two > Data Extension Entry

C.

File Drop Automation > Verification Activity > Query Activity for file one > Data Extension Entry > Query Activity for file two

D.

Scheduled Automation > Import File Activity > Verification Activity > Data Extension Entry > Query Activity for file one > Query Activity for file two

Question 11

Northern Trail Outfitters uses a Salesforce Data Entry Source in their Journey that injects Salesforce Orders when they are either created or updated with a status of New, Currently Knitting, Shipped, and Complete.

Their Journey works when orders are created, but they noticed it does not inject customers when their status is updated.

What could be causing this?

Options:

A.

Orders should be set up to allow injection upon update in Connect Configuration

B.

The associated Contact should be updated to be injected.

C.

Synchronized Data Sources poll changes every 15 minutes at the quickest.

D.

Orders are not being updated from not meeting criteria to meeting criteria

Question 12

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?

Options:

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.

Question 13

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.

Question 14

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

Question 15

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

Question 16

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.

Question 17

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

Question 18

A customer has a business requirement to exclude email addresses of certain contacts in their loyalty program from sends with several sender profiles. These contacts are dynamically identified with the help of the SQL query on a daily basis.

What solution should be recommended to automate exclusion of the identified email addresses from all future sends that use specific sender profiles?

Options:

A.

Publication list

B.

Exclusion data extension

C.

Auto-suppression list

D.

Suppression list

Question 19

Northern Trail Outfitters (NTO) wants to send out 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?

Options:

A.

Einstein Split Activity

B.

Decision Split Activity using only Contact Data

C.

Decision Split Activity using both Contact and Journey Data

D.

Decision Split Activity using only Journey Data

Question 20

A customer wants to create a mobile app that requires users to log in or register before accessing their data. Their source of truth is Sales Cloud, which is connected to Marketing Cloud. Users who log in with existing credentials will have their device associated with their ContactKey. Users who register with the mobile app will not have their devices associated with a ContactKey for up to 24 hours.

What consideration should a consultant provide to the customer?

Options:

A.

User device data is unavailable in Contact Builder for up to 48 hours

B.

All mobile app users will create additional Contacts in Marketing Cloud

C.

Existing users will create additional Contacts in Marketing Cloud

D.

Newly registered users will create additional Contacts in Marketing Cloud

Question 21

Northern Trail Outfitters (NTO) uses the SAP domain comms.nto.com and has just opened an office in Australia. They want to use the domain comms.nto.com.au to send emails to the Australian customers.

What would be required to enable sending emails from their new domain without impacting deliverability?

Options:

A.

An additional Sender Authentication Package

B.

An additional IP address

C.

An additional private domain

D.

Register the new domain in Setup’s From Address Management

Question 22

Northern Trail Outfitters wants to control what content is available to certain users and business units. They also want to control what is allowed to be edited and ensure those edits are reviewed prior to being changed.

What should be implemented to achieve these goals?

Options:

A.

Build out an internal business governance and process to support this.

B.

Set up Approval Workflow and Share setting inside Marketing Cloud.

C.

Integrate an outside CMS with all these permissions built in.

D.

Edit the Content Permissions and Restrictions by Role setting for each user.

Question 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 that sends emails specific to the purchase, such as the type of tent, recommended accessories, and care tips at different points throughout the Journey.

NTO also recognizes that due to their pricing strategy, customers may purchase more than one tent within a month.

What type of data should be used in the Decision Splits in their Journey to make sure the choices reflect the correct tent?

Options:

A.

Journey Data

B.

Salesforce Data

C.

Contact Data

D.

Entry Data

Question 24

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

Question 25

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

Question 26

Northern Trail Outfitters (NTO) is launching a new campaign that will collect subscriber information to better target and segment its marketing communications.

NTO wants to target users of its app and social platforms who have not engaged with previous emails in the campaign. If the subscriber opens or clicks after three messages, they will be removed from the campaign.

Which solution should the consultant implement?

Options:

A.

A File Drop Automation with Filtered Data Extensions

B.

User-Initiated Send Definition with User-Initiated Send Definitions

C.

A Multi-Step Automation with User-Initiated Send Definitions

D.

A Multi-Step Journey with Data Extension/Automation entry source

Question 27

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

Question 28

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?

Options:

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.

Question 29

Northern Trail Outfitters is sending Salesforce Triggered Sends using Marketing Cloud Connect. The sends have a status of failed.

What should the consultant do to diagnose the issue?

Options:

A.

Review Apex Jobs within Setup in Sales Cloud.

B.

Manually clear the OAuth token to refresh the connection.

C.

Change the connection option to Scope by User.

D.

Ensure the System User is assigned the Standard User Profile.

Question 30

A customer is creating a re-engagement campaign. The campaign only targets subscribers who have had emails fail at send time due to Held status within the last 60 days. The goal is to send an SMS to the subscribers asking them if they want to update their email address.

What should a consultant recommend to meet the criteria?

Options:

A.

Use SQL Query and Import activities from Automation Studio to inject the subscribers into a data extension used as an Entry Source by Journey Builder.

B.

Use Tracking Extract, File Transfer, and Import activities from Automation Studio to inject the subscribers into a data extension used as an Entry Source by Journey Builder.

C.

Use Data Extension Extract and Import activities from Automation Studio to inject the subscribers into a CloudPage used as an Entry Source by Journey Builder.

D.

Use SQL Query and File Transfer activities from Automation Studio to inject the subscribers into an API Event used as an Entry Source by Journey Builder.

Question 31

A consultant configured a triggered send definition in Sales Cloud for a customer using Marketing Cloud Connect. The trigger is on a Custom Object called 'Shipments' and is enabled for Triggered Sends in Setup.

Which two configuration requirements should be considered when troubleshooting? (Choose 2 answers)

Options:

A.

The Shipment object is on the Account Related List.

B.

There is a Master Detail Relationship from Contact to Shipment.

C.

The Shipment object requires a Lookup to Lead or Contact.

D.

An Apex Trigger is created on the Shipment object.

Question 32

A service team manages their field technicians in Salesforce CRM connected to Marketing Cloud. Once an appointment with a contact is scheduled for the technician through CRM, a notification message should be sent to the contact informing them about the scheduled visit date. When the notification is sent, the “Confirmation Sent” checkbox on the appointment record should be updated in CRM.

All appointments scheduled on a given day will have their status updated in CRM at the end of business hours. The Appointment object does not have a direct relationship with the Contact.

What solution would a consultant recommend to address this use case?

Options:

A.

Configure journey with Salesforce Data entry source; use Journey Builder activities to send notification and update CRM records.

B.

Configure journey with API Event entry source; Process Builder to trigger event; use Journey Builder activities to send notification and update CRM records.

C.

Configure journey with Data Extension entry source; use Automation Studio activities to refresh the audience and Journey Builder activities to send notification and update CRM records.

D.

Configure Salesforce Send with Salesforce data extension, using Automation Studio activities to refresh the audience; send notification and SSJS activity to update CRM records.

Question 33

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.

Question 34

Northern Trail Outfitters wants 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.

Question 35

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

Question 36

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.

Question 37

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.

Question 38

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."

How should they set this up?

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 Wizard.

Question 39

Northern Trail Outfitters wants to query Marketing Cloud for send data across SMS, Push, and Email.

What would a consultant recommend?

Options:

A.

Send Logs

B.

Tracking Extracts

C.

Contact History

D.

_Send Data Views

Question 40

Northern Trail Outfitters wants to have a periodic, dynamic newsletter sent to a set data extension, but the data in this data extension will be regularly updated, and the subscribers inside could be removed/added multiple times.

What option should speed up the delivery while meeting these criteria?

Options:

A.

Journey that allows re-entry after exiting

B.

Scheduled Automation utilizing Triggered Send Emails

C.

Scheduled Automation using a Send Activity

D.

Single Send Journey

Question 41

Northern Trail Outfitters (NTO) wants to send out a communication to subscribers who have not made a purchase in the last six months. Customers are often opted into more than one messaging channel. NTO would like to be able to communicate the same message across all channels.

Which flow would meet their needs?

Options:

A.

Query Activity > API Event > Automation Studio Activities

B.

Import Activity > Decision > Journey Activities

C.

Query Activity > Data Extension Entry Source > Journey Activities

D.

Salesforce Entry Event > Query Activity > Automation Studio Activities

Question 42

Northern Trail Outfitters' account is configured with Multi-Org to leverage two Salesforce CRM accounts. In the Cloud Kicks business unit, they want to disconnect the sandbox instance and connect the production instance.

What additional configuration changes could be made to avoid any disruption of functionality?

Options:

A.

Configure Multi-Org settings to account for both production instances in Setup.

B.

Manually remove existing user mappings, attribute mappings, and tracking subscriptions.

C.

Rename and delete sandbox synchronized data extensions before connecting.

D.

Update query activities that reference the new synchronized data extensions.

Question 43

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.

Question 44

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 should they use to format the JSON within the email?

Options:

A.

SSJS platform function ParseJSON

B.

TransformJSON() AMPscript Function

C.

BuildRowSetFromJSON() AMPscript Function

D.

ParseJSON content block with Content Builder

Question 45

Northern Trail Outfitters wants to send a welcome email to Contacts when a Contact record is added as a campaign Member to a 'Loyalty Member' Campaign in Sales Cloud.

Which method should they use to send the email from Marketing Cloud?

Options:

A.

Create a scheduled Automation with a Query Activity and a Send Email Activity

B.

Use Content Builder Send Flow to send the email to the Salesforce Campaign

C.

Create a Journey with a Salesforce Campaign entry source and an Email Activity

D.

Create a Journey with a Salesforce Data entry source and an Email Activity

Question 46

Scenario: Northern Trail Outfitters (NTO) is migrating to a single global Marketing Cloud instance and needs to determine the appropriate number of Business Units (BUs) to purchase.

Which three factors should be considered before finalizing the number of business units they need to purchase?

(Choose 3 answers)

Options:

A.

Number of brands/geographies which NTO operates

B.

Number of Sales Cloud sandboxes

C.

If testing/development business unit(s) are required

D.

If data/content needs to be segregated between brands/geographies

E.

Number of Marketing Cloud users

Question 47

Scenario: NTO is creating a birthday journey and wants to divert contacts who have redeemed a promotional code before sending reminder emails on the 15th and 20th of each month. The transactional information is stored in a separate data extension from the journey's entry source. They need to compare the customer number field between the journey source and transaction data extensions.

Which activity would they use to accomplish this?

Options:

A.

Decision Split Activity using only Contact Data

B.

Decision Split Activity using only Journey Data

C.

Einstein Split Activity

D.

Decision Split Activity using both Contact and Journey Data

Question 48

Northern Trail Outfitters has several business units (BUs) and each BU uses specific data extensions, like Product Information.

How should they configure these data sources?

Options:

A.

Share data extensions from the top-level BU.

B.

Create a local copy of the product data in each BU.

C.

Use the File Transfer Activity to import data into each BU.

D.

Give users the Administrator Role so they can see all of the data.