1.1 Flashcards

1
Q

Northern Trail outfitters (NTO) need to provide an IT staff member with access to Marketing
Cloud. The staff member needs to perform the following tasks:
Maintain NTO’s master suppression list
Configure data relationships
Create new subscriber attributes
What role should be assigned to the IT staff member?
a. Data Manager
b. Analyst
c. Content Creator
d. Administrator

A

a. Data Manager

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

. A financial services customer states that families often share email addresses across
multiple checking, savings, loan and credit accounts. The customer needs to allow
individual accounts to use the same email address in Marketing Cloud but maintain
separate subscriber attributes. What component should be discussed with the customer to
allow for this use case?
a. Data extensions
b. Subscriber Key
c. Contact ID
d. Member Record

A

b. Subscriber Key

https://help.marketingcloud.com/en/documentation/exacttarget/subscribers/subscriber_key/
Maintain multiple sets of subscriber attributes for a single email address. For example, if a family
shares an email address, you can use a subscriber key to uniquely identify each member of the
family.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q
  1. A customer wants to send an email from Sales Cloud on behalf of the record owner. In
    which two ways should the consultant meet this requirement? Choose 2 answers.
    a. use a custom Delivery Profile
    b. Use a custom Send Classification
    c. Use the Organization-Wide Email address
    d. Use the “Send from Record Owner” option.
A

b. Use a custom Send Classification
d. Use the “Send from Record Owner” option.
Reference:
https://help.marketingcloud.com/en/documentation/integrated_products__crm_and_web_analytic_solutions/marketing_cloud_connector_v5/sending_emails/
The email can be sent from one of the following:
Running User: the user currently logged into Salesforce.
Record Owner: the user who created the record as the sender.
Org-wide Email Address: a list of users in the Sales or Service Cloud whose email address qualifies as a possible sender.
Send Classification: uses the sender profile associated with it

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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. In which two ways should this distributor-specific sender profile be
configured in the Marketing Cloud? Choose 2 answers
a. Match the external keys of the sender profile and data extension containing account representative details.
b. Utilize data extension AMPscript lookups to dynamically populate the From Name and From Email values
c. Use substitution strings to populate the From Name and From Email values in the sender profile
d. Pick “Choose from list,” selecting the From Name and From Email values from the list of account
users.

A

b. Utilize data extension AMPscript lookups to dynamically populate the From Name and From Email values
c. Use substitution strings to populate the From Name and From Email values in the sender profile
Reference Doc:
https://help.salesforce.com/articleView?id=mc_co_dynamic_sender_profile.htm&type=5

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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?
a. Create a Salesforce Data Extension for the user to select during a Guided Send.
b. Create data validation rules for the integrated user in Sales Cloud.
c. Add custom VisualForce page to the age layouts in Marketing Cloud.
d. Assign the integrated user the Marketing Cloud AppExchange User permission set in Sales Cloud.

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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 the data extension if the subscriber makes it through the welcome series. Which
should be used to accomplish this in Journey Builder?
a. Random Split, send Email, Wait, Define Goal
b. Update Contact Data, Wait, Send Email, Join
c. Define Goal, Update Contact Data, Send Email, Wait
d. Define Goal, Send Email, Wait, decision Split.

A

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

Note: Goal acts as exit criteria to remove a contact from the journey when it meets the goal measure.
https://help.salesforce.com/articleView?id=mc_jb_goals.htm&type=5

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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 Rate

What email report should NTO’s Marketing Analyst pull from Marketing Cloud to get the
information?
a. Email Send Report
b. Campaign Email Tracking Report
c. Account Send Summary Report
d. Email Performance Over Time Report
A

c. Account Send Summary Report

Reference- Campaign Email tracking report doesn’t have “No of Sends” as part of the data which is just available in Account Send report

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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 operation. Which two statements are correct regarding the Business Unit
functionality within Marketing Cloud? Choose 2 answers
a. Business Units can have more than one parent Business Unit.
b. Subscribers can only appear in one Business Unit.
c. Business Units can mirror an organization’s operational structure.
d. Business Units can share information with other Business Units.

A

c. Business Units can mirror an organization’s operational structure.
d. Business Units can share information with other Business Units.
Reference - https://help.salesforce.com/articleView?id=mc_es_business_units.htm&type=5

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Which two statements are correct regarding Attribute Groups? Choose 2 answers

a. They link data extensions to contacts.
b. They link subscriber lists to contacts.
c. They link data extensions to subscriber lists.
d. They link data extensions to other data extensions.

A

a. They link data extensions to contacts.
d. They link data extensions to other data extensions.
Reference: https://help.salesforce.com/articleView?id=mc_cab_create_an_attribute_group.htm&type=5
Point 14 indicates an attribute group is able to link DE to contacts or another DE.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

. A customer would like to send a quarterly reengagement email to subscribers who have not
opened in the previous three months. The customer’s plans are to:
● Use an existing Paste HTML email for the first send.
● Make only minor changes to the email creative for future sends.
● Use an existing Measure to build the subscriber audience for current and future sends.
● Deploy emails manually for now, but possibly automate in the future.
Which send method is recommended for the reengagement?
a. Triggered Send
b. Send Email Activity
c. Guided Send
d. Send Flow Activity

A

c. Guided Send

Explanation- Triggered send is not applicable in this case; Send Flow is not an activity.
Since question specifies that it would be done manually for now- Send Email activity
cannot be used either.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

. A customer has several values that need to be used in the body of an email send:
The data should 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 burst sending
The reference data extension contains 25 columns.
What method should be used?
a. Server Side Javascript a single LookupOrderedRows Function
b. AMPscript a single LookupOrderedRows Function
c. Dynamic content via the Dynamic Content Wizard
d. AMPscript a single Lookup Function

A

b. AMPscript a single LookupOrderedRows Function

Reference: https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-programmatic-content.meta/mc-programmatic-content/lookuporderedrows.htm

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

A retail company does business in both the United States and Canada. They also have a
loyalty program in which a customer can enroll. The company will provide a pre-segmented
customer file, per campaign, which has a “Version” data field indicating the type of email the
customer is to receive. Which two questions should be asked to determine a
data/segmentation strategy? Choose 2 answers
a. Will a lookup table be needed for a dynamic “From Name”?
b. Will “Version” values/meanings change, precluding reusable AMPscript?
c. Is the purpose of these emails for acquisition or retention or transactional?
d. Will customers be able to sign up for the loyalty program at the store

