SFMC Consultant Flashcards

Question 1

Q

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. Upgrade the MC account to ConnectedApp
B. Turn off link details tracking
C. Filter data
D. Turn off Individual Level Tracking

Answer

A

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. Upgrade the MC account to ConnectedApp
B. Turn off link details tracking
C. Filter data
D. Turn off Individual Level Tracking

Question 2

Q

What are the similarities between Automation Studio and Journey Builder?

A. Have duration plus wait activity (look for answers that start with JB or AS)
B. Ability to define an email send
C. Fire an event from Automation Studio to Journey Builder

Answer

A

What are the similarities between Automation Studio and Journey Builder?

> > > > A. Have duration plus wait activity (look for answers that start with JB or AS)
B. Ability to define an email send
C. Fire an event from Automation Studio to Journey Builder

Question 3

Q

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. High Watermark if journey builder
B. Preference center is too strict
C. Deliverability issues on account
D. Email frequency too high

Answer

A

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. High Watermark if journey builder
B. Preference center is too strict
C. Deliverability issues on account
D. Email frequency too high

Question 4

Q

What is the skill set you need to build emails with dynamic content?

A. CSS
B. HTML
C. Ampscript
D. SSJS

Answer

A

What is the skill set you need to build emails with dynamic content?

A. CSS
B. HTML
»» C. Ampscript
D. SSJS

Question 5

Q

How do you add a contact in contact builder?

A. Import to MyLists
B. Import to All Subscribers List
C. Import to DE
D. Add manually to All Subscribers

Answer

A

How do you add a contact in contact builder?

> > > > A. Import to MyLists
B. Import to All Subscribers List
C. Import to DE
D. Add manually to All Subscribers

Question 6

Q

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

A. Marketing Channel Manager Role
B. Regional or Local Administrator Role
C. Marketing Cloud Administrator Role
D. Email marketing manager role

Answer

A

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

A. Marketing Channel Manager Role
B. Regional or Local Administrator Role
»» C. Marketing Cloud Administrator Role
D. Email marketing manager role

Question 7

Q

NTO has to import a file that will be different every time.
What method should be used?

A. Update
B. Overwrite
C. Add and Update
D. Add Only

Answer

A

NTO has to import a file that will be different every time.
What method should be used?

A. Update
»» B. Overwrite
C. Add and Update
D. Add Only

Question 8

Q

A customer has several values that need to be used in the body of an email send.

The data would be stored in a reference data extension, related on SubscriberKey
There may be one or more records for each subscriber
The audience is generally over 1 million subscribers
The content is time sensitive and should be sent as quickly as possible
The customer is not using “Catch and release” sending
The reference data extension contains 25 columns

What method should be used?

A. AMPScript a single LookupOrderRows function
B. Dynamic content via the Dynamic content wizard
C. Server side JavaScript a single LookupOrderedRows function
D. AMPScript a single lookup function

Answer

A

A customer has several values that need to be used in the body of an email send.

The data would be stored in a reference data extension, related on SubscriberKey
There may be one or more records for each subscriber
The audience is generally over 1 million subscribers
The content is time sensitive and should be sent as quickly as possible
The customer is not using “Catch and release” sending
The reference data extension contains 25 columns

What method should be used?

A. AMPScript a single LookupOrderRows function
B. Dynamic content via the Dynamic content wizard
C. Server side JavaScript a single LookupOrderedRows function
D. AMPScript a single lookup function

Answer: A

Question 9

Q

As part of their brand guidelines, NTO uses a custom brand font for all print marketing materials. NTO wants to use their custom brand font in email as well.
What is the recommended best practices for font usage in email?

A. Use a web-safe font for text that closely matches the brand’s custom font.
B. Build an email as one image, with all text saved in the brand font.
C. Edit an email’s HTML to list the custom brand font in the style tag’s font-family property.
D. Build an email using multiple images, with all text saved in the brand font.

Answer

A

As part of their brand guidelines, NTO uses a custom brand font for all print marketing materials. NTO wants to use their custom brand font in email as well.
What is the recommended best practices for font usage in email?

A. Use a web-safe font for text that closely matches the brand’s custom font.
B. Build an email as one image, with all text saved in the brand font.
C. Edit an email’s HTML to list the custom brand font in the style tag’s font-family property.
D. Build an email using multiple images, with all text saved in the brand font.

Answer: A

Question 10

Q

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

A. How will Marketing Cloud and the database sync up?
B. Will new users have an “Email ID”?
C. What will be used as the Subscriber Key?
D. What publication lists will be used?
E. Will the company need a custom preference center?

Answer

A

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

A. How will Marketing Cloud and the database sync up?
B. Will new users have an “Email ID”?
C. What will be used as the Subscriber Key?
D. What publication lists will be used?
E. Will the company need a custom preference center?

Answer: A, B, C

Question 11

Q

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

A. Increase volume of emails to a wider audience
B. Increase the use of dynamic content in emails
C. Adopt a Cart Abandonment Email Campaign
D. Introduce more identity verification steps in check out process

Answer

A

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

A. Increase volume of emails to a wider audience
B. Increase the use of dynamic content in emails
C. Adopt a Cart Abandonment Email Campaign
D. Introduce more identity verification steps in check out process

Answer: B, C

Question 12

Q

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 activity -> Three filter activities -> Three send definitions to the filtered audiences
B. Three send definitions to the master data extension
C. Import activity -> Three send definitions to the master data extension
D. Three filter activities -> Three send definitions to the filtered audiences

