A customer has several values that need to be used in the body of an email send.* The data would be stored in a reference data extension, related on SubscriberKey * There may be one or more records for each subscriber * The audience is generally over 1 million subscribers * The content is time sensitive and should be sent as quickly as possible * The customer is not using "Catch and release" sending * The reference data extension contains 25 columns What method should be used

AMPScript a single LookupOrderRows function

Dynamic content via the Dynamic content wizard

Server side JavaScript a single LookupOrderedRows function

AMPScript a single lookup function

As part of their brand guidelines, 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 practices for font usage in email?

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

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

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

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

A retail company's database of record resides at a 3rd-party company that also keeps track of purchase history. That database only updates once a day where new records can be created and merged. The database uses an "Email ID," which is a numeric field that represents both the business unit and email address. The company now wants to be able to send real-time Welcome emails to people (newly registered website users) who provide their email address in exchange for getting 10% off their first order, and ensure this send is connected to "Email ID" in the database.What key issue should be addressed? Choose 3 answers

How will Marketing Cloud and the database sync up?

Will new users have an "Email ID"?

What will be used as the Subscriber Key?

How will Marketing Cloud and the database sync up?

Will new users have an "Email ID"?

What will be used as the Subscriber Key?

What publication lists will be used?

Will the company need a custom preference center?

Northern Trail Outfitters is noticing a gradual decline in the percentage of conversions per emails sent in their digital marketing campaign. A new initiative is being adopted to reverse the trend.What action should be taken to increase subscriber engagement? Choose 2 answers

Increase the use of dynamic content in emails

Adopt a Cart Abandonment Email Campaign

Increase volume of emails to a wider audience

Increase the use of dynamic content in emails

Adopt a Cart Abandonment Email Campaign

Introduce more identity verification steps in check out process

NTO wants to import files at certain standard times, but occasionally a file will be dropped on a Friday if the 30th of the month falls on a weekend.What is the flow?

Triggered Import - user initiated send (not scheduled).

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

Triggered Import - user initiated send (not scheduled).

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

What are the similarities between Automation Studio and Journey Builder?

Fire an event from Automation Studio to Journey Builder

Have duration plus wait activity

Ability to define an email send

Fire an event from Automation Studio to Journey Builder

If I want to introduce a new line of footwear. I am excluding anyone who does not have shoe as an attribute listed in their preference center. I plan to send the emails daily. After a short time, I notice many people updating their preferences, and less emails are going out.What is the issue causing less emails to go out? Select one.

High Watermark if journey builder

Preference center is too strict

Deliverability issues on account

How do you add a contact in contact builder?Choose 2

Add manually to All Subscribers

How do I set up an individual who manages Marketing Cloud operations across channels, mobile, and social? Choose two.

Marketing Cloud Administrator Role

Regional or Local Administrator Role

Marketing Cloud Administrator Role

A customer executes a large number of sends via Marketing Cloud connect and is concerned about API limits. What should the consultant suggest to minimize the impact of Marketing Cloud Connect on daily API limits? Choose Two

Upgrade the MC account to ConnectedApp

Turn off Individual Level Tracking

Upgrade the MC account to ConnectedApp

Turn off Individual Level Tracking

Northern Trail Outfitters has purchased a new Marketing Cloud account with two dedicated IP addresses. One IP address will be used for commercial sends, while the other will be reserved for transactional messages.Their customer base includes 1.5 million email addresses.What should the consultant recommend?

Split marketing campaigns over a number of days while migrating over smaller triggered campaigns during the warming period.

Suppress sends to AOL email addresses during the first two weeks of IP warming, then resume sending to them during the third week.

Send to unengaged subscribers during the first two weeks of IP warming in order to give them the opportunity to interact.

Focus on warming the IP address for commercial sends, because it is not necessary to warm an IP address used only for transactional sends.

Split marketing campaigns over a number of days while migrating over smaller triggered campaigns during the warming period.

Which two statements about a database of record are correct? Choose 2 answers

It is a centralized storage repository of data about objects or people.

It is a system in which a subscriber's status is maintained.

It is a centralized storage repository of data about objects or people.

It is any database containing subscriber data.

It is any data structure in which multiple opt-in statuses can be stored for a subscriber.

It is a system in which a subscriber's status is maintained.

Northern Trail Outfitters (NTO) wants to use dynamic content within their emails to provide customers with more personalized communications. This includes using a Dynamic Sender Profile to customize the From Name and From Email Address to use the regional store managers' information.If a new manager is assigned to a region, NTO wants to update the information in one place.What data should a consultant ensure exists within Marketing Cloud in order to facilitate this?

Region code, regional store manager's name, and email address for each customer.

Regional store manager's name and email address for each customer.

Each customer's region code and the manager's name and email address for each region code.

Name and email address for each regional store manager stored on a lookup table.

Region code, regional store manager's name, and email address for each customer.

A customer will provide a single daily file on the Marketing Cloud SFTP at 3 a.m. and needs an alert if the file is NOT present on time. The file needs to be:*Imported iota a staging data extension.*Separated into two different data extensions.Which automation should meet these requirements?

File Drop Starting Source: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2

Scheduled Starting Source: Data Extract > Import File Activity > SQL Query Activity 1 > SQL Query Activity 2

File Drop Starting Source: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2

Scheduled Starting Source: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2

File Drop Starting Source: File Transfer Activity > Import File Activity > Filter Activity > SQL Query Activity 1

Northern Trail Outfitters is expanding its marketing efforts globally. Each country's marketing department has its own business unit and is responsible for the creation and execution of all the marketing campaigns. The Marketing Cloud Administrator is having trouble keeping up with the consultant influx of new users and would like to speed up the turnaround of granting new users access to Marketing Cloud.In which two ways could this be accomplished? Choose 2 answers

Assign Administration User permissions to the Channel Manager role.

Assign Administration User permissions to each business unit.

Assign Administration User permissions to the Channel Manager role.

Assign Channel Managers the role of Marketing Cloud Analyst.

Assign Administration User permissions to each business unit.

Assign Administration User permissions to individual users.

Which two statements are correct about Send Logging? Choose 2 answers

AMPscript can be used to pull data from Send Logs for use within emails.

SQL Query Activities can reference Send Logs in combination with system data views.

Send Log data extensions are archived automatically based on retention settings.

AMPscript can be used to pull data from Send Logs for use within emails.

A business unit can support up to three Send Logs.

SQL Query Activities can reference Send Logs in combination with system data views.

The customer has the following requirements for storing engagement data in their data warehouse:*All email open and click activity must be pulled daily from Marketing Cloud.*Output files must meet the specific requirements for the data warehouse.*All the activity must be provided via SFTP in one file.Which automation workflow meets the customer requirements?

SQL Query Activity to pull data view information > Data Extract Activity of data extension > File Transfer Activity

Data Extract Activity of Tracking Extracts that combines data into required file > File Transfer Activity

Report activity that generates Recent Send Summary report > Report delivered directly to SFTP

SQL Query Activity to pull data view information > Data Extract Activity of data extension > File Transfer Activity

Data Extract Activity of data view tables > SQL Query Activity to create the required file > File Transfer Activity

A restaurant supply company captures email subscribers and leads through trade shows. This has always been a manual process with booth visitors leaving contact information in a fishbowl. The restaurant supply company is updating their process to an online sweepstakes entry that allows entrants to confirm opt-in for a monthly newsletter.Which two components are appropriate for this solution? Choose 2 answers

CloudPage with Smart Capture to add entrants in to a data extension

Data extension with double opt-in status defined

CloudPage with Web Collect to add entrants in to a data extension

Send Email Activity with a link to a subscription center

CloudPage with Smart Capture to add entrants in to a data extension

Data extension with double opt-in status defined

In which two ways can Contact Builder be used to affect data stored on a data extension? Choose 2 answers

