Which 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 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
A . Create a one-to-one relationship between the contact record and Order Details.
B . Create a one -to -many relationship between Orders and Order_Details.
C . Create a one-to-one relationship between Orders and Order_Details.
D . Create a one-to-one relationship between Order_Details and Products.

Answer: B,D

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments