March Sale Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Salesforce Marketing-Cloud-Administrator Dumps

Salesforce Certified Marketing Cloud Administrator (SP23) Questions and Answers

Question 1

A Marketing Cloud Admin has noticed a File Drop Automation has been failing on

the import File activity. The automation is configured with a filename pattern, so the

filename is expected to begin with customer_import_. The import is configured to look

for a file named customer_import_%%Year%%%%Month%%%%Day%%.csv,

however, the admin notices the filenames include seconds and milliseconds.

How should the admin fix the issue?

Options:

A.

Use the exact filename used for the trigger in the import File Activity

B.

Make sure the file is placed on the correct subfolder within the SFTP

C.

Make sure the filename has a date stamp to avoid duplication

D.

Use %%FILENAME_FROM_TRIGGER%% in the import File Activity

Question 2

During discovery, the customer outlines data requirements and the anticipated use of Marketing Cloud with the following criteria:

• Customer data will be fully refreshed every night via Import activity from the customer's data warehouse.

• Contact records will be augmented by relational data tables via Contact Builder.

• The customer data file will contain 5M records with 40+ attributes.

• One attribute will house HTML code, 1000 characters max, that will be used to populate Account Access content areas in emails.

• A customer ID will be used as the unique identifier for each contact.

Which statement differentiates the use of data extensions over lists?

Options:

A.

Data extensions allow for add/update Import activity.

B.

Data extensions can store HTML code as an attribute.

C.

Data extensions support Customer ID to be used as Subscriber Key.

D.

Data extensions are necessary for Contact Builder

Question 3

A Marketing Cloud admin discovers large sends are not meeting send speed goals set by the organization.

What functionality would get messages out the door faster?

Options:

A.

Burst Sending

B.

Journey Builder Triggered Sends

C.

Send Throttling

D.

Marketing Cloud Connect

Question 4

To prevent retention of stagnant data, Northern Trail Outfitters (NTO) wants any

inactive data stored in data extensions to be cleared after 12 months.

What action should NTO take?

Options:

A.

Configure the business unit data retention setting to 12 months

B.

Configure the Enterprise-wide default retention to one year

C.

Set inactive date to be automatically cleared after one year, but is recoverable

D.

Apply a row-based retention to each data extension as it is created, set to 12 months

Question 5

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 6

A Marketing Cloud Administrator noticed a File Drop Automation has been falling on the Import File activity. The automation is configured with a filename pattern, so the filename is expected to begin with customer import_. The import is configured to look for a file named Customer import %%Year%%%% Month%%%%Day%%.csv, however, the admin notices the filenames Include seconds and milliseconds

what should the admin do to fix the issue?

Options:

A.

use %%FILENAME_FROM_TRIGGER%% in the Import File Activity

B.

Make sure the team has a date stamp to avoid duplication

C.

Make sure the files are placed in the correct subfolder within the SFTP

D.

Use the exact file name used for the trigger in the Import File Activity

Question 7

Northern Trail Outfitters needs to reduce the amount of work when managing messages to customers, but cannot add any more personnel due to budget constraints. There has been an increased number of customer purchases on their website, and the team currently sends batch order confirmations. What solution will decrease manual workloads on the team and will improve their customers experience?

Options:

A.

A file drop automation to send emails to customers who have made a purchase.

B.

A user -initiated message to send an email to customers who made a purchase daily.

C.

A scheduled automation to send emails to customers who made a purchase daily.

D.

A triggered message to send an email as soon as a customer completes a purchase.

Question 8

Northern Trail Outfitters requires all subscriber files placed on the SFTP for import be encrypted.

Which activity in Automation Studio could be used to decrypt the file to prepare for Importing?

Options:

A.

Import Activity

B.

Data Extract Activity

C.

File Transfer Activity

D.

Decryption Activity

Question 9

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 10

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

Question 11

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 12

A university plans to use Journey Builder to improve their 1:1 marketing to potential students, current students, and alumni. The university currently has student data in the Sales Cloud. Other data, such as course catalog, student demographics, and alumni information, is stored in external systems.

Which two actions should the implementation Consultant recommend?

Choose 2 answers.

Options:

A.

Use Data Designer to link student and alumni data to the contact record.

B.

Create an Import Activity to import alumni data into Salesforce Report.

C.

Create list attributes to store student data from the Sales Cloud.

D.

Use Synchronized Data Sources to data from the Sales Cloud.

Question 13

A Marketing Cloud admin wants to automatically unsubscribe customers who respond to marketing emails asking to be removed from the mailing list.

Which two steps should the admin take to enable this functionality?

Choose 2 answers

Options:

A.

Ensure a Custom response is enabled for Automated Response in Reply mail Management

B.

Verify Reply Mail Management has been enabled in the account

C.

Select Unsubscribe Manual requests in Reply Mail Management

D.

Select Delete Auto-Replies and Out-of-Office mail Management

Question 14

A customer is interested in designing a solution to ensure that subscribers only receive categories of emails that they want to receive. The built-in subscription center will be used as part of the solution.

Which feature should be utilized to make this happen?

Options:

A.

Publication Lists

B.

Subscriber Keys

C.

Profile Center

D.

Send Logging

Question 15

Northern Trail Outfitters (NTO) uses Sender Authentication Package (SAP) for branding purposes. Their German business unit is configured with the SAP domain de.ntomarketing .com.

The German NTO team is preparing for a campaign and wants to use customized Cloud Pages with the domain de-special.ntomarketing.com.

How could the Marketing Cloud admin meet this requirement?

Options:

A.

Purchase a new SAP for de-special.ntmarketing.com

B.

Purchase a new private Domain for use in CloudPages

C.

CloudPages must use the SAP domain

D.

CloudPages must use pages.ntmarketing.com

Question 16

While setting up Marketing Cloud Connect, a Marketing Cloud admin navigates to the Marketing Cloud tab in Sales Cloud to complete the integration. The admin then receives the following error message:

- Insufficient User Permissions. You have not been designated as an integrated Marketing Cloud user. Contact your system administrator

The admin notices the Marketing Cloud for AppExchange Admin option is selected when looking at the user settings

What action should correct the issue?

Options:

A.

Apply the Marketing Cloud for AppExchange User option as well

B.

Reset al passwords to force new tokens

C.

Apply the appropriate user mappings in the CRM configuration

D.

Apply the administrator and Marketing Cloud Administrator permission sets to user

Question 17

A Marketing Cloud admin has been asked to get the last 30 days of Bounce data from their account.

What should the admin use to get granular bounce data in bulk in a pre-defined format?

Options:

A.

CSV download of bounce data in My Tracking

B.

Automation Studio Tracking Extract

C.

Automation Studio Query Activity

D.

Discover Deliverability Complaint Rate Report

Question 18

As part of their brand guidelines, Northern Trail Outfitters (NTO) uses a custom brand font for all print marketing materials. NTO wants to use their custom brand font in email as well.

What is the recommended best practice for font usage in email?

Options:

A.

Use a web-safe font for text that closely matches the brand's custom font.

B.

Build an email as one image, with all text saved in the brand font.

C.

Edit an email's HTML to list the custom brand font in the style tag's font-family property.

D.

Build an email using multiple images, with all text saved in the brand font.

Question 19

A Marketing Cloud admin is tasked with requesting Marketing Cloud Connect Multi-Org enablement.

What consideration should be given to the preference profile centers for this integration?

Options:

A.

Branding for each business units' profile centers will be inherited from the default business unit setup.

B.

Profile/Preference centers are automatically created for each business unit connected through Multi-org

C.

Multi org does not support the standard profile preference center for the business units.

D.

Profile/Preference centers for Multi-Org accounts are configured in the Salesforce CRM settings.

Question 20

Northern Trail Outfitters (NTO) has a franchise model which allows locally-owned stores to operate under the corporate umbrell

a. They are required by corporate policy to email each franchisee a monthly statement, but the statement cannot be publicly accessible

Which Marketing Cloud product should NTO purchase as a solution?

Options:

A.

Email Rachments

B.

Distributed Sending

C.

Content Syndication

D.

Analytics Builder

Question 21

Which two data structures could be configured to appear in the out-of-the-box Subscription center? Choose 2 answers

Options:

A.

Publication Lists

B.

Data Extensions

C.

Lists

D.

Groups

Question 22

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 23

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 24

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 25

A Marketing Cloud admin notices out of the last several sends, Send log data for a recent

How could the admin ensure send data is recorded?

Options:

A.

Send logging is enabled for the send

B.

Correct Send Log template is selected

C.

Send Logging is available for A/B tests

D.

Data retention settings is specified

Question 26

A Contact Delete request has been processed for subscribers who have been sent to previously in a Northern Trail Outfitters account, the action did NOT target all contacts in their account and significant number of contacts which have been sent to remain,

Which two data would still exist in the account? Choose 2 answers

Options:

A.

Contact data in sendable data extensions

B.

Contact data in non-sendable extensions

C.

Contact-specific data at the job level

D.

General tracking data at the job level

Question 27

Northern Trail Outfitters (NTO) purchased one Sender Authentication Package (SAP) to ensure their branding is on every marketing communication.

What would be achieved with SAP?

Options:

A.

Image URLS are wrapped with the appropriate brand URL

B.

The out-of-the-box profile center will display NTO branding

C.

A different click domain can be used for each brand

D.

A Dedicated IP is automatically warmed up

Question 28

(NTO) wants to use complex criteria to identify subscribers for a special promotional email. Especially they want to target subscribers who opened or engaged with an email within the last 30 days and live within 10 miles of an NTO store.

What should NTO do to create this audience?

Options:

A.

Measures

B.

SQL Queries

C.

Data Filters

D.

Journey

Question 29

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 30

While setting up marketing Cloud Connect, a marketing cloud admin navigates to

the Marketing Cloud tab in Sales Cloud to complete the integration. The admin then

receives the following error message:

Insufficient User Permissions. You have not been designated as an integrated

Marketing Cloud User. Contact your system administrator.

The admin notices the Marketing cloud for AppExchange Admin option is selected

when looking for the user settings.

What action should correct the issue?

Options:

A.

Apply the appropriate user mappings in the CRM configuration.

B.

Apply the Administrator and Marketing Cloud Administrator permission sets to user.

C.

Reset all user passwords to force new tokens

D.

Apply the marketing Cloud for AppExchange User option as well

Question 31

A Marketing Cloud admin at Northern Trail Outfitters (NTO) is exploring whether they need to separate their brands into separate business units.

When should the admin create separate business units for each of NTO's brands?

Options:

A.

NTO requires SSL certificate configurations for Content Builder and Portfolio images

B.

Brand-specific private domains need to be leveraged when wrapping images and links in email campaigns

C.

Multiple brand logos must be accommodated in an email header

D.

A new sender profile needs to be leveraged for sending transactional emails

Question 32

A Marketing Cloud admin wants to create an SFTP User for the first time.

Which two considerations should be taken when configuring an SFTP User7

Choose 2 answers

Options:

A.

By default, the username is the MID for the current Marketing Cloud MID.

B.

Minimum password length is 12 characters.

C.

By default, the password will be the password of the logged-in user.

D.

Once created, the user will need to be activated in order to use the SFTP.

Question 33

A publishing company has presented the following:

• A need to send renewal reminders to customers whose subscriptions expire in 15 days and 7 days.

• A campaign needs to be created and managed by a general marketing user who will not have administrative rights and who is not technical.

• The customer's expiration date is included in the data file.

What component should the customer's solution include?

Choose 3 answers

Options:

A.

Suppression list

B.

Data Filter

C.

Triggered Send

D.

Template-based emails

E.

Automation StudioTerm

Question 34

Which three options determine when a contact could enter a journey?

Choose 3 answers.

Options:

A.

Re-entry at any time

B.

Re-entry by attribute

C.

Re-entry by date

D.

No re-entry

E.

Re-entry only after exiting

Question 35

Northern Trail Outfitters is migrating from a small, in-house email solution to Marketing Cloud.

What should the Marketing Cloud admin consider when sending from the new IP Address?

Options:

A.

The IP address is on reserve, is already in use, and has an email sending history.

B.

Building desirable sending history and data will be variable based on list size and engagement.

C.

Sending in large volumes will alert ISPs the new IP Address is now in use.

D.

Migration of larger marketing campaigns is necessary prior to bringing on smaller, triggered campaigns.

Question 36

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 37

Northern Trail Outfitters does NOT want to store email addresses or phone numbers within Marketing Cloud.

Which feature should they use?

Options:

A.

Tokenized Sending

B.

Field Level Encryption

C.

Lookup reference to Contact Object

D.

Master-detail relationship to Contacts

Question 38

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 39

Northern Trail Outfitters (NTO) experienced a 24-hour website outage beginning on a peak shopping day. As a result, a number of logged-in customers' shopping sessions were disrupted. When the site is back online, the retailer would like to encourage those shoppers to return to the site and continue their shopping.

What action should NTO take?

Options:

A.

Import a file of logged-in customers into NTO's existing Abandoned Cart journey in Journey Builder.

B.

Create a user-initiated message to logged-in customers to send once the website is restored.

C.

Do not send an email, as outage may have increased negative sentiment, resulting in unsubscribes.

D.

Create and send an apology email that includes a discount for a future purchase to all customers

Question 40

Northern Trail Outfitters (NTO) has the Discover Reporting Tool.

Which two report types could help NTO drive their mobile adoption strategy?

Choose 2 answers

Options:

A.

Email Performance by Device

B.

Time Between Send and Engagement

C.

Deliverability Complaint Rate

D.

Email Sending Performance Report

Question 41

Northern Trail Outfitters installed Query Studio for Marketing Cloud, however, users are reporting they do NOT have access

How should the Marketing Cloud admin ensure users have access?

Options:

A.

Choose Public App Integration during the installation

B.

Install App-appropriate business units for expanded access

C.

License all appropriate users within the installed package

D.

Configure the API Integration to allow all users access

Question 42

Marketing Cloud admin is asked to determine the total number of emails sent across all of their business units in the last calendar year

Where would the admin retrieve this information?

Options:

A.

Contact Builder > All Contacts > Email

B.

Analytics Builder > Reports > Email Send Report

C.

Email Studio > Email > Tracking > Sends

D.

Studio > Email > Subscribers > All Subscribers

Question 43

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 44

Which activity should be used for multivariate content testing within Journey Builder?

Options:

A.

Engagement Split

B.

Random Split

C.

Content Split

D.

Decision Split

Question 45

A customer wants to automate a series of three emails as part of a Membership Renewal drip campaign. Email #1 will be sent one month prior to the member's renewal date. Email #2 will be sent one week prior to the member's renewal date. Email #3 will be sent on the member's renewal date. A master audience is updated in real time via the API. Which steps should be included in the customer's automation?

Options:

A.

Import File Activity > three Send Activities to the master data extension.

B.

Three Send Activities to the master data extension.

C.

Import File Activity > three Filter Activities > three Send Activities to the filtered audiences.

D.

Three Filter Activities > three Send Activities to the filtered audiences.

Question 46

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