What two actions should be taken in Data Designer?

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

Answer: BC

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments