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

A. Create and send an apology email which includes a discount for a future purchase to all customers.

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

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

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

ABC Company 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?

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

B. Triggered Import – user initiated send (not scheduled).

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

Analyst of 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 Rate
Which email report should NTO's Marketing Analyst pull from Marketing Cloud to get this information?

A. Campaign Email Tracking Report

B. Account Send Summary Report

C. Email Send Report

D. Email Performance Over Time Report

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

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

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

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

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

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 File Activity from the customer's data warehouse.
✑ Contact records will be augmented by relational data tables via Contact Builder.
✑ Customer ID will be used as the unique identifier for each contact.
Which statement differentiates the use of data extensions over lists?

A. Data extensions are necessary for Contact Builder.

B. Data extensions allow for add/update Import File Activity.

C. Data extensions can store HTML code as an attribute.

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

A customer needs to link demographic information to its contact model in Contact Builder.
What type of relationship should be used?

A. One-to-Many Relationship

B. Many-to-One Relationship

C. Many-to-Many Relationship

D. One-to-One Relationship

A customer wants Sales Cloud users to create and send Marketing Cloud emails.
Which two recommendations should the consultant make? (Choose two.)

A. The consultant should enable deep linking in Marketing Cloud Connect configuration.

B. Each user should have a one-to-one relationship between the Marketing Cloud user and the Sales Cloud user.

C. Each Sales Cloud user should have a System Administrator Profile and a Role at the top of the Role Hierarchy.

D. The consultant should enable the Create Email feature on the user Profile in Sales Cloud.

A customer wants to display a subscriber's first name and the date of send in its monthly newsletter. Subscriber first name data is stored in a data extension that will not be used in the send definition.
Which option should be in this scenario?

A. Guide Template Language

B. Personalization strings

C. AMPscript

D. SQL Query

ABC Company wants to automate the sending of shipping notices and a customer survey.
- Shipping notices will be sent once a day.
- The shipping file will be placed on the FTP some time after 4:00 p.m.
- The shipping data will be sorted in the Shipping Notice data extension.
- A field in the data extension will contain the shipping date.
- The survey needs to be sent at 9:00 a.m., exactly 10 days after the customer's order ships.
Which workflow would most effectively enable ABC Company to do this?
A.
 
B.
 
C.
 
D.
 

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?

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

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

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

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

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 SFTP at 10:00 p.m.
Which automated workflow meets the customers' requirements?

A. A scheduled automation which starts at 2:00 a.m. and executes Data Extract Activity > Import File Activity > SQL Query Activity > Wait Activity > Send Email Activity.

B. A drop automation which executes File Transfer Activity > Import File Activity > SQL Query Activity > Wait Activity > Send Email Activity.

C. A scheduled automation which starts at 2:00 a.m. and executes a File Transfer Activity > Import File Activity > SQL Query Activities > Wait Activity > Send Email Activity.

D. A scheduled automation which starts at 12:00 a.m. and executes a File Transfer Activity > Import File Activity > SQL Query Activities > Wait Activity > Send Email Activity.

What is the capability of the Import within Contact Builder? (Choose two.)

A. The target destination can be a DE, list, or All Contacts for Mobile Push or Connect.

B. The data source can be a local file, data filter, or file on any FTP.

C. Like the Import Wizard, the Contact Builder import definition can be executed without saving.

D. In order to use Map by Header Row, the fields in the DE and file must match exactly.

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?

A. File Transfer > Import File > Measures > Send Email

B. File Transfer > SQL Query > Measures > Send Email

C. File Transfer > Data Extract > Filters > Send Email

D. File Transfer > Import File > SQL Query > Send Email

An entertainment company is hosting events across the country in different venues. They want to use Contact Builder to feed Journey Builder. Contact who enter a journey will go through a decision split based on the type of event. The journey will send a series of emails and one of them will contain the venue details dynamically populated with AMP script. The Company collects the following information:
- Customer data (email address, first name, last name...).
- Event registration (email address, event ID, event name, event type, venue ID...).
- Venue details (venue ID, venue name, venue address...).
- Payment details (email address, event ID, total paid...).
The Company does not want to link everything in Contact Builder.
Which are the two data sources that must be incorporated inside Contact Builder? (Choose two.)

A. Event Registration

B. Customer Data

C. Venue Details

D. Payment Details

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?

A. Preference center is too strict.

B. High Watermark if journey builder.

C. Email frequency too high.

D. Deliverability issues on account.

Subscribers are collected on a customer's website whose subscription database of record is Salesforce Marketing Cloud. The customer sends up to five 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 Marketing Cloud?

A. Unsubscribes should be synchronized between senders.

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

C. Engagement metrics will be passed into Marketing Cloud.

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

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 3 a.m. daily.
✑ The customer requires that the import completes prior to 4 a.m.
✑ On average, the file will contain about two million rows of data each day.
Based on the customer's requirements and recommended best practices, how should the daily file be imported?

A. Import the file into a list, using the ‘update only’ method.

B. Import the file into a list, using the ‘add and update’ method.

C. Import the file into a data extension, using the ‘add and update’ method.

D. Import the file into a data extension, using the ‘overwrite’ method.

A retail company's database of record resides at a third party company that also keeps track of purchase history. Their database only updates once a day where new records can be created and merged. The database uses the unique identified "Customer ID".
The company wants to send real-time Welcome emails to 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 "Customer ID" in the database.
What three key issues should be addressed? (Choose three.)

A. How will Marketing Cloud and the database synchronize?

B. What will be used as Subscriber Key?

C. Will the company need a custom preference center?

D. What publication lists will be used?

E. Will new users have a “Customer ID”?

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

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

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

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

D. Add custom VisualForce Page to the page layouts in Marketing Cloud.

A customer plans to configure multiple Business Units (BU) to support the digital marketing efforts of five international offices.
Which reason warrants this implementation?

A. Support non-English responses with Reply Mail Management.

B. Localized language and display options based on location and culture.

C. Localized physical mailing address displayed in the default email footer.

D. Tracking information for campaigns sent by each office.

How do you add a contact in contact builder? (Choose two.)

A. Import to All Subscribers List.

B. Add manually to All Subscribers.

C. Import to MyLists.

D. Import to DE.

When more than one subscriber email address field is created within Contact Builder, what action tells the platform which email address to prioritize in the Email application?

A. Create a new Import to populate subscriber email addresses into All Subscribers.

B. Add all email address fields into the Mobile Application and Predictive Intelligence Applications.

C. Create a new Attribute Group referencing all email address fields in Data Designer.

D. Add all email address fields into the Contact Configuration screen in the correct order.

A restaurant supply company captures email subscribers and leads through trade shows. They hold a giveaway at each trade show to entice booth visitors to leave their contact information. In the past, they have used a fishbowl to capture business cards, but need to update this to an online sweepstakes entry vehicle displayed on a mounted tablet. Individuals should only be allowed to enter once, and the winner will be selected randomly. All entrants receive a follow-up email after the trade show asking them to confirm their opt-in for a monthly newsletter.
Which two components are appropriate for this solution? (Choose two.)

A. Microsite with Web Collect to store entrants on a data extension.

B. Send Email Activity with a link to a subscription center.

C. Data Extension with double opt-in status defined.

D. Microsite with Smart Capture to store entrants on a data extension.

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?

A. Filter target audiences based on mapped profile attributes to reduce Bulk API calls.

B. Use Data Stream to sync object data into a Data Extension in the Marketing Cloud.

C. Share Sales Cloud user licenses across Marketing Cloud users.

D. Upgrade the Marketing Cloud Account to ConnectedApp Authentication.

What are two possible outcomes when "Send as Multipart MIME" is selected during the send process? (Choose two.)

A. The email will avoid detection by various SPAM filters.

B. Open and click activity are tracked in either version.

C. An auto-generated text version will be sent with your HTML email.

D. A custom text version will be sent with your HTML email.

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?

A. File Drop Automation: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2

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

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

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

A customer wants to automate the process of sending a series of welcome emails based on the subscriber's data.
✑ Emails should be sent weekly for up to five weeks.
✑ If a subscriber makes a purchase, they should stop receiving welcome emails.
✑ A Boolean flag should be set in a data extension if the subscriber makes it through the welcome series.
Which steps should be used to accomplish this in Journey Builder?

A. Update Contact Data, Wait, Send Email, Join.

B. Random Split, Send Email, Wait Define Goal.

C. Define Goal, Send Email, Wait, Decision Split.

