A customer has an eCommerce site and imports data into three data extensions daily: Orders, Order_Details, and 'Products.
The data extensions contain 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
Which two actions should be taken in Data Designer?
Choose 2 answers
Select all that apply, then click Submit answer.
-
○
Create a one-to-one relationship between the contact record and Order Details.
-
○
Create a one -to -many relationship between Orders and Order_Details.
-
○
Create a one-to-one relationship between Orders and Order_Details.
-
○
Create a one-to-one relationship between Order_Details and Products.