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

Question

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

Joost Huggers · Accepted Answer

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

Joost Huggers · Accepted Answer

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

Joost Huggers · Answer

Create a one-to-one relationship between the contact record and Order Details.

Joost Huggers · Answer

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

List of questions