D. Define Goal, Update Contact Data, Send Email, Wait.

ABC Company is setting up new hires on its instance of Marketing Cloud, which includes Email Studio, Mobile Connect, and Social Studio. One of the hires needs to manage the operations of all of the North American Business Units.
What two roles, custom or standard, could be assigned to this user to meet the requirement? (Choose two.)

A. Marketing Cloud Channel Manager

B. Marketing Cloud Administrator

C. Marketing Cloud Email Marketing Manager

D. Marketing Cloud Regional or Local Administrator

ABC Company needs to provide an IT staff member with access to Marketing Cloud. The staff member needs to perform the following tasks:
✑ Maintain ABC Company's master suppression list.
✑ Configure data relationships.
✑ Create new subscriber attributes.
Which role should be assigned to the IT staff member?

A. Administrator

B. Data Manager

C. Analyst

D. Content Creator

A customer has an eCommerce site and imports data into three data extensions daily: Orders, Order_Details, and Products. The data extensions contain the following information:
✑ Orders: OrderID, CustomerID, OrderNumber, OrderDate, OrderTotal, GrandTotal.
✑ Order_Details: ProductID, OrderID, Qty, UnitPrice, ExtendedPrice, Discount.
✑ Products: ProductID, SKU, Name, Description, Cost, Price.
Which two actions should be taken in Data Designer? (Choose two.)

A. Create a one-to-many relationship between Orders and Order_Details.

B. Create a one-to-one relationship between Orders and Order_Details.

C. Create a one-to-one relationship between Order_Details and Products.

D. Create a one-to-one relationship between the contact record and Order_Details.

Collect addresses through Smartcapture, segment the data, send emails referencing data from a data extension.
What skillset is needed?

A. AMPscript

B. CSS

C. HTML

D. SQL

Which three statements are correct regarding the automation tools in Marketing Cloud? (Choose three.)

A. Journey Builder and Automation Studio allow users to define the parameters for a send within the tool.

B. Automation Studio and Journey Builder allow users to repeat an interaction indefinitely.

C. Automation Studio and Journey Builder allow users to define a wait activity based on duration.

D. Journey Builder allows users to inject Contacts from a data extension which is updated by Automation Studio.

E. Journey Builder allows users to update a contact record in a journey or import data into a data extension.

A company is hosting a series of events and wants its customers who register to enter into a journey.
Which two methods are viable configurations for entry? (Choose two.)

A. A form hosted on the company website that fires the entry event via SOAP API.

B. A form hosted on the company website that fires the entry event via REST API.

C. A SmartCapture form hosted in CloudPages that updates a Profile attribute.

D. A SmartCapture form hosted in CloudPage that populates the entry source.

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 three settings should be confirmed? (Choose three.)

A. Reply Mail Management (RMM) is configured for the customer’s account.

B. The RMM setting ‘Delete auto-replies and out-of-office replies’ is set to NO.

C. An email address was provided as the Routing Address for Remaining Replies.

D. The RMM setting ‘Unsubscribe Manual Requests’ is set to YES.

E. The subscriber’s request contained one of the standard terms that qualify for automatic unsubscribe.

Customer Event gathers data through a tablet-based webform as part of a raffle into a data extension. Winner is randomly selected. After the event, an email should be sent to the participants to gather opt ins for marketing emails.
Define two things necessary. (Choose two.)

A. Data extension with opt in status

B. SmartCapture

C. WebCollect

D. Send email activity which contains a link to subscription center

ABC Company has scenario of a journey for "post-purchasing communication".
Which re-entry setting is correct?

A. re-entry after time

B. re-entry only after exiting

C. no re-entry

D. re-entry anytime

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?

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

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

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

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

A customer is developing a new eCommerce section of their website and plans to leverage transactional data in customer journeys.
Which two Marketing Cloud features will support this effort? (Choose two.)

A. Data Designer

B. Cloud Pages

C. Web Analytics Connector

D. Content Builder

A consultant wants to trigger an email whenever the Status field on the Lead Object changes to Hot. Tracking data will need to be kept in the Sales Cloud.
Which three steps should the consultant use in the solution? (Choose three.)

A. Put a SOAP API in place via the Marketing Cloud API.

B. Write an Apex Trigger on the Lead Object.

C. Create the Triggered Send Definition in the Marketing Cloud.

D. Create the Triggered Send Definition in the Sales Cloud.

E. Enable Triggered Sends on the Lead Object in configuration.

Northern Trail Outfitters stores birthdate on the contact object in the Salesforce CRM. They want to inject the contact into a journey on their birthday.
Which two Journey Builder entry process configurations allow for an injection using the customer's birthday? (Choose two.)

A. An automation with query activity using Contact object Synchronized Data Extension then Journey Entry Activity

B. Journey Builder Date Based Event using Contact Data related to Synchronized Data Source Attribute Group

C. DMP Entry Event from Audience Studio using Date of Birthday equal to Today Segmentation

D. Salesforce Data Entry event with filter criteria on Contact Object where ‘Date of Birthday equal to Today’

A user in the MC wants to use Salesforce custom object data for segmenting and personalization.
How should the consultant approach this requirement?

A. Map the custom objects to the profile center and use the email editor to insert the custom data. Create a user-initiated send to associate the email to the largest audience and return tracking data.

B. Sync contact and custom objects with Data Stream and send from Synchronized Data Extension with Salesforce email send. Ensure there is a lookup relationship to a contact or lead record.

C. Create a custom report type that contains the contact or lead ID, email address, and custom object data, then from the marketing cloud, import into a Salesforce Data extension. Use AMPscript in the email to call data.

D. Export report data from the sales cloud and import into a marketing cloud synchronized data extension. Use a filter activity to produce a sendable data extension. Create an email send activity in Automation Studio.

Northern Trail Outfitters wants to automate the daily segmentation of their master subscriber data extension into smaller data extensions based on subscriber preferences.
Which two Automation Studio activities could they choose from to segment their data into existing data extensions? (Choose two.)

A. Script Activity

B. Refresh Group Activity

C. Publish Audience Activity

D. Query Activity

A customer has been having problems with SMS responses getting the default keyword response rather than the appropriate next keyword response.
What are two potential reasons for this unexpected response? (Choose two.)

A. Next keyword was not specified on the outbound message.

B. Response contained ג€stopג€ in the message content.

C. Responses are not sent within 24 hours of the outbound message.

D. Responses are sent after the 60 minute conversation window.

An employee in a customer's IT department is responsible for maintaining the Login IP Whitelist and SFTP locations in Marketing Cloud. The IT Director has asked that this employee be given the minimum permissions necessary to complete only these tasks.
How should the Consultant configure the IT employee's account?

A. Administrator role, with all Content and Subscriber permissions disabled

B. Marketing Cloud Security Administrator role with account-wide access

C. Data Manager role with access to only the Parent Business Unit

D. Custom role with limited Administrator permissions enabled

An entertainment customer has added a new business unit for one of its record labels. It has also purchased a Sender Authentication Package (SAP) and owns the branded domain.
What is necessary to complete SAP setup?

A. Configure link wrapping to redirect to the business unit’s subdomain

B. Configure custom Reply Mail Management for the business unit’s subdomain

C. Delegate a specific subdomain to the Marketing Cloud name servers

D. Route the domain through an IP address unique to the business unit

An online retailer would like to utilize Journey Builder interactions for sending post-purchase communications to their customers.
What Contact Entry mode best fits this scenario?

A. Re-entry after time

B. Re-entry only after exiting

C. Re-entry anytime

D. No re-entry

Which two statements are accurate regarding segmentation options in Marketing Cloud? (Choose two.)

A. A data extension can be updated using a query activity

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

C. A data filter can be automated with a filter activity

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

Northern Trail Outfitters assigns a 15-digit integer as their Order ID which will be used as the primary key of a data extension. The import file contains leading zeroes, but they will NOT be included in the final values.
Which data type should they use for the Order ID field?

A. Number

B. Text (15)

C. Decimal (15,2)

D. Decimal (15,0)

A customer has an email newsletter to send out, but wants to deliver it with a targeted message for customers within a specified age range. These data have been defined in attributes from a sign-up landing page.
How should the customer individualize the email content?

A. Guide Template Language

B. Substitution Strings

C. Dynamic Content Areas

D. Personalization Strings

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 manager's information. If a new manager is assigned to a region, NTO only wants to update the information in one place.
What data should a consultant ensure exists within Marketing Cloud in order to facilitate this?

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

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

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

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