Salesforce Certified Marketing Cloud Consultant · Free Practice Question Medium

Question 5

Northern Trail Outfitters (NTO) uses Marketing Cloud to connect with its individual consumers, retailers and wholesale buyers, and its corporate apparel customers. Marketing Cloud is currently configured with data extensions containing Store, Order, Product, and Contact information. NTO is in the process of implementing Data Designer and linking its data extensions. How should consumers, retailers, and wholesale buyers be defined in Data Designer?
  • A Many-to-Many Relationship
  • B One-to-One Relationship
  • C Population
  • D One-to-Many Relationship
Reveal correct answer

Correct answer: D

Explanation

D is the correct answer because consumers, retailers, and wholesale buyers each have multiple orders and products associated with them, so a one-to-many relationship is necessary to link their contact information to the corresponding order and product information in the data extensions. A many-to-many relationship would be useful if a consumer could be associated with multiple retail stores, for example, but that is not the case here. A one-to-one relationship would only work if each contact had one order and one product associated with them, which is not realistic. Population is not a type of relationship in Data Designer.

Discussion

Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.

You must be logged in to post a comment.

Preparing For

Your Certification?

255+ certifications
Detailed explanations
Free PDF samples

Has All The Questions You Need