Answer

A

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 activity -> Three filter activities -> Three send definitions to the filtered audiences
B. Three send definitions to the master data extension
C. Import activity -> Three send definitions to the master data extension
D. Three filter activities -> Three send definitions to the filtered audiences

Answer: D

Question 13

Q

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

The email content will highlight new inventory each day.
A small team will run both their digital marketing operations and their email program.
A user needs to build, test, and send a daily email in less than an hour.
Images for the emails will be hosted on their website CMS.

Which question is relevant to identify strategies for designing the custom template for the customer’s daily promotional email?

A. Will image URLs be available publicly?
B. How often will the layout of the content in a content area change?
C. What is the maximum file size of the images being used?
D. How often will email content be image-only with text overlaying images?
E. What from name will be used for these emails?

Answer

A

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

The email content will highlight new inventory each day.
A small team will run both their digital marketing operations and their email program.
A user needs to build, test, and send a daily email in less than an hour.
Images for the emails will be hosted on their website CMS.

Which question is relevant to identify strategies for designing the custom template for the customer’s daily promotional email?

A. Will image URLs be available publicly?
B. How often will the layout of the content in a content area change?
C. What is the maximum file size of the images being used?
D. How often will email content be image-only with text overlaying images?
E. What from name will be used for these emails?

Answer: A, B, D

Question 14

Q

A publishing company presented the following: A need to send renewal reminders to customers whose subscribers expire in 7 days and 15 days. A campaign needs to created and managed by a general marketing user who will not have administrative rights and who is not technical. The customer’s expiration data is included in the data filter.
Which three components should the customer’s solution include?

A. Data Filter
B. Template Based emails
C. Suppression List
D. Automation Studio
E. Triggered Send

Answer

A

A publishing company presented the following: A need to send renewal reminders to customers whose subscribers expire in 7 days and 15 days. A campaign needs to created and managed by a general marketing user who will not have administrative rights and who is not technical. The customer’s expiration data is included in the data filter.
Which three components should the customer’s solution include?

A. Data Filter
B. Template Based emails
C. Suppression List
D. Automation Studio
E. Triggered Send

Answer: A, B, D

Question 15

Q

Which three statements about Send Log Data is correct?

A. Uses Measures, filters and programs
B. Accessed using query
C. Can be viewed in standard report
D. Can be stored for periods of time
E. Added to a standard view

Answer

A

Which three statements about Send Log Data is correct?

A. Uses Measures, filters and programs
B. Accessed using query
C. Can be viewed in standard report
D. Can be stored for periods of time
E. Added to a standard view

Answer: A, B, D

Question 16

Q

A retail company needs to create journeys that will target subscribers based on website behavior. They have identified three separate groups:
· Customer who searched for an item on their website
· Customers who abandoned a cart on their website
· Customers who made a purchase on their website

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

A. Should customers exit the journey when the goal is met?
B. How are the subscribers identified in your web analytics?
C. How many messages should be included in each journey?
D. Should a single customer exist in multiple journeys at the same time?
E. How long after the behavior occurs will a subscriber need to enter a journey?

Answer

A

A retail company needs to create journeys that will target subscribers based on website behavior. They have identified three separate groups:
· Customer who searched for an item on their website
· Customers who abandoned a cart on their website
· Customers who made a purchase on their website

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

A. Should customers exit the journey when the goal is met?
B. How are the subscribers identified in your web analytics?
C. How many messages should be included in each journey?
D. Should a single customer exist in multiple journeys at the same time?
E. How long after the behavior occurs will a subscriber need to enter a journey?

Answer: A, B, E

Question 17

Q

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

A. A scheduled automation to send emails to customers who made a purchase daily
B. A triggered automation to send emails to customers who have made a purchase
C. A triggered message to send an email as soon as a customer completes a purchase
D. A user-initiated message to send an email to customers who made a purchase daily

Answer

A

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

A. A scheduled automation to send emails to customers who made a purchase daily
B. A triggered automation to send emails to customers who have made a purchase
C. A triggered message to send an email as soon as a customer completes a purchase
D. A user-initiated message to send an email to customers who made a purchase daily

Answer: C

Question 18

Q

A consultant needs to send an email to subscribers who have made a purchase. The data used for the send exists on two data extensions Subscribers and OrderTable, and the customer would like to include key information from both tables, such as:

CustomerID
FirstName
EmailAddress
OrderID
OrderDate
ShippedDate

Which SQL statement should the consultant use?

Answer

A

A consultant needs to send an email to subscribers who have made a purchase. The data used for the send exists on two data extensions Subscribers and OrderTable, and the customer would like to include key information from both tables, such as:

CustomerID
FirstName
EmailAddress
OrderID
OrderDate
ShippedDate

Which SQL statement should the consultant use?

Answer:
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

Question 19

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?

A. Is the purpose of these emails for acquisition or retention or transactional?
B. Will a lookup table be needed for a dynamic “From Name”?
C. Will customer be able to sign up for the loyalty program at the store?
D. Will “Version” values/meanings change, precluding reusable AMPScript?

Answer

A

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?

A. Is the purpose of these emails for acquisition or retention or transactional?
B. Will a lookup table be needed for a dynamic “From Name”?
C. Will customer be able to sign up for the loyalty program at the store?
D. Will “Version” values/meanings change, precluding reusable AMPScript?

Answer: B, D

Question 20

Q

Which steps should be included in the customer’s automation?

A. Import activity -> Three filter activities -> Three send definitions to the filtered audiences
B. Three send definitions to the master data extension
C. Import activity -> Three send definitions to the master data extension
D. Three filter activities -> Three send definitions to the filtered audiences

Answer

A

Which steps should be included in the customer’s automation?

A. Import activity -> Three filter activities -> Three send definitions to the filtered audiences
B. Three send definitions to the master data extension
C. Import activity -> Three send definitions to the master data extension
D. Three filter activities -> Three send definitions to the filtered audiences

Answer: D

Question 21

Q

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

The email content will highlight new inventory each day.
A small team will run both their digital marketing operations and their email program.
A user needs to build, test, and send a daily email in less than an hour.
Images for the emails will be hosted on their website CMS.

Which question is relevant to identify strategies for designing the custom template for the customer’s daily promotional email?

A. Will image URLs be available publicly?
B. How often will the layout of the content in a content area change?
C. What is the maximum file size of the images being used?
D. How often will email content be image-only with text overlaying images?
E. What from name will be used for these emails?

Answer

A

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

The email content will highlight new inventory each day.
A small team will run both their digital marketing operations and their email program.
A user needs to build, test, and send a daily email in less than an hour.
Images for the emails will be hosted on their website CMS.

Which question is relevant to identify strategies for designing the custom template for the customer’s daily promotional email?

A. Will image URLs be available publicly?
B. How often will the layout of the content in a content area change?
C. What is the maximum file size of the images being used?
D. How often will email content be image-only with text overlaying images?
E. What from name will be used for these emails?

Answer: A, B, D

Question 22

Q

A customer wants to display a subscriber’s first name and the data of send in its monthly newsletter, subscriber first name data is stored in data extension that won’t be used in the send definition.
Which option should be in this scenario?

A. Personalization strings
B. Guide Template Language
C. SQL Query
D. AMPscript

Answer

A

A customer wants to display a subscriber’s first name and the data of send in its monthly newsletter, subscriber first name data is stored in data extension that won’t be used in the send definition.
Which option should be in this scenario?

A. Personalization strings
B. Guide Template Language
C. SQL Query
D. AMPscript

Answer: D

Question 23

Q

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 MC
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. Query activity to pull data view information -> Extract activity of data extension -> Transfer activity
C. Extract activity of tracking extracts that combines data into required file -> Transfer activity
D. Extract activity of data view tables -> Query activity to create the required file -> Transfer activity

Answer

A

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 MC
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. Query activity to pull data view information -> Extract activity of data extension -> Transfer activity
C. Extract activity of tracking extracts that combines data into required file -> Transfer activity
D. Extract activity of data view tables -> Query activity to create the required file -> Transfer activity

Answer: B

Question 24

Q

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.
What two pieces of information would help NTO achieve this objective?

A. Last purchase date
B. Products purchased from a competitor
C. Number of items per order
D. Channel preference of customers

Answer

A

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.
What two pieces of information would help NTO achieve this objective?

A. Last purchase date
B. Products purchased from a competitor
C. Number of items per order
D. Channel preference of customers

Answer: A, D

Question 25

Q

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

A. 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
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. 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.

Answer

A

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

A. 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
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. 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.

Answer: C

Question 26

Q

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 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. Do not send an email, as outage may have increased negative sentiment, resulting in unsubscribes.
C. Create a user-initiated message to logged-in customers to send once the website is restarted
D. Create and send an apology email that includes a discount for a future purchase to all customers.

Answer

A

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 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. Do not send an email, as outage may have increased negative sentiment, resulting in unsubscribes.
C. Create a user-initiated message to logged-in customers to send once the website is restarted
D. Create and send an apology email that includes a discount for a future purchase to all customers.

Answer: C

Question 27

Q

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

A) AMPScript
B) HTML
C) CSS
D) SQL

Answer

A

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

A) AMPScript
B) HTML
C) CSS
D) SQL

Answer: D

Question 28

Q

NTO wants not only to send to their best customers, but also those most likely to buy.
What data will be helpful to send out an email which increases purchase frequency?

A) last purchase date
B) proximity to store
C) lifetime purchase value
D) conversion rate

Answer

A

NTO wants not only to send to their best customers, but also those most likely to buy.
What data will be helpful to send out an email which increases purchase frequency?

A) last purchase date
B) proximity to store
C) lifetime purchase value
D) conversion rate

Answer: A, C, D

Question 29

Q

What are two ways Contact builder can alter the data in Data Extensions

A) Add Single Record
B) Extract Data
C) Clear Records

Answer

A

What are two ways Contact builder can alter the data in Data Extensions

A) Add Single Record
B) Extract Data
C) Clear Records

Answer: A, C

Question 30

Q

Which two statements about a database of record are correct?

A. A database of record is a centralized storage repository of data about objects or people
B. A database of record is any database that contains subscriber data
C. A database of record is system in which subscriber’s status is maintained
D. A database of record is a data structure in which multiple opt-in statuses can be stored for a subscriber

Answer

A

Which two statements about a database of record are correct?

A. A database of record is a centralized storage repository of data about objects or people
B. A database of record is any database that contains subscriber data
C. A database of record is system in which subscriber’s status is maintained
D. A database of record is a data structure in which multiple opt-in statuses can be stored for a subscriber

Answer: A, C

Question 31

Q

A customer has an eCommerce site and Imports data into three data extensions daily; ‘Orders’, ‘Order_Details’ and ‘Products’
the data extension contains 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

What two actions should be taken in Data Designer?

A. Create a one-to-one relationship between Orders and order_Details
B. Create a one-to-one relationship between the contact record and Order_Details
C. Create a one-to-one relationship between Order_Details and Products
D. Create a one-to-many relationship between Orders and Order_Details

Answer

A

A customer has an eCommerce site and Imports data into three data extensions daily; ‘Orders’, ‘Order_Details’ and ‘Products’
the data extension contains 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

What two actions should be taken in Data Designer?

A. Create a one-to-one relationship between Orders and order_Details
B. Create a one-to-one relationship between the contact record and Order_Details
C. Create a one-to-one relationship between Order_Details and Products
D. Create a one-to-many relationship between Orders and Order_Details

Answer: C,D

Question 32

Q

How do you use data designer to link the web analytics data to your subscriber data?

Answer

A

How do you use data designer to link the web analytics data to your subscriber data?

Answer: Use a marketing cloud data extension

Question 33

Q

A customer executes a large number of sends via Marketing Cloud Connect and is concerned about API Limits.
What should the consultant suggest to minimise 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 Authentification
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

Answer

A

A customer executes a large number of sends via Marketing Cloud Connect and is concerned about API Limits.
What should the consultant suggest to minimise 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 Authentification
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

Answer: A, B

Question 34

Q

NTO has scenario of a journey for “post-purchasing communication”: which re-entry setting is correct?

A) no reentry
B) reentry anytime
C) reentry only after exiting
D) reentry after time

Answer

A

NTO has scenario of a journey for “post-purchasing communication”: which re-entry setting is correct?

A) no reentry
B) reentry anytime
C) reentry only after exiting
D) reentry after time

Answer: C

Question 35

Q

Customer Event:
- gather 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 2 things necessary:

A: data extension with opt in status
B: Send email activity which contains a link to subscription center
C: WebCollect
D: SmartCapture

Answer

A

Customer Event:
- gather 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 2 things necessary:

A: data extension with opt in status
B: Send email activity which contains a link to subscription center
C: WebCollect
D: SmartCapture

Answer: B, D

Question 36

Q

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

A) AMPScript
B) HTML
C) CSS
D) SQL

Answer

A

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

A) AMPScript
B) HTML
C) CSS
D) SQL

Answer: D

Question 37

Q

Which statement IS correct regarding the automation tools in the Marketing Cloud?

A. Automation Studio and Journey Builder allow users to define a wait state based on duration or duration + time.
B. Automation Studio allows users to inject Contacts from a data extension into an interaction in Journey Builder.
C. Like Journey Builder, Automation Studio allows users to define the parameters for a send within the tool.
D. Journey Builder allows users to update a contact record in an interaction or import data into a data extension.
E. Like Automation Studio, Journey Builder allows users to repeat an interaction indefinitely

Answer

A

Which statement IS correct regarding the automation tools in the Marketing Cloud?

A. Automation Studio and Journey Builder allow users to define a wait state based on duration or duration + time.
B. Automation Studio allows users to inject Contacts from a data extension into an interaction in Journey Builder.
C. Like Journey Builder, Automation Studio allows users to define the parameters for a send within the tool.
D. Journey Builder allows users to update a contact record in an interaction or import data into a data extension.
E. Like Automation Studio, Journey Builder allows users to repeat an interaction indefinitely

Answer: B, C, E

Question 38

Q

A customer needs to compare the engagement across three creative versions, and then send a follow-up email for those contacts who did not engage with any of the test versions.
Which sequence of activities would best accomplish 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

Answer

A

A customer needs to compare the engagement across three creative versions, and then send a follow-up email for those contacts who did not engage with any of the test versions.
Which sequence of activities would best accomplish 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

Answer: C

Question 39

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 steps should be used to accomplish this in Journey Builder?

A. Define Goal, Send Email, Wait, Decision Split
B. Random Split, Send Email, Wait, Define Goal
C. Define Goal, Update Contact Data, Send Email, Wait
D. Update Contact Data, Wait, Send Email, Join

Answer

A

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 steps should be used to accomplish this in Journey Builder?

A. Define Goal, Send Email, Wait, Decision Split
B. Random Split, Send Email, Wait, Define Goal
C. Define Goal, Update Contact Data, Send Email, Wait
D. Update Contact Data, Wait, Send Email, Join

Answer: C

Question 40

Q

A customer wants to create a journey with the goal of making users activate their accounts
within 72 h 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 and 48 h after creating an account. The user exits the journey if they activate their account.
Which activities should be included in 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 > 48 hour Wait > Send Email
C. 24 hour Wait > Decision Split > Send Email > 48 hour Wait > Decision Split > Send Email
D. Decision Split > 24 hour Wait > Send Email > Decision Split > 24 hour Wait > Send Email

Answer

A

A customer wants to create a journey with the goal of making users activate their accounts
within 72 h 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 and 48 h after creating an account. The user exits the journey if they activate their account.
Which activities should be included in 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 > 48 hour Wait > Send Email
C. 24 hour Wait > Decision Split > Send Email > 48 hour Wait > Decision Split > Send Email
D. Decision Split > 24 hour Wait > Send Email > Decision Split > 24 hour Wait > Send Email

Answer: A

Question 41

Q

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?

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.

Answer

A

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?

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.

Answer: A, C

Question 42

Q

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.

Answer

A

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.

Answer: B

Question 43

Q

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 Customers Orders Products
B. Customer Data Customers Orders Products
C. Customer Data Customers Orders Products
D. Customer Data Products Orders Customers

Answer

A

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 Customers Orders Products
B. Customer Data Customers Orders Products
C. Customer Data Customers Orders Products
D. Customer Data Products Orders Customers

Answer: B

Question 44

Q

What statements are correct regarding Attribute Groups?

A. They link data extensions to subscriber lists.
B. They link data extensions to contacts.
C. They link data extensions to other data extensions.
D. They link subscriber lists to contacts.

Answer

A

What statements are correct regarding Attribute Groups?

A. They link data extensions to subscriber lists.
B. They link data extensions to contacts.
C. They link data extensions to other data extensions.
D. They link subscriber lists to contacts.

Answer: B, C

Question 45

Q

Northern Trail Outfitters (NTO) is considering adopting Attribute Groups when incorporating data from their external systems.
What statements are accurate regarding Attribute Groups?

A. They can contain only one data extension.
B. They can be created by templates to accomplish certain tasks.
C. They link data extensions to other data extensions or contacts.
D. They replicate the structure from the external system data into templates.

Answer

A

Northern Trail Outfitters (NTO) is considering adopting Attribute Groups when incorporating data from their external systems.
What statements are accurate regarding Attribute Groups?

A. They can contain only one data extension.
B. They can be created by templates to accomplish certain tasks.
C. They link data extensions to other data extensions or contacts.
D. They replicate the structure from the external system data into templates.

Answer: B, C

Question 46

Q

FIND: Which statement IS correct regarding the automation tools in the Marketing Cloud?

A. Automation Studio and Journey Builder allow users to define a wait state based on duration or duration + time.
B. Automation Studio allows users to inject Contacts from a data extension into an interaction in Journey Builder.
C. Like Journey Builder, Automation Studio allows users to define the parameters for a send within the tool.
D. Journey Builder allows users to update a contact record in an interaction or import data into a data extension.
E. Like Automation Studio, Journey Builder allows users to repeat an interaction indefinitely

Answer

A

FIND: Which statement IS correct regarding the automation tools in the Marketing Cloud?

A. Automation Studio and Journey Builder allow users to define a wait state based on duration or duration + time.
B. Automation Studio allows users to inject Contacts from a data extension into an interaction in Journey Builder.
C. Like Journey Builder, Automation Studio allows users to define the parameters for a send within the tool.
D. Journey Builder allows users to update a contact record in an interaction or import data into a data extension.
E. Like Automation Studio, Journey Builder allows users to repeat an interaction indefinitely

Answer: B, C, E

Question 47

Q

A customer would like to send a quarterly re-engagement 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 configuration is recommended for the re-engagement email send?

A. Triggered Send
B. Guided Send
C. Automated Send
D. User-Initiated Send

Answer

A

A customer would like to send a quarterly re-engagement 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 configuration is recommended for the re-engagement email send?

A. Triggered Send
B. Guided Send
C. Automated Send
D. User-Initiated Send

Answer: D

Question 48

Q

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. SQL Query
D. Guide Template Language

Answer

A

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. SQL Query
D. Guide Template Language

Answer: B

Question 49

Q

A customer has several values that need to be used in the body of an email send:

The data would be stored in a reference data extension, related on SubscriberKey.
There may be one or more records for each subscriber.
The audience is generally over 1 million subscribers.
The content is time sensitive and should be sent as quickly as possible.
The customer is not using “catch and release” sending.
The reference data extension contains 25 columns.

Which method should be used?

A. AMPscript a single Lookup Function
B. Server Side Javascript a single LookupOrderedRows Function
C. AMPscript a single LookupOrderedRows Function
D. Dynamic content via the Dynamic Content Wizard

Answer

A

A customer has several values that need to be used in the body of an email send:

The data would be stored in a reference data extension, related on SubscriberKey.
There may be one or more records for each subscriber.
The audience is generally over 1 million subscribers.
The content is time sensitive and should be sent as quickly as possible.
The customer is not using “catch and release” sending.
The reference data extension contains 25 columns.

Which method should be used?

A. AMPscript a single Lookup Function
B. Server Side Javascript a single LookupOrderedRows Function
C. AMPscript a single LookupOrderedRows Function
D. Dynamic content via the Dynamic Content Wizard

Answer: C

Question 50

Q

Which statement is correct regarding tracking aliases?

A. Tracking aliases are found in Tracking and some standard reports.
B. Tracking aliases are associated with a URL in HTML as: tag=”alias text”.
C. Tracking aliases can differentiate click activity in an email to the same URL.
D. Tracking aliases are primarily relevant when used with email conversion tracking.

Answer

A

Which statement is correct regarding tracking aliases?

A. Tracking aliases are found in Tracking and some standard reports.
B. Tracking aliases are associated with a URL in HTML as: tag=”alias text”.
C. Tracking aliases can differentiate click activity in an email to the same URL.
D. Tracking aliases are primarily relevant when used with email conversion tracking.

Answer: C, D

Question 51

Q

What is a capability of the Import within Contact Builder?

A. The data source can be a local file, data filter, or file on any FTP.
B. The target destination can be a DE, list, or All Contacts for Mobile Push or Connect.
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.

Answer

A

What is a capability of the Import within Contact Builder?

A. The data source can be a local file, data filter, or file on any FTP.
B. The target destination can be a DE, list, or All Contacts for Mobile Push or Connect.
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.

Answer: B, D

Question 52

