A retail company needs to create journeys that will target subscribers based on website behavior.They have identified 3 separate groups:* Customers who searched for an item on their website.* Customers who abandoned a cart on their website.* Customers who made a purchase on their website.What should the consultant ask in order to design the data structure for this solution? Choose 3 answers

How are subscribers identified in your web analytics?

How long after the behavior occurs will a subscriber need to enter a journey?

Should a single customer exist in multiple journeys at the same time?

Should customers exit the journey when the goal is met?

How are subscribers identified in your web analytics?

How many messages should be included in each journey?

How long after the behavior occurs will a subscriber need to enter a journey?

Should a single customer exist in multiple journeys at the same time?

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?

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 Subscriber Key?

How will Marketing Cloud and the database sync up?

Will new users have an "Email ID"?

What will be used as 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.

A retail company does business in both the United States and Canad a. They also have a loyalty program in which a customer can enroll. The company will provide a presegmented customer file, per campaign, which has a "Version" data field indicating the type of email the customer is to receive.What question should be asked to determine a data/segmentation strategy?Choose 2 answers

Will multiple languages be used, with a "From Name" lookup table needed?

Will version values/meanings change, precluding reusable AMPscript?

Will customers be able to sign up for the loyalty program at the store?

Is the purpose of these emails for acquisition or retention or transactional?

Will multiple languages be used, with a "From Name" lookup table needed?

Will version values/meanings change, precluding reusable AMPscript?

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?

Data extensions are necessary for Contact Builder

Data extensions allow for add/update Import activity.

Data extensions can store HTML code as an attribute.

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

Data extensions are necessary for Contact Builder

Analyst of The Northern Trail Outfitters (NTO) marketing team needs to pull email metrics for an upcoming quarterly company meeting. These metrics need to be reported per email campaign for each of NTO's Business Units:* Number of Sends* Delivery Rate* Overall Bounce Rate* Block Bounce Rate* Open Rate* Click Rate* Complaint Rate* Unsubscribe RateWhich email report should NTO's Marketing Analyst pull from Marketing Cloud to get this information?

Email Performance Over Time Report

Northern Trail Outfitters (NTO) wants to better understand subscriber behavior on their website upon arrival via an email message. A local member of a Marketing Cloud user group mentioned the Web Analytics Connector.Which benefit is offered by installing the Web Analytics Connector in a Marketing Cloud account?Choose 3 answers

Track web activity from a click on an email URL back to a specific email campaign.

Recognize web traffic as originating from email instead of another channel.

Match subscribers to web activity by passing Subscriber ID through email links.

Use the web analytics platform to trigger behavioral remarketing emails.

Track web activity from a click on an email URL back to a specific email campaign.

Pass web conversion data back into Marketing Cloud for use in email reporting.

Recognize web traffic as originating from email instead of another channel.

Match subscribers to web activity by passing Subscriber ID through email links.

A customer wants to integrate their website with Marketing Cloud so that users can update their marketing communication preferences. The customer has in-house web development resources available and is interested in leveraging tools such as Journey Builder in the future.What solution should the consultant propose, given the customer's requirements and available resources?

Configure a relational data structure using Data Extensions and consult with the customer on API integration with their website.

Configure a data structure using Lists and leverage a SmartCapture form that the client can iFrame into their website.

Configure a relational data structure using Data Extensions and leverage a SmartCapture form that is hosted in Landing Pages.

Configure a data structure using Lists and leverage the out-of-the-box Preference Center.

Northern Trail Outfitters (NTO) wants its monthly distributor newsletter email to appear to be sent on behalf of the subscriber's account representative without segmenting the audience by sales representative.How should this distributor-specific sender profile be configured in the Marketing Cloud?Choose 2 answers

Utilize data extension AMPScript lookups to dynamically populate the from name and from email values.

Populate substitution strings in the sender profile for the profile attributes containing from name and from email values.

Pick "Choose from list," selecting the from name and from email values from the list of account users.

Utilize data extension AMPScript lookups to dynamically populate the from name and from email values.

Match the external keys of the sender profile and data extension containing account representative details.

Populate substitution strings in the sender profile for the profile attributes containing from name and from email values.

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).What response articulates proper IP warming?Choose 2 answers

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

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

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

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

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

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

A consultant is configuring Marketing Cloud Connect in Marketing Cloud. The customer requires that integrated users only have access to Sales Cloud data visible to them in their Salesforce account.How would the consultant ensure that this requirement is met?

