Northern Trail Outfitters' marketing team is new to Marketing Cloud and has very little
coding experience. They have employed a consultant to help them design an automated
solution for maintaining an auto-suppression list.
Which solution should the consultant recommend?

A.

Use Einstein Segment Recommendations

B.

Use an import activity to import a file from the SFTP

C.

Use a query activity to populate the auto-suppression

D.

Use the Import Wizard in Automation Studio

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

A customer would like to store financial data related to invoicing in its data extensions.
Which field type should be used?

A.

Currency

B.

Decimal

C.

Number

D.

Float

Northern Trail Outfitters (NTO) wants to use Marketing Cloud to solicit customer service
feedback. If a customer indicates they are unhappy with the service they have received,
NTO wants a new case to be created in Service Cloud. NTO is unsure of what is possible
within Marketing Cloud but would like to use as much native functionality as possible.
What approach would a consultant recommend?

A.

Use an Engagement Split to capture positive responses, and a Case Activity to create a
new case in Service Cloud.

B.

Use Automation Studio to capture positive or negative responses, and a Case Activity to
create a new case in Service Cloud.

C.

Use an AppExchange package to create a customized API integration between
Marketing Cloud and Service Cloud.

D.

Use an Engagement Split to capture positive or negative responses, and a Custom
Activity to create a new case in Service Cloud.

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

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

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

Northern Trail Outfitters maintains their primary customer identity in their ERP system but
managers their customer service via Service Cloud. Customer data is updated in real-time
based on changes in the ERP, and the ERP customer ID serves as the Customer Key.
They want to leverage Synchronized Data Extensions to import data about cases from
Service Cloud every 15 minutes.
What consideration should be made before implementing this solution?

A.

Moving to use the email address as the contact key would simplify the integration since
it is common to both systems.

B.

Marketing Cloud will deduplicate customers based on their email address, meaning
some customers may be overwritten or not receive email.

C.

The number of contacts added to the instance will be approximately twice as large by
using this integration pattern.

D.

They will have to migrate to use Service Cloud IDs, such as the Contact ID, as the
contact key instead of ERP IDs

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

Northern Trail Outfitters wants to import new contacts gathered from an external web form.
The entries are being collected at high frequency, potentially thousands per minutes. The
data does not need to be immediately ingested into Marketing Cloud as it is used in a daily
scheduled automation.
What Should be recommended?

A.

Create this as a Journey Data Source via Journey Builder.

B.

Push each new record into Marketing Cloud vis Platform Event API on form submit.

C.

Perform a daily bulk export to SFTP for import via Automation.

D.

Recreate this external web form inside Marketing Cloud.