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

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

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

A.

CSS

B.

HTML

C.

Ampscript

D.

SSJS

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:
* 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* CustomerlD
* FirstName
* EmailAddress
* OrderlD

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

Which two statements about a database of record are correct?
Choose 2 answers:

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

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.

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

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

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

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.