Labour Day Special Limited Time Flat 70% Discount offer - Ends in 0d 00h 00m 00s - Coupon code: 70spcl

Salesforce Marketing-Cloud-Consultant Salesforce Certified Marketing Cloud Consultant Exam (SP23) Exam Practice Test

Page: 1 / 16
Total 156 questions

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

Question 1

Northern Trail Outfitters (NTO) has recently Marketing Cloud and wants to securePII data stored within the system.

Which limitation should the consultant consider when recommending field-Level Encryption?

Options:

A.

Field-Level Encryption doesn’t support segmenting, filtering, or querying encrypted fields.

B.

Encrypted fields will show unencrypted values in standard records.

C.

Only list-based sending is supported by field-Level Encryption.

D.

Separate encryption keys are required for each business unit NTO .... Field_Level Encryption for

Question 2

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 contacts7

Options:

A.

Verification Activity

B.

Script Activity

C.

Query Activity

D.

Stop Activity

Question 3

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.

Question 4

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

Question 5

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 month-long welcome Journey which sends emails specific to the purchase such as the type of tent, they average accessories for the tent, and care of the tent at different points throughout the Journey. NTO also reorganizes that due to their .. princes, 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?

Options:

A.

Journey Data

B.

Salesforce Data

C.

Contact Data

D.

Entry Data

Question 6

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 7

Northern Trails Outfitters has a contact count of nearly 10 million records. They have noticed slower processing times when sending using Journey Builder.

Which two actions could they take to optimize Journey performance? (Choose 2 answers)

Options:

A.

Perform large-scale segmentation in Automation Studio before admitting contacts into Journey Builder.

B.

Use Data Extension Entry Sources with Filters applied to perform segmentation activities for Journey Builder.

C.

Include data for decision splits in Attribute Groups in Contact Builder, use contact data rather than journey data.

D.

Create a prefiltered, sendable copy of data extensions for each journey instead of using the same entry source.

Question 8

Northern trail Outfitters in expending globally into 16 new countries and wants to start localizing their email content to speak to subscribers in their own language. The wants to do this as efficiently as possible and are anticipating growth into other locales in the near future.

Which two options could be recommended?

Choose 2 answers

Options:

A.

Leverage personalization strings within the email template to pull in language-specific content.

B.

Leverage AMPscript within an email template to lookup subscriber language and personalize the email based on the value.

C.

Leverage Concept Builder to create email templates for each individual language and populate the templates via the UI.

D.

Leverage enhanced dynamic content Mocks within Content Builder to create language-specific emails.

Question 9

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

Question 10

Northern Trail Outfitters recently upgraded their preference center to allow customers to indicate which products they are interested in and to have the ability to opt up and down in send volume. They would like to configure the Delivery Options in a Journey Builder Email Activity to take these new data points into account.

Which two options could allow them to meet the requirement?

Choose 2 answers

Options:

A.

Suppression List

B.

Publication List

C.

Auto-Suppression List

D.

Domain Exclusion

Question 11

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

Question 12

Northern Trail (NTO), a longtime Marketing Cloud customer, has decided to adopt Journey Build 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 be using Automation Studio entirely.

Which three tasks would a consultant suggest for using Documentary Builder instead of Automation Studio?

Choose 3 Answers

Options:

A.

Building simple segmented campaigns without SQL queries

B.

Designing decision logic via an ... user interface.

C.

Setting behavior-based goals

D.

Processing zipped encrypt

ed files containing subscriber data

E.

Creating customer segments from multiple data extensions

Question 13

Northern Trail Outfitters' marketing team is made up of a marketing manager, a marketing 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?

Options:

A.

Data Filters

B.

Attribute Groups

C.

Publication Lists

D.

Query Activities

Question 14

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.

Question 15

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.

Question 16

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 Step journey with Salesforce Campaign as an entry event

D.

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

Question 17

Northern Trail Outfitters has started the process of integrating its Marketing Cloud account and Sales Cloud org through Marketing Cloud Connect.

Which configuration should be utilized for the API user created in Marketing Cloud?

Options:

A.

API User checkbox is selected, no roles are assigned to user.

