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

Nettie

2 days ago

Haha, good luck with that "little experience with coding" part. Gonna need some SQL skills for sure!

upvoted 0 times

...

Jenelle

7 days ago

Sounds like a job for a custom data extension with a nightly sync. That's the way to do it.

upvoted 0 times

...

Quiana

12 days ago

Definitely need to consolidate the data into a single source for easy segmentation.

upvoted 0 times

...

Shakira

18 days ago

A data extension that joins the relevant tables would be the way to go.

upvoted 0 times

...

Dorothy

23 days ago

I feel like we should focus on the key attributes from each data extension, but I can't recall if we should prioritize customer behavior over product details in our segmentation strategy.

upvoted 0 times

...

Brandon

28 days ago

I'm a bit confused about how to handle the nightly imports. Would we need to set up an automation to keep everything updated for segmentation?

upvoted 0 times

...

Lanie

2 months 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

2 months 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

2 months 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

2 months 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

2 months 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

3 months 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

3 months 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

...