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 Email Specialist (MC-202) Exam - Topic 1 Question 105 Discussion

A marketing manager wants to import the Not Sent extract into a data extension to leverage as an exclusion audience.Which steps should be configured within Automation Studio to accomplish this?
B) Tracking Extract > Import Activity > Data Extension Extract
A) Tracking Extract > Import Activity > SQL Activity
C) Tracking Extract > File Transfer > Import Activity

Salesforce Certified Marketing Cloud Email Specialist (MC-202) Exam - Topic 1 Question 105 Discussion

Actual exam question for Salesforce's Salesforce Certified Marketing Cloud Email Specialist (MC-202) exam
Question #: 105
Topic #: 1
[All Salesforce Certified Marketing Cloud Email Specialist (MC-202) Questions]

A marketing manager wants to import the Not Sent extract into a data extension to leverage as an exclusion audience.

Which steps should be configured within Automation Studio to accomplish this?

Show Suggested Answer Hide Answer
Suggested Answer: B

by Ernestine at Mar 09, 2025, 09:29 AM

Limited Time Offer

25%

Off

Get Premium Salesforce Certified Marketing Cloud Email Specialist (MC-202) Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Yuette
7 months ago
Wait, can you really use Not Sent for exclusions?
upvoted 0 times
...
Sommer
7 months ago
C seems off, not sure about that one.
upvoted 0 times
...
Maurine
7 months ago
I think B makes more sense for this.
upvoted 0 times
...
Oliva
8 months ago
Agreed, A is the best choice here!
upvoted 0 times
...
Cristal
8 months ago
Definitely A, that's the right order!
upvoted 0 times
...
Owen
8 months ago
I thought the Tracking Extract was just for pulling data, but now I'm wondering if we actually need to include a File Transfer step before the Import Activity.
upvoted 0 times
...
Cheryl
8 months ago
I’m leaning towards option A because it seems like the most logical sequence, but I’m a bit confused about the role of SQL Activity in this context.
upvoted 0 times
...
Suzi
9 months ago
I remember practicing a similar question, and I feel like the Import Activity is crucial, but I can't recall if we need to do a Data Extension Extract afterward.
upvoted 0 times
...
Krissy
9 months ago
I think the first step should definitely be a Tracking Extract, but I'm not sure if it should go straight to an Import Activity or if we need to do something else first.
upvoted 0 times
...
Deonna
9 months ago
Ugh, I'm a little confused on the specifics here. Is the File Transfer step necessary, or can we skip that and just go straight from Tracking Extract to Import Activity? I want to make sure I get this right.
upvoted 0 times
...
Mabel
9 months ago
I've got this! The answer is Tracking Extract, Import Activity, and then SQL Activity. That's the way to get that Not Sent data into a data extension and ready to use. Piece of cake!
upvoted 0 times
...
Nada
9 months ago
Okay, let me think this through. We need to get the Not Sent extract into a data extension, so we can use it as an exclusion audience. I believe the right steps are Tracking Extract, then Import Activity, and finally a Data Extension Extract to pull it all together.
upvoted 0 times
...
Winfred
9 months ago
Hmm, I'm a bit unsure about this one. Do we need to do a File Transfer before the Import Activity? I remember something about that from the training, but I can't quite recall the details.
upvoted 0 times
...
Steffanie
10 months ago
I think the key here is to use the Import Activity to bring the Not Sent extract into a data extension. The steps seem pretty straightforward - Tracking Extract, then Import Activity, and finally a SQL Activity to leverage the data.
upvoted 0 times
...
Nickie
1 year ago
Option B is the way to go, hands down. It's like the Swiss Army knife of marketing automation - does everything you need, without all the extra fluff.
upvoted 0 times
Marica
1 year ago
Does everything you need, without all the extra fluff.
upvoted 0 times
...
Deandrea
1 year ago
It's like the Swiss Army knife of marketing automation.
upvoted 0 times
...
William
1 year ago
Option B is the way to go, hands down.
upvoted 0 times
...
...
Sarina
1 year ago
Ah, the age-old question: Tracking Extract, File Transfer, or Import Activity? It's like choosing between chocolate, vanilla, and 'I have no idea what I'm doing.'
upvoted 0 times
Dulce
1 year ago
I usually go with option B for importing the Not Sent extract into a data extension.
upvoted 0 times
...
Flo
1 year ago
C) Tracking Extract > File Transfer > Import Activity
upvoted 0 times
...
Rosendo
1 year ago
B) Tracking Extract > Import Activity > Data Extension Extract
upvoted 0 times
...
Tamie
1 year ago
A) Tracking Extract > Import Activity > SQL Activity
upvoted 0 times
...
...
Elza
1 year ago
I'm sorry, but Option C is just too much work. I'd rather just send the Not Sent extract via carrier pigeon and call it a day.
upvoted 0 times
...
Erin
1 year ago
Option B sounds like the way to go. I mean, who doesn't love a good Data Extension Extract? It's like the guacamole of marketing automation.
upvoted 0 times
Leatha
1 year ago
Yeah, I agree. Data Extension Extract is definitely the way to go for importing the Not Sent extract. It's like the secret sauce for exclusion audiences.
upvoted 0 times
...
Wilda
1 year ago
Option B sounds like the way to go. I mean, who doesn't love a good Data Extension Extract? It's like the guacamole of marketing automation.
upvoted 0 times
...
...
Lauran
1 year ago
A Tracking Extract followed by an Import Activity and a SQL Activity? That's like trying to build a house with a hammer, a screwdriver, and a rolling pin.
upvoted 0 times
...
Lawanda
1 year ago
I think option C) Tracking Extract > File Transfer > Import Activity makes more sense because we need to transfer the file before importing it into the data extension.
upvoted 0 times
...
Lera
1 year ago
I disagree, I believe the correct steps are B) Tracking Extract > Import Activity > Data Extension Extract.
upvoted 0 times
...
Dorcas
1 year ago
I think the correct steps are A) Tracking Extract > Import Activity > SQL Activity.
upvoted 0 times
...

Save Cancel