Salesforce Certified Marketing Cloud Consultant Exam Dumps [2023]

Jonnie Karnath2023-06-06T07:23:29+00:00

Salesforce Certified Marketing Cloud Consultant Exam is a certification that validates the skills and knowledge of professionals who are working with Salesforce Marketing Cloud. This exam is designed to test their ability to configure and manage Marketing Cloud, as well as their expertise in implementing solutions for clients. Certspots is a website that offers a wide range of exam dumps for various certifications, including the Salesforce Certified Marketing Cloud Consultant Exam. Their Marketing Cloud Consultant exam dumps are designed to help candidates prepare for the actual exam by providing them with practice questions and answers that are similar to those found in the real exam. Using Marketing Cloud Consultant exam dumps from Certspots can be a valuable tool for candidates who want to increase their chances of passing the exam.

Page 1 of 5

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

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

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

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

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

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

Combine the data outside of Marketing Cloud and upload it into a Sendable Data Extension.

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

Create SQL Query Activities for the marketer to modify.

Link the data extensions in an Attribute Group.

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

A new Sender Authentication Package should be used for NT

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

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

A Sender Authentication Package should be used for CloudKicks.

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

They may utilize an external FTP site.

The directory Is unable to be used by another File Drop Automation.

The directory used by the file trigger should be inside the import directory.

The directory cannot contain more than five file triggers.

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

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

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

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

Cloud and Service Cloud

6. A small restaurant franchise wants to implement Marketing Cloud to support their franchise owners. The corporate office the advertising copy and subscriber list. The owners of franchised stores add a customized local message to the marketing campaign.

What hierarchy should be recommended?

One parent business unit and a child business unit for franchise owners.

One parent business unit and a child business unit for each franchise owners

One business unit.

A parent business unit for each franchise owner

7. Northern Trail Outfitters (NTO) send emails from Content Builder and Journey Builder. When subscribers reply to an email, NTO would like to send an auto-reply message using a pre-defined HTML email that explains email replies are unmonitored and they should call NTO for any inquiries.

How could these auto-reply messages be enabled?

From the Reply Mail Management settings page, choose the 'Create Custom Response' option under 'Automated Response Email for Remaining Replies' section and select the HTML email from the 'define email' link.

Create a Triggered Send and on the Reply Mail Management settings page, choose the 'Create Custom Response' option under 'Automated Response Email for Remaining Replies' section, then select the Triggered Send email.

Create a Triggered Send and from a Sender Profile properties page, enable 'Custom Reply Mail Management Settings', 'Use Auto Reply' and 'Reply using triggered send' options, then select the Triggered Send email.

Open Admin > Account Setting page in Email Studio and in the 'Auto Reply Email' section, select 'Custom' and paste the HTML email code into the text area field.

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 ans purchase data is stored in a second data extension.

Which two steps should they include to accomplish this journey?

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

Utilize Entry Data on a Decision Split within Journey Builder.

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

Configure activities within Automation Studio to update the purchase data.

9. A customer wants to reports on 'Not Sent' contacts in Journey Builder.

Which method should be used?

Use the standard report 'Subscribers Not Sent to'.

Use an automation with Tracking Extract.

Create an Analytics Builder Discover report.

Query the _sent Data View for the contact's send status.

10. Northern Trail Outfitters uses a Salesforce Data Entry Source in their Journey that injects Salesforce Order when they are either create update with a status of New, Currently Knitting, Shipped, and Complete. Their Journey works when orders are created, but they noticed it does not injected customers when their status is updated.

What could be causing this?

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

The associated Contact should be updated to be injected.

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

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

Page 2 of 5

11. Northern Trail Outfitters (NTO) wants email subscribers to adopt their app. They are investigating using MobileConnect features since over 90% of their subscribers provide a Mobile Phone Number when registering.

Which three considerations should be made before implementing MobileConnect? Choose 3 answers

Long and Short Codes are not available for all countries.

NTO would be charged by mobile operators directly for messages.

Inbound messaging only works with local Long or Short Codes.

Not all countries are supported by MobileConnect.

Opting in for messages can only be done via inbound message.

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

Salesforce Data Entry, SQL Query Activity, Task Activity

Scheduled Automation, SQL Query Activity; Data Extension Entry, Task Activity

API Event Entry, SQL Query Activity, Task Activity

Scheduled Automation, Filter Activity; Data Extension Entry, Contact Activity

13. Northern Trail Outfitters wants to import their Sales Cloud data into Marketing Cloud to leverage it within Journey Builder. They have approximately 10 million customers and the data needs to be available with a delay of no more than 30 minutes. Only customers where the consent checkbox is selected in Sales Cloud should be imported, which represents approximately half of their customer database

What should they implement?

All Subscribers, since these are synchronized in real time

Import from Salesforce Report in Automation Studio

Event Data from the Entry Event in Journey Builder

Synchronized Data Extensions with a filter

14. 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 information and a session ID field for each subscriber who has abandoned their cart.

• A second data extension contains a corresponding session ID field and product data for each abandoned cart item, including product SKU, product name, quantity, price, and image URL.

Which feature should be used to display the list of products for each subscriber in this email?

Lookup AMPscript function

LookupRows AMPscript function

Dynamic Content Block

Enhanced Dynamic Content Block

15. Northern Trail Outfitters want to query Marketing Cloud for send data across SMS, Push, and email.

What would a consultant recommend?

Send Logs

Tracking Extracts

Contact History

_Send Data Views

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

Node.JS

Apex

SSJS

GTL

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

Inject the subscriber into a Journey.

Use the Transactional Messaging AP

Execute a Triggered Emails Interaction.

Use a User-Initiated Emails Interaction.

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