B.

API User checkbox is selected

Administrator & Marketing Cloud Administrator roles are applied.

C.

API User checkbox is deselected, Marketing Cloud Viewer role is applied.

D.

API User checkbox is deselected, all available roles are assigned to user.

Question 18

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.

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

Question 19

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.

Question 20

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

Question 21

Northern Trail Outfitters (NTO) uses the SAP domain comms.nto.com and has just opened an office in Australia. They have created a business unit for their new office and want to use the domain comms.nto.com.au to send emails to their Australian customers.

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

Options:

A.

An additional IP address

B.

An additional Sender Authentication Package

C.

An additional private domain

D.

Register the new domain in Setup > From Address Management

Question 22

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.

Question 23

Northern Trail Outfitters has several business units (BU) 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.

Question 24

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 25

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 should they make?

Options:

A.

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

B.

Rename and delete sandbox synchronized data extensions before connecting.

C.

Remove existing user mappings, attribute mappings, and tracking subscriptions.

D.

Update query activities that reference the synchronized data extensions.

Question 26

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?

Question 27

Northern Trail Outfitters (NTO) wants to create a relevant audience from a data extension for a daily send campaign. The audience will change from day-to-day. These emails contain a View As Web Page link and NTO wants to ensure this will not be broken when the audience is refreshed daily.

What should be used to segment this audience?

Options:

A.

Use exclusion lists for the send - excluding those that already were sent the email

B.

Use AMPscript inside the email to pull information from a send logging data extension to determine which content displays based on message context

C.

Use a SQL Query to filter the audience into a new data extension that is overwritten each day

D.

Use SQL Query to filter the audience into a new data extension that is upserted every day

Question 28

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?

Question 29

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 30

Northern Trail Outfitter wants to integrate Marketing Cloud with it existing point-of-sale system in order to email purchase receipts to it customers. The point-of-sale data will need to be transformed to be received by the Marketing Cloud triggered send API.

What extension product should be used to accomplish this integration?

Options:

A.

Datorama

B.

Data Studio

C.

MuleSoft Anypoint Platform

D.

Data Connector

Question 31

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

Options:

A.

Scheduled Automation

B.

File Drop Automation

C.

SQL Query

D.

Decision Split

Question 32

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 33

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.

Question 34

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

Question 35

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

Question 36

Northern Trail Outfitters (NTO) wants to use Marketing Cloud to .. 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 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

Use an AppExchange package to create a new case in Service Cloud.

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

Question 37

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.

Question 38

Northern Trail Outfitters wants to export a data file to its SFTP using Automation Studio. The file should contain all subscribers who did not receive their intended email in the last 24 hours. The automation will be scheduled to run each day.

Which activity Is required in the automation?

Options:

A.

Report Definition Activity

B.

SendLog Extract

C.

Data Extract Activity

D.

SQL Query Activity

Question 39

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 40

Northern Trail Outfitters wants to its emails to be redirected to Marketing Cloud server* 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

Question 41

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

Question 42

Northern Trail Outfitters received a complaint today from a customer who received an email after unsubscribing last week. Today's email was sent using Marketing Cloud Connect (MCC), though last week was sent when an external system dropped a file on the Marketing Cloud SFTP and triggered a User-Initiated Send through an automation.

What could be the reason the customer received the email through MCC?

Options:

A.

The previous send's user needed to have edit permissions in Salesforce,

B.

Email Opt Out is only updated if the send originates in Salesforce.

C.

The previous send used Email Address as a Subscriber Key.

D.

The Email Opt Out field needs to be added to the Contact Page Layout.

Question 43

Northern Trail Outfitters (NTO) maintains a blog for key outdoor enthusiast influencers to use in sharing their experiences with NTO equipment and the outdoors. NTO also sends out a weekly email newsletter, and they want to include links to the latest blog entries as part of the newsletter.

Which two solutions could pull in the RSS feed at the time of send?

Choose 2 answers

Options:

A.

Dynamic Content

B.

AMPscript

C.

Personalization Strings

D.

External Content

Question 44

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.

Question 45

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.

Page: 1 / 16
Total 156 questions