Reconcile contact data on multiple Contact IDs

Export data from a data extension to any SFTP location

Reconcile contact data on multiple Contact IDs

Add a single record to a data extension

Export data from a data extension to any SFTP location

Clear the data from a data extension

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 Sales Cloud. Other data, such as course catalog, student demographics, and alumni information, is stored in external systems.Which two actions should be consultant recommend? Choose 2 answers

Use Synchronized Data Sources to obtain data from Sales Cloud.

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

Use Synchronized Data Sources to obtain data from Sales Cloud.

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

Create list attribute to store student data from Sales Cloud.

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

Which two statements are accurate regarding segmentation options in Marketing Cloud? Choose 2 answers

A random data extension can be updated with a filter activity.

A data filter can be automated with a filter activity.

A data extension can be updated using a query activity.

A random data extension can be updated with a filter activity.

A data filter can be automated with a filter activity.

A filtered data extension can be populated with a filter activity.

A customer wants to automate the send of a monthly promotional email. The customer will upload an audience file to their account's Enhanced SFTP on a monthly basis on the 15th day of each month, expecting the email to be deployed upon completion of the import activity. However, if the 15th of the month falls on a Saturday or Sunday, the customer will provide the file on the Friday prior to the 15th and expect the promotional email to be sent on that Friday.Which method should be used to automate their monthly promotional email?

Create a scheduled monthly automation which includes an Import File Activity and triggered send.

Create a file drop automation which includes an Import File Activity and Send Email Activity.

Create a file drop automation which includes an Import File Activity and triggered send.

Create a scheduled daily automation which includes an Import File Activity and Send Email Activity.

A pharmaceutical company is hosting a monthly event and will be sending an invitation to new local contacts. The customer would like to automatically update a data extension to determine who will be attending.*The data extension will hold each contact's response as well as the time stamp of the click.*The contact will receive an email two days after the click event.*Both emails should be sent via Journey Builder.What is the optimal solution to record the click activity prior to sending the second email?

Leverage the Engagement Split and the Update Contact Activity.

Use a landing page to record the click and trigger an email.

Leverage the Decision Split and create a Custom Activity.

Leverage the Engagement Split and the Update Contact Activity.

Use a landing page to record the click in the data extension.

Northern Trail Outfitters (NTO) has a requirement to create a distinction between marketing and transactional emails in terms of From Name and IP Address for reputation purposes.Which two actions should NTO take to create Send Classifications? Choose 2 answers

Define a Subscriber-specific From Name

Define custom Reply Mail Management

What functionality is contained in Journey Builder that does NOT exist in Automation Studio?

The option to convert a qualified Lead to a Contact.

Flexibility to wait based on duration or a specific time.

Native execution of a Server-side JavaScript activity.

The ability to send an email to a Salesforce audience.

The Corporate Apparel Division of Northern Trail Outfitters (NTO) is moving to Marketing Cloud and will be using NTO's existing account. The Corporate Apparel team has asked for a recommendation on whether they should have a separate Business Unit.Which consideration warrants the creation of a separate Business Unit for Corporate Apparel's instance of Marketing Cloud?

Managing Unsubscribes for the Corporate Apparel Division only

Brand guidelines for Corporate Apparel is different from NTO

Managing Unsubscribes for the Corporate Apparel Division only

Sending from a separate IP Address and Domain

Using different From Name and Email Address settings

Salesforce Certified Marketing Cloud Consultant Practice Test 3

A retail company needs to create journeys that will target subscribers based on website behavior.

They have identified three separate groups:

* Customer who searched for an item on their website

* Customers who abandoned a cart on their website

* Customers who made a purchase on their website

Which three questions should the consultant ask in order to design the data structure to this solution?

Choose 3 answers:

Become a Premium Member for full access

Unlock Premium Member

Salesforce Certified Marketing Cloud Consultant Practice Test 3

Question

Drag and Drop

Hot Area

Salesforce Certified Marketing Cloud Consultant Practice Tests

Practice Tests