Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

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

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?
A) Combine the data outside of Marketing Cloud and upload it into a Sendable Data Extension.
C) Create SQL Query Activities for the marketer to modify.
B) Establish data relationships and create Data Filters for the marketer to modify.
D) Link the data extensions in an Attribute Group.

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?

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Bobbie
24 days ago
I’m surprised they haven’t streamlined this process yet!
upvoted 0 times
...
Louisa
29 days ago
They should definitely use a CRM for better segmentation.
upvoted 0 times
...
Lashandra
1 month ago
Wait, can they really manage all that without coding?
upvoted 0 times
...
Kathrine
1 month ago
Totally agree, keeping data organized is key!
upvoted 0 times
...
Zena
1 month ago
Sounds like they need a solid data integration plan!
upvoted 0 times
...
Shaquana
2 months ago
I'd recommend a custom data extension with a daily sync. Keeps it all in one place for the marketer.
upvoted 0 times
...
Nettie
2 months ago
Haha, good luck with that "little experience with coding" part. Gonna need some SQL skills for sure!
upvoted 0 times
...
Jenelle
2 months 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
2 months ago
Definitely need to consolidate the data into a single source for easy segmentation.
upvoted 0 times
...
Shakira
2 months ago
A data extension that joins the relevant tables would be the way to go.
upvoted 0 times
...
Dorothy
3 months 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
3 months 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
3 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
4 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
4 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
4 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
4 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
4 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
5 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
...

Save Cancel