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

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

Salesforce Certified Marketing Cloud Administrator (SP23) Questions and Answers

Testing Engine

  • Product Type: Testing Engine
$42  $119.99

PDF Study Guide

  • Product Type: PDF Study Guide
$36.75  $104.99
Question 1

A Marketing Cloud admin has been asked to include Sales Cloud data in their queries.

Which future would allow this functionality?

Options:

A.

Query Studio

B.

Journey Builder

C.

Cloud Pages

D.

Synchronized Data Sources.

Question 2

A marketing manager requests to receive an email, once a week, with high-level metrics in a standardized format. Specifically, the manager wants to know how many emails were sent in the last week.

What location and activity would allow the Marketing Cloud admin to complete this request?

Options:

A.

Email Studio: Select the "Account Send Summary*' in Tracking Reports and schedule a weekly report to be sent.

B.

Analytics Builder: Select the "Account Send Summary" in Reports and schedule a weekly report to be sent.

C.

Automation Studio: Create a Query Activity to query data from the "Sent" Data View, then use an Email activity to automate the sending of the data.

Question 3

A Northern Trail Outfitter’ (NTO) subscriber clicks a link in an NTO email. Prior to the clicking, the subscriber had a bounces status in Marketing Cloud.

What are the effects of the click to the subscriber’s status?

Options:

A.

Status is changed to Active and the bounce count is unchanged

B.

Status is changed to Held for 72 hours and the bounce count is set to Zero

C.

Status remains as Bounced the bounce count is unchanged

D.

Status is changed to Active and the bounce count is set to Zero

Question 4

Northern Trail Outfitters wants to add new data extensions containing customer purchases to their Marketing Cloud account

Which value should link these new data extensions in Data Designer to the existing contact records?

Options:

A.

Unique Contact Identifier

B.

Primary key

C.

Unique Contact email address

D.

Subscriber ID

Question 5

A Marketing Cloud admin needs to warm their accounts Dedicated IP.

What option for segmentation aligns with the IP Warming process?

Options:

A.

Segment to those recipients receiving text email versions first

B.

Segment subscribers with soft bounces in their own dedicated send

C.

Segment by domain to limit number of sends to each email provider

D.

Segment by geographic region as after-hours sends will be marked as spam

Question 6

A Consultant has a data extension that contains all current product information. The customer wants to refresh data each morning by importing a CSV containing today's product catalog. The product catalog is never the same; products can be added and removed. Which import type should be used?

Options:

A.

Overwrite

B.

Add Only

C.

Add/Update

D.

Update Only

Question 7

A customer team wants to retarget subscribers who click on links of key items promoted across email campaigns. The customer has indicated the following:

• Emails will be built using a custom dynamic template for these messages.

• Links will vary over time and across campaigns.

• Click activity will be cross-referenced with subscribers' regional markets on a master subscriber data extension.

• Retargeting messages will dynamically populate content based on regional market.

In order for this solution to be viable, which skill set does the customer team need to possess?

Options:

A.

AMPscript

B.

SSJS

C.

SQL

D.

HTML

Question 8

A customer will provide a single daily file on the Marketing Cloud SFTP at 3 AM and needs an alert if the file is not present on time. The file needs to be: Imported into a staging data extension. Separated into two different data extensions.

Which workflow should meet these requirements?

Options:

A.

Scheduled Automation: File Transfer Activity > Import File Activity > SQL Query Activity 1 > SQL Query Activity 2

B.

Scheduled Automation: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2

C.

File Drop Automation: Import File Activity > SQL Query Activity1 > SQL Query Activity 2

D.

File Drop Automation: File Transfer Activity > Import File Activity > Filter Activity > SQL Query Activity 1

Question 9

A Marketing Cloud admin is asked to add a set of four tracking parameters automatically to all the links in an email sent via email studio.

Which solution should the admin suggest?

Options:

A.

AMP script for Marketing Cloud

B.

Web Analytics Connector