Check the Scope by User box in Marketing Cloud.

Create a User in Sales Cloud with a System Administrator Profile.

Ensure that the User has the correct profile in Marketing Cloud.

Ensure that the User is assigned as System Administrator in Sales Cloud.

A user in Marketing Cloud needs to send an email to a Salesforce Report via a Guided Send process.How should the consultant meet this requirement?

Create a Salesforce Data Extension for the user to select during a Guided Send.

Assign the integrated user the Marketing Cloud AppExchange User permission set in Sales Cloud.

Create data validation rules for the integrated user in Sales Cloud.

Add custom links to the page layouts in Marketing Cloud

A customer wants to send an email from Sales Cloud on behalf of the record owner.How should the consultant meet this requirement?Choose 2 answers

Use a custom Send Classification.

Use the Send From Record Owner option

Use the Organization-Wide Email address.

Use a custom Send Classification.

Use the Send From Record Owner option

A customer wants to perform an email send to a subset of a Synchronized Data Extension filtered on custom object data and return tracking to the Sales Cloud.What approach should the consultant recommend?Choose 2 answers

Use Data Stream to sync Sales Cloud objects to the Marketing Cloud.

Use Data Filters or Query Activities to output a Sendable Salesforce Data Extension.

Use Data Stream to sync Sales Cloud objects to the Marketing Cloud.

Use Data Filters or Query Activities to output a Sendable Salesforce Data Extension.

Use Query Activities to create a Sendable Synchronized Data Extension.

Use Data Filters to segment data to output a Sendable Data Extension

Northern Trail Outfitters (NTO):* Employs Email Specialists responsible for creating content, testing, sending emails, defining the activities for Automation Studio, and creating automations.* Prefers not to use custom roles unless it is absolutely necessary.* Email Specialist resides in multiple business units.Using best practices, how should a consultant create and assign roles for NTO?

Check "Allow" automation permissions for the Content Creator Role and assign it to the Email Specialists

Create a custom Email Specialist role with needed permissions and assign it to the Email Specialists.

Alter the roles of Content Creator and Data Manager by denying permissions and then assign the roles to the ' Email Specialists.

Check "Allow" automation permissions for the Content Creator Role and assign it to the Business Units.

Check "Allow" automation permissions for the Content Creator Role and assign it to the Email Specialists

A customer plans to configure multiple business units (BU) to support the digital marketing efforts of five international offices.Which reasons warrants this implementation? Choose 2 answers.

Localized language and display options based on location and culture.

Tracking information for campaigns sent by each office.

Support non-English responses with Reply Mail Management.

Localized language and display options based on location and culture.

Tracking information for campaigns sent by each office.

Localized physical mailing address displayed in the default email footer

Northern Trail Outfitters (NTO) has doubled in size over the last couple of years. Because of this growth they have decided to organize their company into Business Units to better manage operations.Which statement is correct regarding the Business Unit functionality within Marketing Cloud?Choose 2 answers

Business Units can mirror an organization's operational structure.

Business Units can share information with other Business Units.

Business Units can have more than one parent Business Unit.

Subscribers can only appear in one Business Unit.

Business Units can mirror an organization's operational structure.

Business Units can share information with other Business Units.

A subscriber asked to be removed from a customer's email list multiple times by replying directly to the customer's marketing message, but continues to receive emails.Which steps will solve how replies are managed by the application?Choose 3 answers

Confirm that Reply Mail Management (RMM) is configured for the customer's account.

Confirm that the RMM setting 'Unsubscribe Manual Requests' is set to YES.

Confirm that an email address was provided as the Routing Address for Remaining Replies.

Confirm that Reply Mail Management (RMM) is configured for the customer's account.

Confirm that the RMM setting 'Unsubscribe Manual Requests' is set to YES.

Confirm that the RMM setting 'Delete auto-replies and out-of-office replies' is set to NO.

Confirm that an email address was provided as the Routing Address for Remaining Replies.

Confirm that the subscriber's request contained one of the standard terms that qualify for automatic unsubscribe.

To fuel their expansion, Northern Trail Outfitters (NTO) recently acquired Eagle Outfitters (EO). There is currently a 30 percent overlap between the guests of each brand and they will be pursuing crossmarketing opportunities. It was recommended that their Marketing Cloud account now include a separate business unit for EO and the company secure a new sender authentication package for EO using the private domain e-EO.com.Select the statement that correctly describes the implication of this recommendation.Choose 2 answers

The private domain, e-EO.com, will be used for all link wrapping, image URLs, and landing page URLs.

The e-EO.com domain will act as the from address for the emails and authenticate using SPF, SenderlD, and DKIM authentication.

The IP address included in the sender authentication package will have the same reputation as the ones being used for NTO.

The EO business unit can also have the NTO authentication package applied simultaneously for cross-marketing emails.

The private domain, e-EO.com, will be used for all link wrapping, image URLs, and landing page URLs.

The e-EO.com domain will act as the from address for the emails and authenticate using SPF, SenderlD, and DKIM authentication.

The email headers for EO will still reflect the private domain for NTO since that is the parent company.

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

Query activity to pull data view information > Extract activity of data extension > Transfer activity

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

Extract activity of Tracking Extracts that combines data into required file > Transfer activity

Query activity to pull data view information > Extract activity of data extension > Transfer activity

Extract activity of data view tables > Query activity to create the required file > Transfer activity

A daily deal website is concerned with their sender reputation and needs consistent visibility into subscribers who report their email as spam.How can they determine which subscribers reported their email as spam so they can flag those records in their customer service database?

An automation that queries the Complaint data view.

An automation that generates the Unsubscribe Event Extract.

An automation that queries the Unsubscribe data view.

An automation that generates the Complaint Tracking Extract.

What is a correct statement about Send Log data?Choose 3 answers

Can be accessed via Query activities.

Can be stored for a set period of time.

Can be included in measures and filters.

Can be accessed via Query activities.

Can be incorporated into standard reports.

Can be stored for a set period of time.

Can be added to a standard data view.

Can be included in measures and filters.

What are data extension data retention policies?

Settings to define when a data extension or the data within the data extension is deleted.

Settings to "soft" delete all data in a Data Extension so there is no data loss.

Settings to control when a data extension creates a back-up of the data it contains.

Settings to define when a data extension or the data within the data extension is deleted.

Settings to prevent users from deleting a Data Extension created by another user.

A consultant needs to send an email to subscribers who have made a purchase. The data used for the send exists on two data extensions--Subscribers and OrderTable, and the customer would like to include key information from both tables, such as:* CustomerlD* FirstName* EmailAddress* OrderlD* OrderDate* ShippedDateWhich SQL statement should the consultant use?

SELECT T1.CustomerID, T1.FirstName, T1.EmailAddress, T2.OrderlD, T2.OrderDate, T2.ShippedDate FROM Subscribers T1 INNER JOIN OrderTable T2 ON T1.CustomerID=T2.CustomerID

SELECT T1.CustomerID, T1.FirstName, T1. EmailAddress, T2.OrderlD, T2.0rderDate, T2.ShippedDate FROM ' Subscribers OUTER JOIN OrderTable ON Subscribers.CustomerlD=OrderTable.CustomerlD

SELECT * FROM Subscribers WHERE CustomerlD, FirstName, EmailAddress, OrderlD, OrderDate, ShippedDate - JOIN OrderTable On CustomerlD=CustomerlD

SELECT CustomerlD, FirstName, EmailAddress, OrderlD, OrderDate, ShippedDate FROM Subscribers INNER JOIN OrderTable ON CustomerlD=CustomerlD

SELECT T1.CustomerID, T1.FirstName, T1.EmailAddress, T2.OrderlD, T2.OrderDate, T2.ShippedDate FROM Subscribers T1 INNER JOIN OrderTable T2 ON T1.CustomerID=T2.CustomerID

A customer provides a file containing only new and updated subscriber records exported from its marketing database.* The file will be uploaded to the customer's Enhanced FTP automatically at 3AM daily.* The customer requires that the import completes prior to 4AM.* On average, the file will contain about 2 million rows of data each day.Based on the customer's requirements and recommended best practices, how should the daily file be imported?

Import the file to a data extension, using the 'add and update' method.

Import the file to a list, using the 'update only' method.

Import the file to a list, using the 'add and update' method.

Import the file to a data extension, using the 'overwrite' method.

Subscribers are collected on a customer's website whose subscription database of record is Salesforce Marketing Cloud. The customer sends up to 5 emails per week based on subscriber activity.The list is:* Compiled in a database in the website Content Management System (CMS).* Imported into Marketing Cloud nightly at 11 p.m.What action should be taken if a third party is sending a message for the customer outside of the Marketing Cloud?

They will need to integrate with the Marketing Cloud SOAP API.

Engagement metrics will be passed into Marketing Cloud.

They will need to integrate with the Marketing Cloud SOAP API.

Unsubscribes should be synchronized between senders.

The third-party send list should be pulled from the CMS

What is a correct statement about a database of record? Choose 2 answers

A database of record is a centralized storage repository of data about objects or people.

A database of record is a system in which a subscriber's status is maintained

A database of record is a centralized storage repository of data about objects or people.

A database of record is any database containing subscriber data.

A database of record is a data structure in which multiple opt-in statuses can be stored for a subscriber.

A database of record is a system in which a subscriber's status is maintained

A bank wants to send out a series of emails to new customers that open a checking or savings account. The emails will be used to educate and inform customers regarding their current account and other bank offerings * Data for the campaign will be in two data extensions: Customer and New Accounts * The Customer data extension is currently used for multiple campaigns and is updated at 1:00 a.m.* The New Accounts data is encrypted and will be placed on the FTP at 10:00 p.m.Which automated workflow meets the customer's requirements?

A scheduled automation that starts at 2:00 a.m. that executes File Transfer Activity, Import Activity, Query Activity, Wait Activity, and Send Email Activity.

A scheduled automation that starts at 2:00 a.m. that executes Data Extract Activity, Import Activity, Query Activity, Wait Activity, and Send Email Activity.

A triggered automation that executes File Transfer Activity, Import Activity, Query Activity, Wait Activity, and Send Email Activity.

A scheduled automation that starts at 2:00 a.m. that executes File Transfer Activity, Import Activity, Query Activity, Wait Activity, and Send Email Activity.

A scheduled automation that starts at 12:00 a.m. and executes a File Transfer Activity, Import Activity, Query Activities, Wait Activity, and Send Email Activity.

A company collects subscriptions on its website. It does the following:* Compiles that subscription list in a database in the website Content Management System (CMS).* Posts this encrypted list to Marketing Cloud nightly at 11 p.m.* Uses Marketing Cloud as the database of record.* Sends up to five emails a week based on subscriber engagement with prior sends.Which automation sequence (excluding waits) should cover these requirements?

File Transfer, Import, Query, Sends

File Transfer, Data Extract, Filters, Sends

File Transfer, Query, Measures, Sends

File Transfer, Import, Measures, Sends

File Transfer, Import, Query, Sends

A customer needs to import data from an SFTP site. The customer wants to:* Segment the contents of the file and then send emails.* Transfer the file to the SFTP site at various times daily.* Send to data extensions.Which workflow should meet these requirements?

Triggered Automation: Import File > SQL Query(s) > Send Email(s)

Scheduled Automation: Transfer File > Import File > SQL Query(s) > Send Email(s)

Scheduled Automation: Import File > SQL Query(s) > Send Email(s)

Triggered Automation: Import File > Group Refresh > Send Email(s)

A customer is collecting data from a Smart Capture form that stores submissions in a data extension.The customer wants an email sent to the marketing manager each morning that contains the previous day's submissions as a CSV attachment. Assuming that the customer has the attachments feature enabled.Which automation workflow will accomplish this?

Scheduled Automation: SQL Query > Data Extract > Transfer File > Send Email

Triggered Automation: Data Extract > SQL Query > Transfer File > Send Email

Scheduled Automation: Data Extract > SQL Query > Transfer File > Send Email

Triggered Automation: SQL Query > Data Extract > Transfer File > Send Email

Scheduled Automation: SQL Query > Data Extract > Transfer File > Send Email

Salesforce Certified Marketing Cloud Consultant Practice Test 1

An online retail customer needs daily promotional email content to generate with minimal time spent on creation. Their service contract includes building a custom dynamic template for this purpose. The customer has communicated the following:

* The email content will highlight new inventory each day.

* A small team will run both their digital marketing operations and their email program.

* A user needs to build, test, and send a daily email in less than an hour.

* Images for the emails will be hosted on their website CMS.

Which question is relevant to identify strategies for designing the custom template for the customer's daily promotional email? Choose 3 answers

A.

How often will the layout of the content in a content area change?

B.

What is the maximum file size of the images being used?

C.

What From Name will be used for these emails?

D.

Will image URLs be available publicly?

E.

How often will email content be image-only with text overlaying images?

Salesforce Certified Marketing Cloud Consultant Practice Test 1

Question

Salesforce Certified Marketing Cloud Consultant Practice Tests

Practice Tests