Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.

Get Unlimited Access

Salesforce Discussions

Exam Certified Marketing Cloud Consultant topic 1 question 74 discussion

Actual exam question from Salesforce's Certified Marketing Cloud Consultant

Question #: 74
Topic #: 1

[All Certified Marketing Cloud Consultant Questions]

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.

Show Suggested Answer

Suggested Answer: AC 🗳️

by dduf at March 29, 2023, 9:27 p.m.

Comments

Submit Cancel

Tekc

2 days, 19 hours ago

A&C should be correct as there should be a 1:1 between order_details and products (primary key product id) as products has more information about each product id listed in the order details

upvoted 1 times

...

dduf

1 year, 3 months ago

Only a is correct, if order details and products have a one to one relationship, that means one order detail record can only point to one product (which is true) and one product can only ever point back to one order detail record, which is wrong

upvoted 2 times

...