Salesforce Certified Marketing Cloud Engagement Consultant (MCE-Con-201) Exam - Topic 1 Question 118 Discussion

Actual exam question for Salesforce's Salesforce Certified Marketing Cloud Engagement Consultant (MCE-Con-201) exam

Question #: 118
Topic #: 1

[All Salesforce Certified Marketing Cloud Engagement Consultant (MCE-Con-201) Questions]

A marketer at Northern Trail Outfitters (NTO) wants to send important updates to customers about products they have previously purchased. The marketer has little experience with coding. Also, the information is spread across multiple data extensions and is imported nightly from NTO's e-commerce platform - Contacts, Orders, Order Items, and Products.

Which design should a consultant recommend for segmentation?

CCreate SQL Query Activities for the marketer to modify.

BEstablish data relationships and create Data Filters for the marketer to modify.

ACombine the data outside of Marketing Cloud and upload it into a Sendable Data Extension.

DLink the data extensions in an Attribute Group.

Show Suggested Answer

Suggested Answer: A

by Dewitt at Jan 25, 2026, 12:13 AM

Limited Time Offer

25%

Off

Get Premium Salesforce Certified Marketing Cloud Engagement Consultant (MCE-Con-201) Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Lanie

5 days ago

I remember practicing a similar question where we had to pull data from different sources. Maybe we can create a single data extension that consolidates all the relevant information?

upvoted 0 times

...

Farrah

10 days ago

I think we should consider using SQL queries to segment the data, but I'm not entirely sure how to combine multiple data extensions effectively.

upvoted 0 times

...

Gail

15 days ago

I feel pretty confident I could tackle this. Probably start by creating a master data extension that consolidates the relevant data, then build the segmentation logic on top of that.

upvoted 0 times

...

Yuette

20 days ago

This looks tricky, but I bet I could put together a solution using a custom data extension to join the data sources. Just need to be careful with performance.

upvoted 0 times

...

Lenna

25 days ago

Okay, I can see the key is to create a segment that links the customer, their previous orders, and the product details. Might need some SQL skills for this one.

upvoted 0 times

...

Mozell

1 month ago

Hmm, I'm a bit unsure about the best approach here. I think I'd need to understand more about the specific business requirements and data constraints.

upvoted 0 times

...

Nelida

1 month ago

This seems like a complex data integration challenge. I'd start by mapping out the key entities and relationships to understand the data model.

upvoted 0 times

...