C.

Google Analytics 360

D.

Marketing Cloud Connect

Question 10

Northern Trail Outfitters (NTO) uses data extensions for all of their email audiences. A customer reports they unsubscribed several week-end ago, but continue to receive NTO's daily digest at their old address. NTO's Marketing cloud Admin has confidently deleted them from present in the appropriate data extension.

What consideration could account for this behavior?

Options:

A.

Data retention settings were incorrect in the data extension.

B.

The email address in All Subscribers is prioritized.

C.

Contact Builder was not configured properly.

D.

The data extension was not configured as sendable.

Question 11

A large retail company has selected Marketing Cloud and has asked to be fully migrated from their existing platform in three weeks. They have communicated the following: They currently have 3 million customers. They email customers twice a week with no known deliverability issues. Their contract includes one Sender Authentication Package (SAP).

Which two responses articulate proper IP warming? Choose 2 answers

Options:

A.

IP ramp -up takes four to six weeks to be able to fully send to all 3 million customers.

B.

IP ramp -up can be accelerated by migrating to pre -warmed IP addresses.

C.

IP ramp -up can be bypassed, given their historical lack of deliverability issues.

D.

IP ramp -up is important to establish a positive sender reputation.

Question 12

A user asks Marketing Cloud admin to review their permissions since they are unable to send an email. The admin reviews the user profile and notices the user has three roles assigned: Content Creator, Data Manager, and Marketing Cloud Viewer.

What should the admin do to resolve the issue so the user can send an email?

Options:

A.

Edit permissions and Grant permissions to Send

B.

Edit permissions and deselect Deny for Email Sending

C.

Add the Role Marketing Cloud Channel Manager

D.

Remove the Marketing Cloud Viewer Role

Question 13

A Marketing manager requests to receive an email, once a week, with high-level

metrics in a standard format. Specifically, the manager wants to know how many emails

were sent in the last week.

What location and activity would allow the Marketing Cloud admin to complete the request?

Options:

A.

Automation Studio: Create a Report Activity to run every seven days.

B.

Email Studio: Select “Account Send Summary” in Tracking Reports and schedule a weekly report to be sent.

C.

Automation studio: Create a Query Activity to query data from the “Sent” Data view, then use an Email activity to activate the sending of the data.

D.

Analytics Builder: Select the “Account Send Summary” in Reports and schedule a weekly report to be sent.

Question 14

Northern Trail Outfitters wants to segment audiences based on SalesCloud data.

Where would their Marketing Cloud admin configure Sales Cloud Objects to be synced and leveraged in Marketing Cloud.

Options:

A.

Setup >Data Management > Synchronized Data Extensions

B.

Contact Builder > Data Extensions > Synchronized Data Extensions

C.

Contact Builder > Data Sources

D.

Setup > Apps > Salesforce Integration

Question 15

A Marketing Cloud admin to create custom roles for their business process.

What should be taken into consideration to accomplish this?

Options:

A.

Custom roles can only be edited by the user who created the role initially.

B.

Custom roles are only available within the business in which they were created.

C.

Custom roles are available on their Marketing Cloud account.

D.

Custom roles override an individual user’s granular permission assignments.

Question 16

NTO wants to format links for consumption by Google Analytics 360. NTO wants to make sure they do not have any data which could be considered Personally Identifiable information (PII) within their links.

Which three values could be used as personalization strings in query string parameters?

Choose 3 answers

Options:

A.

Product Code

B.

Application ID

C.

Subscriber ID

D.

Email Address

E.

Name

Question 17

Northern Trail Outfitters placed an encrypted file on their Marketing Cloud SFTP for import into a data extension. They are using a file transfer Activity to decrypt the file.

What would the decrypted data be after the File Transfer Activity completes?

Options:

A.

Selected SFTP folder

B.

Original SFTP folder

C.

Target Data Extension

D.

Safehouse

Question 18

What is Setup Assistant?

Options:

A.

