Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
Salesforce Discussions
exam questions

Exam Certified Marketing Cloud Consultant All Questions

View all questions & answers for the Certified Marketing Cloud Consultant exam
Go to Exam

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 Hide Answer
Suggested Answer: AC 🗳️
by dduf at March 29, 2023, 9:27 p.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
Tekc
4 months 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, 7 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
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel