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?

Question

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?

Tyler Sent · Accepted Answer

Create a one-to-one relationship between the contact record and Order_Details

Tyler Sent · Accepted Answer

Create a one-to-one relationship between Order_Details and Products

Tyler Sent · Answer

Create a one-to-one relationship between Orders and order_Details

Tyler Sent · Answer

Create a one-to-many relationship between Orders and Order_Details

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 68 - Certified Marketing Cloud Consultant discussion

Suggested answer: B, C

0 comments