Q

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, Data Extract, Filters, Sends
B. File Transfer, Query, Measures, Sends
C. File Transfer, Import, Measures, Sends
D. File Transfer, Import, Query, Sends

Answer

A

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, Data Extract, Filters, Sends
B. File Transfer, Query, Measures, Sends
C. File Transfer, Import, Measures, Sends
D. File Transfer, Import, Query, Sends

Answer: D

Question 53

Q

A customer needs to import data from an SFTP site. The customer wants to:

Segment the contents of the file and then send emails.
Transfer the file to the SFTP site at various times daily.
Send to data extensions.

Which workflow should meet these requirements?

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. Scheduled Automation: Import File > SQL Query(s) > Send Email(s)
D. Triggered Automation: Import File > Group Refresh > Send Email(s)

Answer

A

A customer needs to import data from an SFTP site. The customer wants to:

Segment the contents of the file and then send emails.
Transfer the file to the SFTP site at various times daily.
Send to data extensions.

Which workflow should meet these requirements?

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. Scheduled Automation: Import File > SQL Query(s) > Send Email(s)
D. Triggered Automation: Import File > Group Refresh > Send Email(s)

Answer: A

Question 54

Q

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

Answer

A

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

Answer: D

Question 55

Q

A customer wants to automate the send of a monthly promotional email. The customer will upload an audience file to their account’s Enhanced FTP 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.
Given the customer’s requirements, which method should be used to automate their monthly promotional email?

A. Create a triggered automation that includes an import activity and triggered send.
B. Create a scheduled daily automation that includes an import activity and user-initiated send.
C. Create a scheduled monthly automation that includes an import activity and triggered send.
D. Create a triggered automation that includes an import activity and user-initiated send.

Answer: D

Answer

A

A customer wants to automate the send of a monthly promotional email. The customer will upload an audience file to their account’s Enhanced FTP 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.
Given the customer’s requirements, which method should be used to automate their monthly promotional email?

A. Create a triggered automation that includes an import activity and triggered send.
B. Create a scheduled daily automation that includes an import activity and user-initiated send.
C. Create a scheduled monthly automation that includes an import activity and triggered send.
D. Create a triggered automation that includes an import activity and user-initiated send.

Answer: D

Question 56

Q

A customer would like to send a quarterly re-engagement 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 configuration is recommended for the re-engagement email send?

A. Triggered Send
B. Guided Send
C. Automated Send
D. User-Initiated Send

Answer

A

A customer would like to send a quarterly re-engagement 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 configuration is recommended for the re-engagement email send?

A. Triggered Send
B. Guided Send
C. Automated Send
D. User-Initiated Send

Answer: D

Question 57

Q

A consultant needs to send an email to subscribers who have made a purchase. The data used for the send exists on two data extensions–Subscribers and OrderTable, and the customer would like to include key information from both tables, such as:

CustomerlD
FirstName
EmailAddress
OrderlD
OrderDate
ShippedDate

Which SQL statement should the consultant use?

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

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

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

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

Answer

A

A consultant needs to send an email to subscribers who have made a purchase. The data used for the send exists on two data extensions–Subscribers and OrderTable, and the customer would like to include key information from both tables, such as:

CustomerlD
FirstName
EmailAddress
OrderlD
OrderDate
ShippedDate

Which SQL statement should the consultant use?

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

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

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

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

Answer: D

Question 58

Q

A customer provides a file containing only new and updated subscriber records exported from its marketing database.

The file will be uploaded to the customer’s Enhanced FTP automatically at 3AM daily.
The customer requires that the import completes prior to 4AM.
On average, the file will contain about 2 million rows of data each day.

Based on the customer’s requirements and recommended best practices, how should the daily file be imported?

A) Import the file to a data extension, using the ‘add and update’ method.
B) Import the file to a list, using the ‘update only’ method.
C) Import the file to a list, using the ‘add and update’ method.
D) Import the file to a data extension, using the ‘overwrite’ method.

Answer

A

A customer provides a file containing only new and updated subscriber records exported from its marketing database.

The file will be uploaded to the customer’s Enhanced FTP automatically at 3AM daily.
The customer requires that the import completes prior to 4AM.
On average, the file will contain about 2 million rows of data each day.

Based on the customer’s requirements and recommended best practices, how should the daily file be imported?

A) Import the file to a data extension, using the ‘add and update’ method.
B) Import the file to a list, using the ‘update only’ method.
C) Import the file to a list, using the ‘add and update’ method.
D) Import the file to a data extension, using the ‘overwrite’ method.

Answer: A

Question 59

Q

The customer has these requirements for storing engagement data in their data warehouse:

All email open and click activity must be pulled daily from the Marketing Cloud.
Output files must meet the specific requirements for the data warehouse.
All the activity must be provided via FTP in one file.

Which automation workflow meets the customer requirements?

A. Report activity that generates Recent Send Summary report > Report delivered directly to FTP
B. Extract activity of Tracking Extracts that combines data into required file > Transfer activity
C. Query activity to pull data view information > Extract activity of data extension > Transfer activity
D. Extract activity of data view tables > Query activity to create the required file > Transfer activity

Answer

A

The customer has these requirements for storing engagement data in their data warehouse:

All email open and click activity must be pulled daily from the Marketing Cloud.
Output files must meet the specific requirements for the data warehouse.
All the activity must be provided via FTP in one file.

Which automation workflow meets the customer requirements?

