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 two.)

A. Create a one-to-many relationship between Orders and Order_Details.
B. Create a one-to-one relationship between Orders and Order_Details.
C. Create a one-to-one relationship between Order_Details and Products.
D. Create a one-to-one relationship between the contact record and Order_Details.

Suggest answer: AC

Reference:

No comments:

Please share to make the community better.