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 MCE-Dev-201 Exam - Topic 3 Question 2 Discussion

A customer wants a list of subscribers who were sent an email within the past 12 months.How shouldthis request be completed?
C) Query against the Job and Sent data views
A) Create a measure with criteria sent_date is after today minus 565 days
B) Run a tracking extract via the SOAP API
D) Locate the email sends in the Tracking tab within Email Studio

Salesforce MCE-Dev-201 Exam - Topic 3 Question 2 Discussion

Actual exam question for Salesforce's MCE-Dev-201 exam
Question #: 2
Topic #: 3
[All MCE-Dev-201 Questions]

A customer wants a list of subscribers who were sent an email within the past 12 months.

How shouldthis request be completed?

Show Suggested Answer Hide Answer
Suggested Answer: C

To get a list of subscribers who were sent an email within the past 12 months, you should query the Job and Sent data views. These data views contain detailed information about email sends and can be used to filter subscribers based on the send date.

SQL Query Example:

SELECT s.SubscriberKey FROM _Sent s JOIN _Job j ON s.JobID = j.JobID WHERE j.SendDate >= DATEADD(month, -12, GETDATE())

: Salesforce Data Views


by Elenore at Dec 22, 2025, 04:16 PM

Limited Time Offer

25%

Off

Get Premium MCE-Dev-201 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Rene
24 days ago
D is too manual for large lists.
upvoted 0 times
...
Xochitl
29 days ago
A seems too complicated.
upvoted 0 times
...
Winfred
1 month ago
I prefer B. SOAP API is efficient.
upvoted 0 times
...
Nickole
1 month ago
It directly queries the data views.
upvoted 0 times
...
Latricia
2 months ago
Why C?
upvoted 0 times
...
Nickole
2 months ago
I think option C is the best.
upvoted 0 times
...
Jina
2 months ago
Isn't there a simpler way to get this info?
upvoted 0 times
...
Dorathy
2 months ago
Definitely agree with C, it's straightforward!
upvoted 0 times
...
Hana
2 months ago
Wait, why would you use 565 days? That seems off.
upvoted 0 times
...
Elmira
2 months ago
I think D could work too, but it's not as efficient.
upvoted 0 times
...
Marvel
3 months ago
Option C is the best choice for this.
upvoted 0 times
...
Eden
3 months ago
D) Tracking tab, all the way! Less work, more results.
upvoted 0 times
...
Mirta
3 months ago
Hmm, I'd go with C. Who wants to deal with SOAP APIs these days?
upvoted 0 times
...
Ryann
4 months ago
A) Creating a measure with the criteria is a bit convoluted, don't you think?
upvoted 0 times
...
Tequila
4 months ago
D) Locating the email sends in the Tracking tab is the easiest way to get this done.
upvoted 0 times
...
Lashon
4 months ago
B) Running a tracking extract via the SOAP API would give me the most detailed information.
upvoted 0 times
...
Kirk
4 months ago
Running a tracking extract via the SOAP API seems like a valid approach, but I feel like it might be more complex than necessary.
upvoted 0 times
...
Louvenia
4 months ago
I remember we discussed using the Tracking tab in Email Studio, but I can't recall if it gives a complete list like this.
upvoted 0 times
...
Josephine
4 months ago
I'm leaning towards option C as well. Querying the data views feels like the most reliable and efficient approach for this type of request.
upvoted 0 times
...
Reyes
5 months ago
The Tracking tab in Email Studio could work, but I'm not sure how scalable that would be for a large subscriber base. I think the database query route is the way to go here.
upvoted 0 times
...
Haley
5 months ago
Option A with the measure calculation seems a bit convoluted. I'd probably try to avoid that if possible and stick to a more direct database query.
upvoted 0 times
...
Clarinda
5 months ago
Hmm, I'm not sure about this one. I'd have to double-check the documentation to see if the SOAP API option is viable. Might be worth exploring that as well.
upvoted 0 times
...
Elizabeth
5 months ago
I think I'd go with option C. Querying the Job and Sent data views seems like the most straightforward way to get the subscriber list.
upvoted 0 times
...
Raul
5 months ago
I'm not sure about the exact days, but isn't 565 days a bit too much for just 12 months?
upvoted 0 times
...
Cyndy
6 months ago
C) Query against the Job and Sent data views seems like the most straightforward approach.
upvoted 0 times
...
Samira
6 months ago
I think option C sounds familiar, like something we practiced with SQL queries in class.
upvoted 0 times
...

Save Cancel