A

a. Will a lookup table be needed for a dynamic “From Name”?

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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.
Which three components should the customer’s solution include? Choose 3 answers
a. Triggered Send
b. Template-based emails
c. Automation Studio
d. Data Filter
e. Suppression list

A

b. Template-based emails
c. Automation Studio
d. Data Filter

Explanation- Triggered send is not applicable and suppression list has a different function altogether.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Northern Trail Outfitters (NTO) is considering adopting Attribute Groups when incorporating
data from their external systems. Which two statements are accurate regarding Attribute
Groups? Choose 2 answers
a. They can contain only one data extension
b. They can be created by templates to accomplish certain tasks.
c. They replicate the structure from the external system data into templates.
d. They link data extensions to other data extensions or contacts.

A

Explanation:
B there are predefined templates to us
https://help.salesforce.com/articleView?id=mc_cab_create_attribute_groups_with_templates.htm&type=5
D- Link

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

. Which three statements about Send Log data are correct? Choose 3 answers

a. Can be added to a standard data view.
b. Can be accessed via SQL Query Activities.
c. Can be included in measures and filters.
d. Can be stored for a set period of time.
e. Can be incorporated into standard reports.

A

b. Can be accessed via SQL Query Activities.
c. Can be included in measures and filters.
d. Can be stored for a set period of time.
Information on Send Log here

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

. What statements are correct regarding the automation tools in Marketing Cloud? Choose 3
Answers:
a. Automation Studio allows users to inject Contacts from a data extension into an interaction in
Journey Builder.
b. Like Automation Studio, Journey Builder allows users to repeat an interaction indefinitely.
c. Like Journey Builder, Automation Studio allows users to define the parameters for a send within the
tool.
d. Automation Studio and Journey Builder allow users to define a wait activity based on duration or
duration + time.
e. Journey Builder allows users to update a contact record in an interaction or import data into a data
extension.

A

a. Automation Studio allows users to inject Contacts from a data extension into an interaction in
Journey Builder.
b. Like Automation Studio, Journey Builder allows users to repeat an interaction indefinitely.
c. Like Journey Builder, Automation Studio allows users to define the parameters for a send within the
tool.

Explanation- d- Duration+time only available in Journey, e- Update of record is possible
but not imports though JB.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q
  1. What are two capabilities of the Import within Contact Builder? Choose 2 answers
    a. The target destination can be a data extension, 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. In order to user Map by Header Row, the fields in the data extension and file must match exactly.
    d. Like the Import Wizard, the Contact Builder import definition can be executed without saving.
A

a. The target destination can be a data extension, list, or All Contacts for Mobile
c. In order to user Map by Header Row, the fields in the data extension and file must match exactly.

Explanation-
a) Available option are – DE, list and all contacts- this is correct
b) Data source can be local file, existing data extension, or FTP- data filters is not an
option
c) Correct
d) In order to execute the import definition, we need to save it first- not correct

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Which three reasons would cause a contact to fail to enter a Journey Builder interaction?
Choose 3 answers
a. The entry event was not fired via Automation Studio
b. The interaction has an A/B/n split, and the contact does not meet the criteria.
c. The contact falls below the High Water Mark.
d. The interaction allows re-entry only after exiting, and the contact already exists.
e. The Contact did not meet the entry criteria.

A

c. The contact falls below the High Water Mark.
d. The interaction allows re-entry only after exiting, and the contact already exists.
e. The Contact did not meet the entry criteria.

Explanation for option c is here, look in answer paragraph 2

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q
19. Which data object should be used in conjunction with data extensions to create an opt-down
strategy for customers?
a. Publication Lists
b. Preference attributes
c. Profile attributes
d. Preference Lists
A

a. Publication Lists

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

. 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 context based on regional market.
In order for this solution to be viable, what skill set does the customer team need to possess?
a. SQL
b. HTML
c. SSJS
d. AMPscript

A

d. AMPscript
Explanation: In order to dynamically populate context based on regional market,
AMPScript knowledge will be required to use Lookup function from the master
subscriber DE And dynamic content.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Northern Trail outfitters (NTO) is launching a new campaign, driving them to redesign their
data structure. NTO needs to change the cardinality between two data extensions inside
Contact Builder. What are two consequences of this change? Choose 2 answers
a. All filters created before will adapt automatically to the new cardinality.
b. All scheduled sends using a filter based on one of the data extensions should be reviewed.
c. One of the data extensions must be deleted from the attribute group in order to change the
cardinality.
d. A contact may not show up in the filter based on one of the data extensions.

A

b. All scheduled sends using a filter based on one of the data extensions should be reviewed.
d. A contact may not show up in the filter based on one of the data extensions.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

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 cross-marketing 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. Which two
statements correctly describe the implication of their recommendation? Choose 2 answers
a. The private domain, e-EO.com, will be used for all link wrapping, image URLs, and landing page
URLs.
b. The email headers for EO will still reflect the private domain for NTO since that is the parent
company.
c. The EO business unit can also have the NTO authentication package applied simultaneously for
cross-marketing emails.
d. The e-EO.com domain will act as the From Address for the emails and authenticate using SPF,
SenderID, and DKIM authentication.

A

Reference - Here
Option A- Paragraph with title “Account Branding”
Option D- Paragraph with title “ Private domain”

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

A retail company needs to create journeys that will target subscribers based on website
behavior. They have identified three 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.
Which three questions should the consultant ask in order to design the data structure for
this solution? Choose 3 answers
a. How are subscribers identified in your web analytics?
b. Should a single customer exist in multiple journeys at the same time?
c. How long after the behavior occurs will a subscriber need to enter a journey?
d. How many messages should be included in each journey?
e. Should customers exit the journey when the goal is met

A

a. How are subscribers identified in your web analytics?
b. Should a single customer exist in multiple journeys at the same time?
e. Should customers exit the journey when the goal is met

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

An online retail customer needs daily promotional email context 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 three questions are relevant to identify strategies for designing the custom template
for the customer’s daily promotional email? Choose 3 answers
a. What is the maximum file size of the images being used?
b. How often will email content be image-only with text overlaying images?
c. Will image URLs be available publicly?
d. How often will the layout of the content in a content area change?

A

Explanation :
a- Image size limit is 200Kb ( here )
b. How often will email content be image-only with text overlaying images?
d- Layout change may require more work in terms of page look and support in the used
template

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
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? a. Edit an email’s HTML to list the custom brand font in the style tag’s font-family property. e. Use a web-safe font that most closely matches the brand’s custom font for live text. f. Build an email using multiple images,  with all text saved in the brand font. g. Build an email as on image, with all text saved in the brand font.
e. Use a web-safe font that most closely matches the brand’s custom font for live text.
26
An existing triggered send needs to be updated with new content.  Select the correct sequence. a. Archive Current Message interation – Edit message content  --  Restart triggered Email interaction b. Open Send Definition  --  Edit Message Content  --  Publish Changes c. Copy Send Definition  --  Select updated Content  --  Archive Original Definition  --  Start New Definition d. Pause Message Interaction -- Edit Message Content -- Publish Changes -- Restart Triggered Email interaction.
d. Pause Message Interaction -- Edit Message Content -- Publish Changes -- Restart Triggered Email interaction.
27
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 steps will solve how replies are managed by the application?  Choose 3 answers a. Confirm that Reply Mail Management (RMM) is configures for the customer’s account b. Confirm that the subscriber’s request contained one of the standard terms that qualify for automatic unsubscribe. c. Confirm that the RMM setting ‘Delete auto-replies and out-of- office replies’ is set to NO. d. Confirm that an email address was provided as the Routing Address for Remaining Replies. e. Confirm that the RMM setting ‘Unsubscribe Manual Requests’ is set to YES.
Explanation: Link Here a) Feature is required to handle unsubscribe and ooo replies (header Reply mail management on the link ) b) Look for header Reply rules on the link e) Under Reply rules, second option to turn on “Unsubscribe Manual request”
28
A retail company’s database of record resides at a third 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.  Which three key issues should be addressed?  Choose 3 answers a. What publication lists will be used? b. What will be used as Subscriber Key? c. Will new users have an “Email ID”? d. How will Marketing Cloud and the database sync up? e. Will the company need a custom preference center?
b. What will be used as Subscriber Key? d. How will Marketing Cloud and the database sync up? e. Will the company need a custom preference center?
29
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 use as part of the solution.  What feature should be utilized to make this happen? a. Send Logging. b. Profile Center c. Publication Lists d. Subscriber Keys.
c. Publication Lists
30
Which three statements are correct about Data Designer?  Choose 3 answers a. Data extensions can be linked to either the contact record or different data extensions, including data extensions from other attribute groups. b. Each attribute group can contain multiple lists, and each list can include multiple attributes. c. Data extensions should be linked directly to the contact record prior to being linked to different data extensions. d. Each attribute group can contain multiple data extensions, and each data extension can include multiple attributes. e. Each attribute group contains one data extension, and each data extension can include up to 50 attributes.
a. Data extensions can be linked to either the contact record or different data extensions, including c. Data extensions should be linked directly to the contact record prior to being linked to different data extensions. d. Each attribute group can contain multiple data extensions, and each data extension can include Explanation- Attribute group don’t have list, and there is no restriction to number of data extension to be added to attribute group. Reference here
31
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 AM daily. The customer required 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? a. Import the file to a data extension, using the ‘add and update’ method. b. Import the file to a list, using the ‘add and update’ method. c. Import the file to a list, using the ‘update only’ method. d. Import the file to a data extension, using the ‘overwrite’ method.
d. Import the file to a data extension, using the ‘overwrite’ method. Explanation- List only support import upto 500k records, so it should be DE and OverWrite is required because activity is to be completed in less than an hour, Add/Update will add extra time in the activity.
32
What are two ways Contact Builder can be used to affect data stored on a data extension? Choose 2 answers a. Export data from a data extension to any FTP location. b. Reconcile contact data on multiple Contact IDs. c. Add a single record to a data extension. d. Clear the data from the data extension. https: //mc.exacttarget.com/cloud/#app/Contact%20Builder
Explanation- c) – Optin available to add a single record to a DE d) Open DE-> go to Records tab-> Click on “Clear Records
33
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? a. Configure a relational data structure using Data Extensions and leverage a SmartCapture form that is hosted in Landing Pages. b. Configure a relational data structure using Lists and leverage the out-of- the box Preference Centre. c. Configure a relational data structure using Data Extensions and consult with the customer on API integration with their website. d. Configure a data structure using Lists and leverage a SmartCapture form that the client can iFrame into their website.
c. Configure a relational data structure using Data Extensions and consult with the customer on API integration with their website.
34
A customer wants to create a journey in Journey Builder with the goal of making users activate their accounts within 72 hours of registration. New account registrations are stored in a data extension via an API call with a Boolean field indicating whether the subscriber has activated their account. The journey should send activation reminder emails 24 hours and 48 hours after creating an account. Which sequence of activities should be used for the customer’s journey? a. 24 hour Wait > Decision Split > Send Email > 24 hour Wait > Decision Split > Send Email b. Decision Split > 24 hour Wait > Send Email > Decision Split > 24 hour Wait > Send Email c. Decision Split > 24 hour Wait > Send Email > Decision Split > 48 hour Wait > Send Email d. 24 hour Wait > Decision Split > Send Email > 48 hour Wait > Decision Split > Send Email
b. Decision Split > 24 hour Wait > Send Email > Decision Split > 24 hour Wait > Send Email
35
A daily deal website is concerned with their sender reputation and needs consistent visibility into subscribers who report their email as spam.  How should they determine which subscribers reported their email as spam so they can flag those records in their customer service database? a. An automation that generates the Complaint Tracking Extract. b. An automation that queries the Unsubscribe data view. c. An automation that generates the Unsubscribe Event Extract. d. An automation that queries the Complaint data view.
d. An automation that queries the Complaint data view. | Reference- Link Tracking extract will not give specific customer wise span details.
36
. A company collects subscriptions on its website.  It does the following: Complies 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 a subscriber engagement with prior sends. What automation sequence (excluding waits) should cover these requirements? a. File Transfer > Data Extract > Filters > Send Email b. File Transfer > Import File > Measures > Send Email c. File Transfer > Import File > SQL Query > Send Email d. File Transfer > SQL Query > Measures > Send Email
c. File Transfer > Import File > SQL Query > Send Emai Measures are not an activity. >> B & D is wrong A: data extract makes no sense, especially at that position Correct flow: -File transfer for decryption of file, -Import for getting external data in, -Query (using e.g. the data views _open, _click, _Bounce for segmentation) -Send (obviously) are necessary Measures can be defined, then used in a filter, then referenced in the user-initiated send (so they would be implicitly part of the SEND activity)*##**##*
37
A customer wants to link web analytics data to subscriber data.  How should this be set up in Data Designer? a. Link to the Marketing Cloud API b. Link to the Web Analytics SFTP c. Link to Marketing cloud data extensions d. Link to the Web Analytics Provider API
c. Link to Marketing cloud data extensions
38
A customer has three data extensions that need to be added to Contact Builder. Customers contains customer information Orders contains order information Products contains product information How should these data extensions be linked within an Attribute Group? a. Customer Data |One-to- One| Customers |One-to- One|Orders |One-to- One| Products b. Customer Data |One-to- Many| Customers |One-to- One> Orders |One-to- Many| Products c. Customer Data |One-to- One| Customers |One-to- Many| Orders |One-to- Many| Products d. Customer Data |One-to- One| Products |One-to- Many| Orders |One-to- One| Customers
c. Customer Data |One-to- One| Customers |One-to- Many| Orders |One-to- Many| Products Contact key- Customer- One customer can have many order (1-many)- > One order to many products
39
. 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. Personalization strings b. AMPscript c. Guide Template Language d. SQL Query
b. AMPscript
40
A customer plans to configure multiple business units (BU) to support the digital marketing efforts of five international offices.  What reason warrants this implementation? a. Tracking information for campaigns sent by each office. b. Localized language and display options based on location and culture. c. Support non-English responses with Reply Mail Management d. Localized physical mailing address displayed in the default email footer
b. Localized language and display options based on location and culture.
41
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 the Marketing Cloud? a. The third-party send list should be pulled from the CMS. b. They will need to integrate with the Marketing Cloud SOAP API. c. Engagement metrics will be passed into Marketing Cloud. d. Unsubscribes should be synchronized between senders.
b. They will need to integrate with the Marketing Cloud SOAP API.
42
``` By which three standard methods could contacts be injected into a Journey Builder Interaction?  Choose 3 answers a. Mobile Response Event b. Date-Based Event c. Sales/Service Cloud Event d. CloudPages Form Submit Event e. Predictive Intelligence Event ```
b. Date-Based Event c. Sales/Service Cloud Event d. CloudPages Form Submit Event Explanation- PI updates the Data extension when implemented, and based on that Data based event or Audience is triggered. Mobile Response is not a type of event supported in journey builder. References- here
43
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. What workflow should meet these requirements? a. Triggered Automation: Import File > SQL Query(s) > Send Email(s) b. Scheduled Automation: Transfer File > Import File > SQL Query(s) > Send Email(s) c. Triggered Automation: Import File > Group Refresh > Send Email(s) d. Scheduled Automation: Import File > SQL Query(s) >Send Email(s)
a. Triggered Automation: Import File > SQL Query(s) > Send Email(s)
44
Which two statements are correct regarding tracking aliases?  Choose 2 answers a. Tracking aliases are found in Tracking and some standard reports. b. Tracking aliases are primarily relevant when used with emails conversion tracking. c. Tracking aliases are associated with a URL in HTML as: tag=”alias text”. d. Tracking aliases can differentiate click activity in an email to the same URL.
b. Tracking aliases are primarily relevant when used with emails conversion tracking. d. Tracking aliases can differentiate click activity in an email to the same URL.
45
``` A customer would like to store financial data related to invoicing in its data extensions. What field type should be used? a. Number b. Currency c. Float d. Decimal ```
d. Decimal
46
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 should the consultant ensure that this requirement is met? a. Create a User in Sales Cloud with a System Administrator Profile. b. Ensure that the User has the correct profile in Marketing Cloud. c. Check the Scope by User box in Marketing Cloud. d. Ensure that the User is assigned as System Administrator in Sales Cloud.
c. Check the Scope by User box in Marketing Cloud.
47
A large retail company has selected Marketing Cloud and has asked to be fully migrated from their existing platform in three weeks.  They have communicated the following. They currently have 3 million customers. They email customers twice a week with no known deliverability issues. Their contract includes one Sender Authentication Package (SAP). Which two responses articulate proper IP warming?  Choose 2 answers a. IP ramp-up can be bypassed, given their historical lack of deliverability issues. b. IP ramp-up can be accelerated by migrating to pre-warmed IP addresses. c. IP ramp-up is important to establish a positive sender reputation d. IP ramp-up takes four to six weeks to be able to fully send to all 3 million customer
c. IP ramp-up is important to establish a positive sender reputation d. IP ramp-up takes four to six weeks to be able to fully send to all 3 million customer Explanation- Pre-warmed IP Address is not a possibility in SFMC. IP Warmup Guide here
48
49. A customer wants to automate the send of a monthly promotional email.  The customer will upload an audience file to their accounts Enhanced FTP on a monthly basis on the 15 the day of each month, expecting the email to be deployed upon completion of the import activity.  However, if the 15 th of the month falls on a Saturday or Sunday, the customer will provide the file on the Friday prior to the 15 th and expect the promotional email to be sent on that Friday.  Given the customer’s requirements, which method should be used to automate their monthly promotional email? a. Create a scheduled monthly automation that includes an Import File Activity and triggered send b. Create a file drop automation that includes an Import File Activity and triggered send. c. Create a file drop automation that includes an Import File Activity and Send Email Activity. d. Create a scheduled daily automation that includes an Import File Activity and Send Email Activity.
c. Create a file drop automation that includes an Import File Activity and Send Email Activity. Explanation: Given the fact that date for file upload is not static we cannot use schedule automation. Trigger will be a File drop matching a certain file name and based on that other activities trigger automatically in defined steps.
49
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 FTP in one file. Which automation workflow meets the customer requirements? a. Report activity that generates Recent Send Summary report > Report delivered directly to FTP b. Data Extract Activity of Tracking Extracts that combines data into required file > File Transfer Activity c. Data Extract Activity of data view tables > SQL Query Activity to create the required file > File Transfer Activity d. SQL Query Activity to pull data view information > Data Extract Activity of data extension > File Transfer Activity
d. SQL Query Activity to pull data view information > Data Extract Activity of data extension > File Transfer Activity
50
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 work flow meets the customer’s requirements? a. A scheduled automation that starts at 2:00 a.m. that executes Data Extract Activity > Import File Activity > SQL Query Activity > Wait Activity and > Send Email Activity. b. A scheduled automation that starts at 2:00 a.m. that executes File Transfer Activity > Import File Activity > SQL Query Activity > Wait Activity > Send Email Activity. c. A file drop automation that executes File Transfer Activity > Import File Activity > SQL Query Activity > Wait Activity > Send Email Activity. d. A scheduled automation that starts at 12:00 a.m and executes File Transfer Activity > Import File Activity > SQL Query Activity > Wait Activity > Send Email Activity.
b. A scheduled automation that starts at 2:00 a.m. that executes File Transfer Activity > Import File Activity > SQL Query Activity > Wait Activity > Send Email Activity.
51
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.  Which two actions should be taken to increase subscriber engagement?  Choose 2 answers a. Adopt a Cart Abandonment Email Campaign. b. Introduce more identity verification steps in check out process. c. Increase the use of dynamic content in emails. d. Increase volume of emails to a wider audience.
a. Adopt a Cart Abandonment Email Campaign. | c. Increase the use of dynamic content in emails.
52
A financial company will be using Marketing Cloud to send late payment notices to accounts whose payment due date lapsed the previous week.  The company has shared the following: Payments.csv will arrive on the Enhanced FTP each Monday at 1.00 a.m. Payments.csv will be encrypted. Payments.csv will contain data from the previous week Late payment notices will be sent each Monday at noon. They need to receive a file containing customers who opened or clicked on the late payment notice email within 5 days after send. Which automation sequence represents a viable solution? a. File Transfer > Import File > Filter > Wait > Send Email > Wait > SQL Query > Data Extract > File Transfer b. File Transfer > File Transfer > Import File > SQL Query > Wait > Send Email > SQL Query > File Transfer c. File Transfer > Import File > Filter > Wait > Send Email > SQL Query > Wait > Data Extract > File Transfer d. Import File > File Transfer > SQL Query > Wait > Send Email > Wait > SQL Query > Data Extract > File Transfer
a. File Transfer > Import File > Filter > Wait > Send Email > Wait > SQL Query > Data Extract > File Transfer Explanation- First activity will be File transfer since the file is encrypted followed by an Import activity (Link), create a filter for extracting qualifying customer, wait, send an email and since we need tracking data we need to put another wait activity.
53
What are data extension data retention policies? a. Settings to define when a data extension or the data within the data extension is deleted. b. Settings to control when a data extension creates a back-up of the data it contains. c. Settings to prevent users from deleting a Data Extension created by another user. d. Settings to “soft” delete all data in a Data Extension so there is no data loss.
Settings to define when a data extension or the data within the data extension is deleted.
54
. 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? a. Alter the roles of Content Creator and Data Manager by denying permissions and then assign the roles to the Email Specialists. b. Check “Allow” automation permissions for the Content Creator Role and assign it to the Business Units. c. Create a custom Email Specialist role with needed permissions and assign it to the Email Specialists. d. Check “Allow” automation permissions for the Content Creator Role and assign it to the Email Specialists.
Check “Allow” automation permissions for the Content Creator Role and assign it to the Email Specialists.
55
A customer needs to compare the engagement across three creative versions of an email, and then send a follow-up email for those contacts who did not engage with any of the test versions. Which sequence of activities in journey Builder would best accomplishes this? a. Engagement Split > Send email > Wait > Random Split > Send email b. Random Split > Send email > Join > Decision Split > Wait > Send email c. Random Split > Send email > Wait > Engagement Split > Join > Send email d. Decision Split > Send email > Engagement Split > Send email
c. Random Split > Send email > Wait > Engagement Split > Join > Send email
56
Northern Trail Outfitters (NTO) plans to use Contact Builder to increase the scope of customer information they can see in an effort to establish more effective 1:1 relationships.  NTO has a separate instance of Salesforce Sales Cloud that serves as their current customer master database.  Which two actions should be taken when using Contact Builder?  Choose 2 answers a. Create a data extension to incorporate the imported data from a Salesforce Dashboard b. Combine each individual’s channel contact information under one record. c. Use Marketing Cloud Connect to include data from Sales Cloud. d. Conduct manual imports of customer information from Sales Cloud.
b. Combine each individual’s channel contact information under one record. c. Use Marketing Cloud Connect to include data from Sales Cloud.
57
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.  Which two approaches should the consultant recommend?  Choose 2 answers a. Use Synchronized Data Sources to sync Sales Cloud objects to the Marketing Cloud. b. Use Data Filters to segment data to output a Sendable Data Extension. c. Use SQL Query Activities to output a Sendable Salesforce Data Extension. d. Use SQL Query Activities to create a Sendable Synchronized Data Extension.
a. Use Synchronized Data Sources to sync c. Use SQL Query Activities to output a Sendable Salesforce Data Extension. Explanation- Synchronized data extension are not sendable, creating a filter will create another data extension but It will not be sendable so only way to use this information is by a query activity populating a sendable data extension created manually.
58
. 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 kay information from both tables, such as: CustomerID FirstName EmailAddress OrderID OrderDate ShippedDate Which SQL statement should the consultant use? a. SELECT CustomerID, FirstName, EmailAddress, OrderID, OrderDate, ShippedDate FROM Subscribers  INNER  JOIN  OrderTable ON CustomerID=CustomerID b. SELECT T1.CustomerID, T1.FirstName, T1.EmailAddress, T2.OrderID, T2.OrderDate, T2.ShippedDate FROM Subscribers T1 INNER JOIN OrderTable T2 ON T1.CustomerID=T2.CustomerID c. SELECT T1.CustomerID, T1.FirstName, T1.EmailAddress, T2.OrderID, T2.OrderDate, T2.ShippedDate FROM Subscribers OUTER JOIN OrderTable ON Subscribers.CustomerID=OrderTable.CustomerID d. SELECT * FROM Subscribers WHERE CustomerID, FirstName, EmailAddress, OrderID, OrderDate, Shipped Date JOIN OrderTable On CustomerID=CustomerID.
b. SELECT T1.CustomerID, T1.FirstName, T1.EmailAddress, T2.OrderID, T2.OrderDate, T2.ShippedDate
59
Northern Trail Outfitters (NTO) is running a campaign for a brand new type of footwear inside Journey Builder.  The entry event:  Prevents contacts from entering the journey if “shoes” is not selected in their preferences.  Is based on a data extension which has Email Address as Primary Key.  A few weeks after launching the campaign, NTO’s data analyst noticed a reduced email volume and that some contacts inside the data extension updated their preferences after the launch of the campaign.  Even with the entry event being triggered every day, those contacts are not receiving the welcome emails.  What could be the reason? a. The preference center is too precise. b. Their account has deliverability issues. c. The contact fell below the High Water Mark. d. The entry event is triggered too often. 61. Northern Trail Outfitters (NTO) 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 NTO does not want to include them in the final values.  Which data type should they use for the Order ID field? a. Decimal (15,0) b. Decimal 15,2) c. Number d. Text (15) Explanation- Leading zeros can be removed using Integer data type, Click here
b. Their account has deliverability issues.
60
Northern Trail Outfitters (NTO) 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 NTO does not want to include them in the final values.  Which data type should they use for the Order ID field? a. Decimal (15,0) b. Decimal 15,2) c. Number d. Text (15)
c. Number | Explanation- Leading zeros can be removed using Integer data type, Click here
61
. 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? a. Branding for the Corporate Apparel is different from NTO. b. Using different From Name and Email Address settings. c. Managing Unsubscribes for the Corporate Apparel Division only. d. Sending from a separate IP Address and Domain
d. Sending from a separate IP Address and Domain Explanation- There is an option to manage Subscription at BU level, here is the Reference
62
During discovery it was confirmed that:  The customer has purchased a Corporate Edition account.  A master audience file containing contact information and data points will be used for segmentation and imported nightly.    The Customer would like to implement a mechanism that consistently prevents sending promotional emails to subscribers who work for their top three competitors.  What feature should a consultant include in the solution? a. A global unsubscribes. b. An auto-exclusion list. c. An exclusion list. d. An auto-suppression list
c. An exclusion list.
63
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 constant influx of new users and would like to speed up the turnaround of granting new user access to the Marketing Cloud.   In what two ways can this be accomplished?  Choose 2 answers. a. Assign Administration User permissions to each business unit. b. Assign Administration User permissions to the Channel Manager role. c. Assign Administration User permissions to individual users. d. Assign Channel Managers the role of Marketing Cloud Analyst.
a. Assign Administration User permissions to each business unit. b. Assign Administration User permissions to the Channel Manager role.
64
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.   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? a. Data extensions are necessary for Contact Builder. b. Data extensions allow for add/update Import File Activity. c. Data extensions support Customer ID to be used as Subscriber Key. d. Data extensions can store HTML code as an attribute.
a. Data extensions are necessary for Contact Builder. | https: //help.salesforce.com/articleView?id=mc_as_update_a_list_or_data_extension_using_an_external_file.htm&type=5
65
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 these contracts to enter? Chose 2 answers. a. A form hosted on the company website that fires the entry even via SOAP API. b. A SmartCapture form hosted on a CloudPage that populates the entry source. c. A form hosted on the company website that fires the entry even via REST API. d. A SmartCapture form hosted on a CloudPage that updates a profile attribute.
b. A SmartCapture form hosted on a CloudPage that populates the entry source. c. A form hosted on the company website that fires the entry even via REST API. https://developer.salesforce.com/docs/atlas.en-us.mc-apis.meta/mc-apis/index-api.htm
66
67. A Marketing Cloud user needs the email addresses of everyone who unsubscribed from a particular email send.  This user does not know SQL and does not have access to the enhanced FTP account.  What functionality should be used to retrieve the necessary data? a. My Tracking b. Tracking Extract c. Data Views d. My Reports
a. My Tracking Explanation- With my Tracking user can create a list, view in browser or download as an attachment with the subscribers meeting the criteria.
67
A large retail group consists of a corporate team and several divisions operating under different brand names.  All plan to share one Marketing Cloud account.  Each brand has its own marketing department and operates independently, with its own creative assets, subscribers, and data structure.  What are the two reasons why the recommended account configuration is one corporate Parent account, with each brand configured as a separate child Business Unit?  Choose 2 answers a. Brands can set their own physical address and SAP. b. Email sends can be separated into Tracking folders for each brand. c. User roles can be customized to allow or deny specific permissions. d. Subscribers can be maintained at the Business Unit level.
d. Subscribers can be maintained at the Business Unit level.
68
Northern Trail Outfitters (NTO) 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 sometime 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 NTO to do this? a. Import File -> Filter -> Send Email -> Wait-> Filter -> Send Email a. Automation 1: Scheduled to run daily at 7:00 PM b. Import File -> Filter-> Send Email-> Wait -> Filter -> Send Email a. Automation 1: Triggered Automation 2: Scheduled to run daily at 9:00 AM c. Import File -> Filter-> Send Email-> Filter -> Send Email a. Automation 1: Scheduled to run daily at 7:00 PM Automation 2: Scheduled to run daily at 9:00 AM d. Import File -> Filter-> Send Email-> Filter -> Send Email
a. Import File -> Filter -> Send Email -> Wait-> Filter -> Send Email a. Automation 1: Scheduled to run daily at 7:00 PM
69
``` What storage model should be used if a subscriber has more than one value for an attribute? a. Profile Attribute b. Data Extensions c. Publication Lists d. Lists ```
b. Data Extensions
70
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 2 answers. a. Customer Data b. Event Registration c. Venue Details d. Payment Details
a. Customer Data | c. Venue Details
71
. An online retailer would like to be utilizing Journey Builder interactions for sending post- purchase communications to their customers.  What Contact Entry mode best fits this scenario? a. Re-entry anytime. b. Re-entry only after exiting. c. Re-entry after time. d. No re-entry.
b. Re-entry only after exiting.
72
Northern Trail Outfitters (NTO) has decided to use Journey Builder to launch event-driven lifecycle marketing programs.  This includes personalized interactions with customers with the goal of increasing purchase frequency.  Which two pieces of information would help NTO achieve this objective?  Choose 2 answers a. Products purchased from a competitor. b. Number of items per order. c. Channel preference of customers. d. Last purchase date
c. Channel preference of customers. | d. Last purchase date
73
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 2 answers a. Microsite with Web Collect to store entrants on a data extension. b. Microsite with Smart Capture to store entrants on a data extension. c. Send Email Activity with a link to a subscription center. d. Data Extension with double opt-in status defined.
b. Microsite with Smart Capture to store entrants on a data extension. c. Send Email Activity with a link to a subscription center.
74
A customer with limited technical resources has requested assistance in setting up a small email deployment that the customer will maintain long term.  The email will display men’s shoes to males in the audience and women’s shoes to females in the audience.  The sendable data extension contains a field with a value of Male or Female.  Which method should a consultant recommended to ensure content is displayed properly within the email. a. AMPscript conditional against the Gender field b. AMPscript lookupRows functions c. A/B Test content type d. Dynamic Content Wizard
d. Dynamic Content Wizard Explanation- Since customer has limited technical resources, Its recomended to use standard functionality of Dynamic content. Click here for more information
75
A user in the Marketing Cloud 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 object data.  Create a User-Initiated Send to associate the email to the target 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. 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. d. Create a custom report type that contains the contact or lead id, email address, and custom objectdata, them from Marketing Cloud, import into a Salesforce data extension.  Use AMPScript in the email to call data.
d. Create a custom report type that contains the contact or lead id, email address, and custom objectdata, them from Marketing Cloud, import into a Salesforce data extension.  Use AMPScript in the email to call data. Explanation- Synchronized Data extensions are not sendable so using data stream if we get any information in them, without running a query activity and populating another DE its not usable for email. With a custom report type, we can create a import activity have a data extension updated in MC that can be used to send an email.
76
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? 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.
b. Create a user-initiated message to logged–in customers to send once the website is restored. Explanation- C, D can’t be applicable for practical reasons. Option a- Question has not specified how they can import such information- though Web and Mobile analytics, Personalization builder offer such option. But from those two features you cannot import data into Journey. B is the most relevant answer.
77
78. Northern Trail Outfitters wants to set up a welcome journey that leverages customer data across three data extensions: Customers, Orders, and Products. What is the best way to facilitate this within Contact Builder? a. Create three distinct Attribute Groups that link Customers to Contacts, Orders to Customers, and Products to Orders. b. Create a single Attribute Group that links Contacts to Customers, Orders to Products, and Products to Customers. c. Create three distinct Attribute Groups that link each data extension directly to Contacts. d. Create a single Attribute Group that links Customers to Contacts, Orders to Customers, and Products to Orders.
link each data extension directly to Contacts. d. Create a single Attribute Group that links Customers to Contacts, Orders to Customers, and Products to Orders.
78
. 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 2 answers a. Create a one-to- one relationship between the contact record and Order Details. b. Create a one -to -many relationship between Orders and Order_Details. c. Create a one-to- one relationship between Orders and Order_Details. d. Create a one-to- one relationship between Order_Details and Products.
b. Create a one -to -many relationship between Orders and Order_Details. d. Create a one-to- one relationship between Order_Details and Products.
79
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. 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.
a. Use Data Designer to link student and alumni data to the contact record. d. Use Synchronized Data Sources to data from the Sales Cloud.
80
. 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 in order to create Send Classifications? Choose 2 answers a. Define a Sender Profile. b. Define a Subscriber -specific From Name. c. Define custom Reply Mail Management. d. Define a Delivery Profile
a. Define a Sender Profile. | d. Define a Delivery Profile
81
The Northern Trail Outfitters (NTO) marketing team is launching a new email campaign. NTO's Email Specialist wants to perform quality assurance checks on the email prior to send and has asked about using the Validate functionality for this effort.  Which three items will Validate check in an email message?  Choose 3 answers a. Each content area specified in a dynamic content rule exists. b. Words or phrases used may trigger spam filters. c. Grammar and spelling in the email text is correct. d. Correct syntax is used on any AMPScript in the emails code. e. Personalization strings map to attributes or data extension fields
a. Each content area specified in a dynamic content rule exists. d. Correct syntax is used on any AMPScript in the emails code. e. Personalization strings map to attributes or data extension fields Reference for Validate: Here Spam filters are triggered by Content Detective tool,
82
A customer will provide a single daily file on the Marketing Cloud SFTP at 3AM 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. 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 Activity 1 > SQL Query Activity 2 d. File Drop Automation: File Transfer Activity > Import File Activity > Filter Activity > SQL Query Activity
b. Scheduled Automation: Import File Activity > SQL Query Activity 1 > SQL Query Activity 2
83
A customer wants Sales Cloud users to create and send Marketing Cloud emails.  Which two consultant make? Choose 2 answers a. Each user should have a one-to- one relationship between the Marketing Cloud user and the Sales Cloud user. b. The consultant should enable deep linking in Marketing Cloud Connect configuration. c. The consultant should enable the Create Email feature on the user Profile in the Sales Cloud. d. Each Sales Cloud user should have a System Administrator Profile and a Role at the top of the Role Hierarchy.
a. Each user should have a one-to- one relationship between the Marketing Cloud user and the Sales Cloud user. b. The consultant should enable deep linking in Marketing Cloud Connect configuration. Explanation- In order to be able to send email from SFDC using MC Connect, there should be a one-one mapping between SFDC user and SFMC user with relevant permission set assigned and permission enabled on user layout. Also, Deep linking should be enabled to be able to create a Email right though MC Connect interface in Sales cloud.
84
Northern Trail Outfitters 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 2 answers a. Marketing Cloud Channel Manager b. Marketing Cloud Email Marketing Manager c. Marketing Cloud Regional or Local Administrator d. Marketing Cloud Administrator
a. Marketing Cloud Channel Manager | b. Marketing Cloud Email Marketing Manager
85
A customer frequently holds seminars and other events to interface with their customers. They plan to do the following:  Use SmartCapture forms to write data into event registration data extensions.  Cross-reference the records in each registration data extension with corresponding invitation email sends.  Send a follow-up email to customers who click on the registration link in the invitation email, but do not complete registration.  Which skill is needed to build an efficient solution? a. AMPscript b. SQL c. HTML d. CSS
b. SQL
86
How is publication lists used in the Marketing Cloud? a. To send communication to all subscribers, regardless of opt -in status. h. To manage subscribers in guided and triggered email sends. i. To build dynamic content rules by subscriber type. j. To allow subscribers to opt-down/out instead of unsubscribing from all.
j. To allow subscribers to opt-down/out instead of unsubscribing from all.
87
What are two possible outcomes when "Send as Multipart "; is selected during the send process?  Choose 2 answers a. Open and click activity are tracked in either version. b. The email will avoid detection by various SPAM filters. 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.
b. The email will avoid detection by various SPAM filters. c. An auto -generated text version will be sent with your HTML email. Explanation- While creating a send definition selecting “MIME” option will automatically generate a text version of the email which is sent. Though, there is no documentation for this from Marketing cloud, having a MIME alternative of email increases deliverability and is not blocked by SPAM filters.
88
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 customer’s experience? 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.
A triggered message to send an email as soon as a customer completes a purchase.
89
A Consultant has a data extension that contains all current product information. The customer wants to refresh data each morning by importing a CSV containing today's product catalog. The product catalog is never the same; products can be added and removed. Which import type should be used? a. Overwrite b. Add Only c. Add/Update d. Update Only
b. Add Only
90
. Which two statements are correct about Send Logging?  Choose 2 answers a. Send Log data extensions are archived automatically based on retention settings. b. AMPscript can be used to pull data from Send Logs for use within emails. c. SQL Query Activities can reference Send Logs in combination with system data views. d. A business unit can support up to three Send Logs.
b. AMPscript can be used to pull data from Send Logs for use within emails. c. SQL Query Activities can reference Send Logs in combination with system data views.
91
What functionality is contained in Journey Builder that does not exist in Automation Studio? a. Native execution of a Server -side JavaScript activity. b. The option to convert a qualified Lead to a Contact. c. Flexibility to wait based on duration or a specific time. d. The ability to send an email to a Salesforce audience.
d. The ability to send an email to a Salesforce audience. Explanation- Journey builder can listen to an event fired in Sales Cloud data and send an email or other activity. Automation cannot directly listen to Sales cloud data
92
Northern Trail Outfitters (NTO) wants to implement a drip campaign to its highest -value outdoor sports customers. NTO is including a deep product discount and wants to limit the audience to not only its best customers, but also those customers  most likely to respond. Which three criteria should the customer use to create an audience for this campaign? Choose 3 answers a. Proximity to Store b. Ages in Household c. Lifetime Purchase Value d. Conversion Rate e. Last Purchase Date
c. Lifetime Purchase Value | d. Conversion Rate
93
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? 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.
d. Three Filter Activities > three Send Activities to the filtered audiences.
94
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 -Many Relationship c. One -to -One Relationship d. Many -to -One Relationship
One -to -Many Relationship
95
A start-up meal delivery company recently launched in Canada to great success. Through their website, customers can order individual meal kits for up to six people or subscribe to a weekly meal kit delivery. As a new company, resources are limited, but demand is taxing their manual processes for sending out ecommerce messages, such as order confirmation and subscription confirmations.  What recommendation would best provide a scalable solution for the start-up? a. A manual email send for each transactional message. b. A triggered automation to send transactional messages. c. Triggered email sends to deliver transactional messages. d. An automated program to send daily transactional messages.
c. Triggered email sends to deliver transactional messages.
96
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 2 answers a. Data Designer b. Cloud Pages c. Web Analytics Connector d. Content Builder
c. Web Analytics Connector | d. Content Builder
97
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 3 answers a. Put a SOAP API in place via the Marketing Cloud API. b. Create the Triggered Send Definition in the Marketing Cloud. c. Enable Triggered Sends on the Lead Object in configuration. d. Create the Triggered Send Definition in the Sales Cloud. e. Write an Apex Trigger on the Lead Object.
b. Create the Triggered Send Definition in the Marketing Cloud. c. Enable Triggered Sends on the Lead e. Write an Apex Trigger on the Lead Object Understand how to set up a triggered send. Create a trigger on the object and make active Make sure that triggered sends are configured on the object The Send Definition should be created in the Marketing Cloud Automatically send relevant, timely, personalized messages using triggered sends. Welcome emails to new customers or thank you notes for purchases are examples of how triggered sends are commonly used.
98
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 a. Use the web analytics platform to trigger behavioral remarketing emails. b. Track web activity from a click on an email URL back to a specific email campaign. c. Pass web conversion data back into Marketing Cloud for use in email reporting. d. Recognize web traffic as originating from email instead of another channel. e. Match subscribers to web activity by passing Subscriber ID through email links
b. Track web activity from a click on an email URL back to a specific email campaign. d. Recognize web traffic as originating from email instead of another channel. e. Match subscribers to web activity by passing Subscriber ID through email links
99
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? a. Triggered Automation: Data Extract > SQL Query > Transfer File > Send Email b. Scheduled Automation: Data Extract > SQL Query > Transfer File > Send Email c. Triggered Automation: SQL Query > Data Extract > Transfer File > Send Email d. Scheduled Automation: SQL Query > Data Extract > Transfer File > Send Email
d. Scheduled Automation: SQL Query > Data Extract > Transfer File > Send Email
100
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 Attribute Group referencing all email address fields in Data Designer. b. Create a new Import to populate subscriber email addresses into All Subscribers. c. Add all email address fields into the Mobile Application and Predictive Intelligence Applications. d. Add all email address fields into the Contact Configuration screen in the correct order
Add all email address fields into the Contact Configuration screen in the correct order
101
When joining a data extension in Contact Builder, in which scenario should a consultant mark the Use as Root checkbox? a. Supplemental data for an interaction in Journey Builder b. Database of record other than All Subscribers c. One-to- Many Relationship to the Contact Record d. Data for both Email and MobileConnect sends
b. Database of record other than All Subscribers
102
A user receives a message stating that there is an error binding data bound member when testing an Entry Event in Journey Builder. What can a user do to ensure that contacts enter this interaction successfully based on the error message? Choose 2 answers a. Select a source DE with a root relationship to the contact. b. Make sure the contact is above the High Water Mark on the source data. c. Import new subscribers to the All Subscribers table. d. Fire the event in both Automation Studio and the Entry Event.
a. Select a source DE with a root relationship to the contact. b. Make sure the contact is above the High Water Mark on the source data.
103
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. Upgrade the Marketing Cloud Account to ConnectedApp Authentication c. Use Data Stream to sync object data into a Data Extension in the Marketing Cloud d. Share Sales Cloud user licenses across Marketing Cloud users
b. Upgrade the Marketing Cloud Account to ConnectedApp Authentication
104
Which two statements about a database of record are correct?  Choose 2 answers a. A database of record is any database containing subscriber data. b. A database of record is a system in which a subscriber’s status is maintained. c. A database of record is a centralized storage repository of data about objects or people. d. A database of record is a data structure in which multiple opt-in statuses can be stored for a subscriber.
b. A database of record is a system in which a subscriber’s status is maintained. c. A database of record is a centralized storage repository of data about objects or people. http: //www.dqglossary.com/database%20of%20record%20%28dbor%29.html