Halloween Special 2026! Get Up to 25% OFF Practice Questions! Limited Time - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Salesforce Certified Marketing Cloud Engagement Specialist (MC-202) Exam - Topic 1 Question 130 Discussion

Posted by Florencia on Oct 13, 2026 at 04:14 AM

The data team at Northern Trail Outfitters (NTO) has configured a data extension that contains all customer transactions within the last 90 days. NTO'smarketing team would like to target customers who have purchased a camping tent or foldout camper in the last week; however, for this campaign, they would like to exclude anyone who has a 'silver status.

Which three tools should be used to segment this data?

Suggested Answer: A

To segment data based on specific criteria such as recentpurchases and excluding certain customer statuses, Northern Trail Outfitters should use the following tools:

SQL Query: This tool allows for complex data manipulation and filtering. You can write a query to select customers who purchased a camping tent orfoldout camper in the last week and exclude those with a 'silver status'.

Filter Definition: This tool can be used to create a filter based on the SQL query results to further refine the target audience.

Journey Builder Entry Source: This can be used to input the segmented data into a journey for further actions, such as sending targeted emails.


Get Premium Salesforce Certified Marketing Cloud Engagement Specialist (MC-202) Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test
3 comments · newest first
LO
Lorean 1 hour ago
This seems similar to a question we did on segmenting customers based on purchase history. I feel like SQL Query is definitely involved, but I’m unsure about the other two options.
LA
Lashon 5 days ago
I remember practicing with Filter Definitions before, so maybe that's part of the answer, but I can't recall if Journey Builder is the right fit here.
DU
Dudley 10 days ago
I think we might need to use SQL Query to pull the specific transactions, but I'm not entirely sure about the other tools.
0/2000 characters

Save Cancel