Salesforce Certified Marketing Cloud Consultant — Question 51

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

Answer options

• 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.

Correct answer: A, C

Explanation

The correct answer is A and C because a one-to-many relationship is necessary between Orders and Order_Details, as each order can have multiple details. Additionally, a one-to-one relationship between Order_Details and Products is appropriate since each order detail corresponds to a specific product. Options B and D are incorrect; B suggests an incorrect relationship type for Orders and Order_Details, while D does not relate to the eCommerce data structure properly.