A. Report activity that generates Recent Send Summary report > Report delivered directly to FTP
B. Extract activity of Tracking Extracts that combines data into required file > Transfer activity
C. Query activity to pull data view information > Extract activity of data extension > Transfer activity
D. Extract activity of data view tables > Query activity to create the required file > Transfer activity

Answer: C

Question 60

Q

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

A. An automation that queries the Complaint data view.
B. An automation that generates the Unsubscribe Event Extract.
C. An automation that queries the Unsubscribe data view.
D. An automation that generates the Complaint Tracking Extract.

Answer

A

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

A. An automation that queries the Complaint data view.
B. An automation that generates the Unsubscribe Event Extract.
C. An automation that queries the Unsubscribe data view.
D. An automation that generates the Complaint Tracking Extract.

Answer: A

Question 61

Q

What is a correct statement about Send Log data?

A. Can be accessed via Query activities.
B. Can be incorporated into standard reports.
C. Can be stored for a set period of time.
D. Can be added to a standard data view.
E. Can be included in measures and filters.

Answer

A

What is a correct statement about Send Log data?

A. Can be accessed via Query activities.
B. Can be incorporated into standard reports.
C. Can be stored for a set period of time.
D. Can be added to a standard data view.
E. Can be included in measures and filters.

Answer: A, C, E

Question 62

Q

Which data object should be used in conjunction with data extensions to create an opt- down strategy for customers?

A. Profile attributes
B. Preference attributes
C. Publication Lists
D. Preference Lists

Answer

A

Which data object should be used in conjunction with data extensions to create an opt- down strategy for customers?

A. Profile attributes
B. Preference attributes
C. Publication Lists
D. Preference Lists

Answer: C

Question 63

Q

What are data extension data retention policies?

A. Settings to “soft” delete all data in a Data Extension so there is no data loss.
B. Settings to control when a data extension creates a back-up of the data it contains.
C. Settings to define when a data extension or the data within the data extension is deleted.
D. Settings to prevent users from deleting a Data Extension created by another user.

Answer

A

What are data extension data retention policies?

A. Settings to “soft” delete all data in a Data Extension so there is no data loss.
B. Settings to control when a data extension creates a back-up of the data it contains.
C. Settings to define when a data extension or the data within the data extension is deleted.
D. Settings to prevent users from deleting a Data Extension created by another user.

Answer: C

Question 64

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 content based on regional market.

In order for this solution to be viable, which skill set does the customer team need to possess?

A. AMPscript
B. SSJS
C. SQL
D. HTML

Answer

A

A customer team wants to retarget subscribers who click on links of key items promoted across email campaigns. The customer has indicated the following:

Emails will be built using a custom dynamic template for these messages.
Links will vary over time and across campaigns.
Click activity will be cross-referenced with subscribers’ regional markets on a master subscriber data extension.
Retargeting messages will dynamically populate content based on regional market.

In order for this solution to be viable, which skill set does the customer team need to possess?

A. AMPscript
B. SSJS
C. SQL
D. HTML

Answer: A

Answer 65

A

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

Customer data will be fully refreshed every night via Import activity from the customer’s data warehouse.
Contact records will be augmented by relational data tables via Contact Builder.
The customer data file will contain 5M records with 40+ attributes.
One attribute will house HTML code, 1000 characters max, that will be used to populate Account Access content areas in emails.
A customer ID will be used as the unique identifier for each contact.

Which statement differentiates the use of data extensions over lists?

A. Data extensions allow for add/update Import activity.
B. Data extensions can store HTML code as an attribute.
C. Data extensions support Customer ID to be used as Subscriber Key.
D. Data extensions are necessary for Contact Builder

Answer: D

Answer 66

A

A publishing company has presented the following:

A need to send renewal reminders to customers whose subscriptions expire in 15 days and 7 days.
A campaign needs to be created and managed by a general marketing user who will not have administrative rights and who is not technical.
The customer’s expiration date is included in the data file.

What component should the customer’s solution include?

A. Suppression list
B. Data Filter
C. Triggered Send
D. Template-based emails
E. Automation Studio

Answer: B, D, E

Answer 67

A

Analyst of The Northern Trail Outfitters (NTO) marketing team needs to pull email metrics for an upcoming quarterly company meeting. These metrics need to be reported per email campaign for each of NTO’s Business Units:

Number of Sends
Delivery Rate
Overall Bounce Rate
Block Bounce Rate
Open Rate
Click Rate
Complaint Rate
Unsubscribe Rate

Which email report should NTO’s Marketing Analyst pull from Marketing Cloud to get this information?

A) Campaign Email Tracking Report
B) Email Performance Over Time Report
C) Email Send Report
D) Account Send Summary Report

Answer: A

Answer 68

A

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?

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.

Answer: B, D, E

Answer 69

A

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?

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.

Answer: B, D, E

Answer 70

A

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 consult with the customer on API integration with their website.
B) 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 leverage a SmartCapture form that is hosted in Landing Pages.
D. Configure a data structure using Lists and leverage the out-of-the-box Preference Center.

Answer: A

Answer 71

A

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

A. Pick “Choose from list,” selecting the from name and from email values from the list of account users.
B. Utilize data extension AMPScript lookups to dynamically populate the from name and from email values.
C. Match the external keys of the sender profile and data extension containing account representative details.
D. Populate substitution strings in the sender profile for the profile attributes containing from name and from email values.

Answer: B, D

Answer 72

A

A large retail company has selected Marketing Cloud and has asked to be fully migrated from their existing platform in three weeks. They have communicated the following:

They currently have 3 million customers.
They email customers twice a week with no known deliverability issues.
Their contract includes one Sender Authentication Package (SAP).

What response articulates proper IP warming?

A. IP ramp-up takes four to six weeks to be able to fully send to all 3 million customers.
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 can be bypassed, given their historical lack of deliverability issues.

Answer: A, C

Answer 73

A

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

A. Check the Scope by User box in Marketing Cloud.
B. Create a User in Sales Cloud with a System Administrator Profile.
C. Ensure that the User has the correct profile in Marketing Cloud.
D. Ensure that the User is assigned as System Administrator in Sales Cloud.

Answer: A

Answer 74

A

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

A. Use the Organization-Wide Email address.
B. Use a custom Delivery Profile.
C. Use a custom Send Classification.
D. Use the Send From Record Owner option

Answer: C, D

Answer 75

A

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

A. Use Data Stream to sync Sales Cloud objects to the Marketing Cloud.
B. Use Data Filters or Query Activities to output a Sendable Salesforce Data Extension.
C. Use Query Activities to create a Sendable Synchronized Data Extension.
D. Use Data Filters to segment data to output a Sendable Data Extension

Answer: A, B

Answer 76

A

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. Create a custom Email Specialist role with needed permissions and assign it to the Email Specialists.
B. Alter the roles of Content Creator and Data Manager by denying permissions and then assign the roles to the ‘ Email Specialists.
C. Check “Allow” automation permissions for the Content Creator Role and assign it to the Business Units.
D. Check “Allow” automation permissions for the Content Creator Role and assign it to the Email Specialists

Answer: D

Answer 77

A

Northern Trail Outfitters (NTO) needs 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

Which role should be assigned to the IT staff member?

A) Analyst
B) Data Manager
C) Administrator
D) Content Creator

Answer: B

Answer 78

A

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

A. Support non-English responses with Reply Mail Management.
B. Localized language and display options based on location and culture.
C. Tracking information for campaigns sent by each office.
D. Localized physical mailing address displayed in the default email footer

Answer: D

Answer 79

A

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

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.

Answer: C, D

Answer 80

A

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

A) Confirm that Reply Mail Management (RMM) is configured for the customer’s account.
B) Confirm that the RMM setting ‘Unsubscribe Manual Requests’ is set to YES.
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 subscriber’s request contained one of the standard terms that qualify for automatic unsubscribe.

Answer: A, B, D

Answer 81

A

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.
Select the statement that correctly describes the implication of this recommendation.

A. The IP address included in the sender authentication package will have the same reputation as the ones being used for NTO.
B. The EO business unit can also have the NTO authentication package applied simultaneously for cross-marketing emails.
C. The private domain, e-EO.com, will be used for all link wrapping, image URLs, and landing page URLs.
D. The e-EO.com domain will act as the from address for the emails and authenticate using SPF, SenderlD, and DKIM authentication.
E. The email headers for EO will still reflect the private domain for NTO since that is the parent company.

Answer: C, D

Answer 82

A

Which automation workflow meets the customer requirements?

A. Report activity that generates Recent Send Summary report > Report delivered directly to FTP
B. Extract activity of Tracking Extracts that combines data into required file > Transfer activity
C. Query activity to pull data view information > Extract activity of data extension > Transfer activity
D. Extract activity of data view tables > Query activity to create the required file > Transfer activity

Answer: C

Answer 83

A

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

A. An automation that queries the Complaint data view.
B. An automation that generates the Unsubscribe Event Extract.
C. An automation that queries the Unsubscribe data view.
D. An automation that generates the Complaint Tracking Extract.

Answer: A

Answer 84

A

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. Use a web-safe font for text that closely matches the brand’s custom font.
B. Build an email as one image, with all text saved in the brand font.
C. Edit an email’s HTML to list the custom brand font in the style tag’s font-family property.
D. Build an email using multiple images, with all text saved in the brand font.

Answer: A

Answer 85

A

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. Use a web-safe font for text that closely matches the brand’s custom font.
B. Build an email as one image, with all text saved in the brand font.
C. Edit an email’s HTML to list the custom brand font in the style tag’s font-family property.
D. Build an email using multiple images, with all text saved in the brand font.

Answer: A

Answer 86

A

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

A. How will Marketing Cloud and the database sync up?
B. Will new users have an “Email ID”?
C. What will be used as Subscriber Key?
D. What publication lists will be used?
E. Will the company need a custom preference center?

Answer: A, B, C

Answer 87

A

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

A. Increase volume of emails to a wider audience.
B. Increase the use of dynamic content in emails.
C. Adopt a Cart Abandonment Email Campaign.
D. Introduce more identity verification steps in check out process.

Answer: B, C

Answer 88

A

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.
What question should be asked to determine a data/segmentation strategy?

A. Will customers be able to sign up for the loyalty program at the store?
B. Is the purpose of these emails for acquisition or retention or transactional?
C. Will multiple languages be used, with a “From Name” lookup table needed?
D. Will version values/meanings change, precluding reusable AMPscript?

Answer: C, D

Answer 89

A

A customer is interested in designing a solution to ensure that subscribers only receive categories of emails that they want to receive. The built-in subscription center will be used as part of the solution.
Which feature should be utilized to make this happen?

A. Publication Lists
B. Subscriber Keys
C. Profile Center
D. Send Logging

Answer: A

Brainscape's Knowledge GenomeTM

SFMC Consultant Flashcards

Brainscape's Knowledge Genome^TM