What the offer will be

When to send the email

Who the offer come from

How to determine engagement

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

Does their License include time Large Extensions feature?

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

What time of day are the API calls made?

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

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

Data Filters

Attribute Groups

Publication Lists

Query Activities

Page 3 of 5

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

Salesforce Campaign Entry Source on the Lead Object

Salesforce Data Entry Source on the Contact Object

Salesforce Data Entry Source on the Account Object

Welcome Email Configuration on the Account Object

22. When Northern Trail Outfitters acquires a new customer, it would like to send a series of welcome messages on behalf of the brand with an optimized send time. New customers will be sent to Marketing Cloud via an hourly batch file drop.

Which solution should the consultant recommend?

Use Journey Builder to process and segment the new customers, and for the campaign sends and decisioning.

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

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

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

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

An additional IP address

An additional Sender Authentication Package

An additional private domain

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

Import Activity

Verification Activity

Data Extract Activity

Filter Activity

25. 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 60days. 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?

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

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.

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

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

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

Report Definition Activity

SendLog Extract

Data Extract Activity

SQL Query Activity

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

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

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

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

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

28. Northern Trail Outfitters receives data from their point-of-sale system every night. The file is placed on their Enhanced FTP, but there is not a consistent time or naming convention for the file.

In which two ways should they set up their automation to import the data from the file on a nightly bais? (Choose 2 answers)

%%BASEFILENAME_FROM_TRIGGER%%

%%BASEFILENAME_FROM_FILEDROP%%

Scheduled Starting Source

File Drop Starting Source

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

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

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

The previous send used Email Address as a Subscriber Key.

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

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?

Datorama

Data Studio

MuleSoft Anypoint Platform

Data Connector

Page 4 of 5

31. 1.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

Synchronized Data Sources only push data every 15 minutes

ContactID was used as Subscriber Key

Email Address was used as Subscriber Key

Individual Level Tracking was not selected in Marketing Cloud Configuration

32. Northern TrdH Outfitters (NTO) racentfy launched a MR loyalty program. NTO wants to offer a signup bonus to subscribers who have made purchases In the last 6 months, but are yet to be loyalty members.

Which integration should allow NTO to select an audience of these subscribers'

Behavioral Triggers

Advertising Studio

Markating Coud Customar Data Platform

Contact Builder Attribute Groups

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

Create additional attribute fields in the main contact data extension.

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

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

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

34. Northern Trail Outfitters recently purchased Marketing Cloud to start running cross-channel campaigns. They are looking for guidance on which value to use as the subscriber key.

Which two options should the consultant recommend? (Choose 2 answers)

CRM ID

Mobile Device ID

Loyalty Program Number

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

What the offer will be

When to send the email

Who the offer come from

How to determine engagement

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

Salesforce Data Extension

Salesforce Report

Synchronized Data Extension

Salesforce Campaign

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

A Transactional Journey with the Not Sent Notification activity included

A Datorama instance to ingest their data

An external system to receive and confirm callback and subscriptions

An Interaction Studio instance to ingest their data

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

Configuration Manager

Change Sets

Deployment Manager

Ant Migration Tool

39. Northern Trail Outfitters wants to its emails to be redirected to Marketing Cloud server* for processing.

Which configuration setting should the consultant recommend'

Reply Mail Management

Private Domains

Sender Authentication Package

Custom Delivery Profiles

40. A data team wants to automate that sync of subscribers' Unsubscribes and status from their enterprise account to their external CRM In one consolidated file. They need to find subscribers In their Marketing Cloud account and their unsubscribe data for child business units.

Which two data views would they use to achieve this? Choose 2 answers

_Complaint

_Subscribers

_Unsubscribe

_BusinessUnitUnsubscribes

Page 5 of 5

41. Northern Trail Outfitters (NTO) is the holding company of three subsidiaries: Universal Containers, Ursa Major Solar, and Cloud Kicks. NTO recently purchased Marketing Cloud and has asked its consultant to recommend a scalable business unit (BU) hierarchy. They don't plan on executing any marketing campaigns on behalf of the NTO holding company, but NTO employees would like access to all subscribers and aggregate reporting. Additionally, each subsidiary business will be regularly running campaigns and should have their own branding, content, and subscribers.

Which solution should the consultant recommend?

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

One parent BU with three additional private domains.

One parent BU and one child BU

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

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

Scheduled Automation

File Drop Automation

SQL Query

Decision Split

43. 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'?

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

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

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

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

44. An analytics team wants to get real-time updates on transactional email metrics, specifically Sent and Not Sent, to ensure they are fulfilling a legal obligation due to the nature of their messages.

Event Notification Service

Platform Events API

Data View Export with every send

Data Retrieves on the Send Object

45. Northern Trail Outfitters (NTO) is creating a birthday journey and one of the requirements is to divert anyone who has redeemed the promotional code before reminder emails are sent on the 15th and 20th of each month. Their transactional information, which includes redeemed promo codes, Is housed in a separate data extension than the one used for Journey injection. NTO needs to use an attribute to attribute comparison on the customer number field in the Journey source and transaction data extensions.

Which activity would they use to accomplish this?

Decision Split Activity using only Contact Data

Decision Split Activity using only Journey Data

Einstein Split Activity

Decision Split Activity using both Contact and Journey Data

46. Northern Trail Outfitters has master data extension of 880,000 subscribers they want to randomly split into 11 groups to test different messaging strategies.

How could this be accomplished?

Use Automation Studio with a random split activity.

Create a random data extension within Email Studio.

Create a random data extension within Contact Builder.

Use Journey Builder with a random split activity.

Facebook Twitter LinkedIn Google + Email