CRT-550 Practice Test

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