Support service allowing the outsourcing of repetitive admin tasks

B.

A prioritized account configuration checklist

C.

A search within Help and Training limited to configuration documents

D.

A dashboard containing key metrics for the business unit

Question 19

A Marketing Cloud admin runs the Contacts Counts report and sees there are currently 500,000 contacts in their account. They have a total of 300,000 email subscribers, 200,000 synchronized contacts, and 75,000 mobile subscribers.

Why would the total contact count be less than the total number of contacts from all data sources?

Options:

A.

Synchronized contacts are only counted after sending

B.

Only active email subscriber is counted.

C.

Mobile subscribers are not counted as contacts.

D.

There are overlapping contacts in each of the channel

Question 20

NTO wants to copy journeys across business units.

What could be used to replicate journey structure so it can be easily recreated in another account?

Options:

A.

Journey Templates

B.

Deployment Manager

C.

Journey Extracts

D.

Copy activities

Question 21

A new employee is hired into the role of marketing analyst. This user should have access to all tracking data in Marketing Cloud, but no access to any send activities.

Which two default User Roles should be applied to this new user which provides this access to all channels, keeping the principle of least privilege in mind?

Options:

A.

Content Creator and Marketing Cloud Viewer

B.

Analyst and Marketing Cloud Viewer

C.

Data Manager and Analyst

Question 22

Northern Trail Outfitters has noticed an issue with their sends today.

Which two links in Setup Home could be used to troubleshoot the issue?!

Choose 2 answers

Options:

A.

Create Support Case

B.

Failed Sends

C.

Help and Training

D.

System Status

Question 23

Einstein Recommendations uses data extensions to store user-facing information

How is this data passed to Marketing Cloud?

Options:

A.

Google Analytics 360

B.

Collect Tracking code

C.

Conversion Tracking

D.

Web & Mobile Analytics

Question 24

Northern Trail Outfitters wants a data model in Marketing Cloud which will prevent them from duplicating, or even triplicating, records.

How should the unique identifier of the data model be setup if the Mobile Push and Email channels are used within the same account?

Options:

A.

Use the auto-generated keys supplied by Marketing Cloud at time of record creation for each channel used.

B.

Use a third-party system to identify and delete duplicate Contact Keys.

C.

Strategically control the Contact Key values and tie records together across channels using this key.

D.

Strategically control the Contact Key values in email, but let Marketing Cloud automatically tie records as needed from Mobile Push.

Question 25

Northern Trail Outfitters (NTO) is concerned about unauthorized API access to their Marketing Cloud account.

Which feature would NTO enable to assist in reducing threats from malicious API attacks?

Options:

A.

IP Whitelisting

B.

Field Level Encryption

C.

Advanced Audit Trail

D.

Single Sign on Authentication

Question 26

A Marketing Cloud admin at a bank is asked to avoid storing sensitive data in the

cloud. This data will only be sent to Marketing cloud to execute a send.

Which feature would the admin use to meet this requirement?

Options:

A.

Tokenized Sending

B.

List Sending

C.

Field Level Encryption.

D.

Distributed Marketing Sends.

Question 27

A Marketing Cloud admin is configuring the Marketing Cloud data model for the first time. Journey Builder with of messages being sent to customers, based on if there has been an order or not. There are two existing data model Orders:

- Customers contains information about subscribers including Email Address, First Name, Last name.

- Orders contains information about the orders and includes the unique identifier of the customer

In which two ways should the admin configure Data Designer to allow this data to be used within a journey?

Choose 2 answers

Options:

A.

Link the Customers data extension to the data model using Customer ID

B.

Link the Orders data extension to the Customers data extension using a Many-to-Many relationship

C.

Link the Orders data extension to the Customers data extension using a One-to-Many relationship

D.

Link the Customers data extension to the data model using Email Address

Question 28

A Contact Delete request has been processed for subscribers who have been sent an email. to previously in a northern action did NOT target all contacts in their account and a significant number of contacts which are still remaining.

