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

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 1

To connect the data extensions together, you should create a one-to-many relationship between Orders and Order_Details, and a one-to-one relationship between Order_Details and Products.

Step-by-step explanation:

To connect the data extensions together, we need to establish the correct relationships between them. Based on the information given, we should take the following two actions in Data Designer:

1. Create a one-to-many relationship between Orders and Order_Details. This is because one order can have multiple order details, but each order detail is associated with only one order.
2. Create a one-to-one relationship between Order_Details and Products. This is because each order detail is associated with only one product, and each product is associated with only one order detail.