Which two data would still exist in the account?

Choose 2 answers

Options:

A.

Contact-specific data at the job level

B.

Contact data in non-sendable data extensions

C.

General tracking data at the job level

D.

Contact data in sendable data extensions

Question 29

Northern Trail Outfitters has five business units in their Marketing Cloud account. All business units should be configured to use the same SFTP directory

How should this setup be achieved?

Options:

A.

Child business unit SFTP user should be created

B.

Copy the parent SFTP user into each child business unit

C.

Each business unit should have multiple SFTP users

D.

All child business units should have an individual SFTP user

Question 30

Northern Trail Outfitters has Imported a file Into All Subscribers. They then received a results file stating admin@example.com could NOT be imported.

Which error code would the file contain for this record?

Options:

A.

Restricted Values

B.

List Detective

C.

Invalid Email Address

D.

Skipped Records

Question 31

Setup Assistant provides information and resources for configuring a new Marketing Cloud account.

Which two topics does Setup Assistant cover?

Choose 2 answers

Options:

A.

Enabling Mobile Connect

B.

Managing the Enhanced SFTP

C.

Configuring Journey Builder

D.

Setting up the Data Structure

Question 32

Which Product enables a Marketing Cloud admin to observe customer behavior, build performance profiles and deliver the next best content?

Options:

A.

Content Builder

B.

Einstein Send Time Optimization

C.

Audience Builder

D.

Einstein Email Recommendations

Question 33

A Marketing Cloud admin is asked to understand how a certain content area within a Triggered Send Email is performing.

Which report should be used?

Options:

A.

Dynamic Content for Triggered Sends

B.

Sends Account Send Summary

C.

Impression Tracking for Triggered Sends

D.

Email Performance by Attribute

Question 34

Northern Trail Outfitters runs a nightly automation consisting of a File Transfer and a File Import. Following an update from the engineering team, the automation began failing. The Marketing Cloud admin suspects the CSV file now has an invalid format.

How could the admin receive a file of the bad data rows to confirm this theory?

Options:

A.

Move the File Transfer to its own automation and include a notification email address

B.

Move the Import definition to its own automation and include a notification email address

C.

Update the Import definition to include a notification email address

D.

Update the automation to include a notification email address for Runtime Errors

Question 35

Northern Trail Outfitters uses Marketing Cloud Connect to leverage Sales Cloud data in their journeys. a user recently reported the data coming from Sales Cloud is NOT up to date.

Where should the Marketing Cloud admin begin troubleshooting?

Options:

A.

Contact Builder > Synchronized Data Extensions

B.

Automation Studio > File Transfers

C.

Contact Builder > Data Sources

D.

Email Studio > Synchronized Data Extensions

Question 36

A Marketing Cloud admin is asked by the marketing team to ensure a default Header and Footer be added to emails.

Where under Setup could this be created?

Options:

A.

Content Builder Settings

B.

Emails Studio Settings

C.

Account Settings

D.

Campaign Settings

Question 37

A Marketing Cloud admin wants to ensure no one could access the API with their Marketing Cloud user credentials.

Which security setting would control this behavior?

Options:

A.

Select ‘Identity Verification’

B.

Select ‘Enable Audit Trail Data Collection’

C.

Deselect ‘Exclude API Users From Password Expiration’

D.

Deselect ‘Enable Username and Password for Web Services’

Question 38

A Marketing Cloud admin has scheduled a query on a daily basis. They notice the query sometimes fails to execute.

How would the admin ensure a notification is received when the query fails?

Options:

A.

Add their Email Address in the automation "Runtime Error or Skipped Run Notification Settings

B.

Install the Marketing Cloud App on phone to receive Push Messages

C.

Add their Email Address in the Query Activity Notifications Field

D.

Configure the "Event Notification Service" in Setup with their Email Address

Question 39

Northern Trail Outfitters has the Discover Reporting Tool.

Which two report types could help them drive mobile adoption strategy?

Choose 2 answers

Options:

A.

Time Between Send and Engagement

B.

Email Performance by Device

C.

Email Sending Performance Report

D.

Deliverability Complaint Rate

Question 40

A Marketing Cloud admin is using the Import Wizard to import data into a non-sendable data extension, but receives an error indicating the import type being used requires a primary key.

Which import type could the admin use instead?

Options:

A.

Add Only

B.

Overwrite

C.

Add and Update

D.

Update Only

Question 41

Northern Trail Outfitters wants to set up their Send Log data extension

Which three considerations should be made for long term success?

Choose 3 answers

Options:

A.

Apply an appropriately-scoped Data Retention period

B.

Add custom fields not included in the Send Log Template

C.

Log attribute data necessary for auditing communications

D.

Log all variable data captured in emails at send time

E.

Set the period to a fixed date in the Data Retention Policy

Question 42

Northern Trail Outfitters has Marketing Cloud users who need data extension View and Update permissions for campaigns related to B3C sales, out not any permissions for campaigns related to B2B sales.

How should they accomplish this?

Options:

A.

Create separate folders and add permissions

B.

Create a shared data extension

C.

Update data extension object level permissions

D.

Create a new business unit

Question 43

Northern Trail Outfitters (NTO) Is a global brand which Includes many subsidiary brands under the parent umbrella. NTO is the Enterprise business unit and also has a child business unit used for sending promotional email.

How should the rest of the business units be organized?

Options:

A.

Create child business units for each brand and nest another level of child business units for GEOs.

B.

Create and apply folders with naming conventions in the current account to keep track of brand assets.

C.

Create new Enterprise business units for each brand and child business units for each of the brand's GEOs.

D.

Create one child business unit for the other brands to share but apply folders and naming conventions.

Question 44

Northern Trail Outfitters (NTO) rolled out a global SMS initiative three months ago,

as their customers have shown great interest in receiving promotions via text. However,

NTO was notified they are already at 75% utilization for their annual Super Messages.

Why could this be the case?

Options:

A.

Mobile Push was enabled by mistake, which consumes Super Messages when not in use.

B.

Each email consumes five super messages when sending below a certain threshold.

C.

The majority of NTO’s subscriber base is in the United States.

D.

A multiplier is applied to each SMS message based on the destination country

Question 45

Northern Trail Outfitters wants to pass the email address of a subscriber to a landing page through a URL parameter from a promotional email.

Which Marketing Cloud capability allows for secure transmission of the email address?

Options:

A.

Cloud Pages URL AMP script function

B.

Web Analytics Connector

C.

Link Wrapping

Question 46

Which two data structures could be configured to appear In the out-of-the-box Subscription Center? Choose2 answers

Options:

A.

Data Extensions

B.

Publication Lists

C.

Lists

D.

Groups

Question 47

Northern Trail Outfitters wants to use Synchronized Data Sources to sync Contact data from Salesforce CRM. However, they only want to sync records they would be able to send to reducing the amount of data being brought over.

Which two filtering options could be used when configuring the Contact synced object?

Choose 2 answers

Options:

A.

Select all records which have opened an email in the past six months

B.

Select all records with an email address

C.

Select all records which are active in All Subscribers

D.

Select all records where Has OptedOutofEmail is FALSE

Question 48

A Marketing Cloud admin is configuring Social Studio to manage Northern Trail Outfitters social media accounts.

Which 2 prerequisites for configuring Social Studio should the admin consider? Choose 2 answers

Options:

A.

Bitly URL Shortener

B.

Facebook ad manager

C.

Login detail for each social media account

D.

Google URL Shortener

Question 49

What does Marketing Cloud authenticate when a user logs in through the user interface?

Options:

A.

If the user is assigned a role in the parent business unit

B.

If the user is logging in from a whitelisted IP address

C.

If the user is an API User on their record

D.

If the user has login hours enabled on their profile