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 Exam Marketing Cloud Developer Topic 5 Question 45 Discussion

Actual exam question for Salesforce's Marketing Cloud Developer exam
Question #: 45
Topic #: 5
[All Marketing Cloud Developer Questions]

NTO puts the word TEST at the beginning of the name for each test email. Which query would return the subs who were sent those emails?

Show Suggested Answer Hide Answer
Suggested Answer: A

by Lavera at Jan 06, 2023, 07:23 AM

Limited Time Offer

25%

Off

Get Premium Marketing Cloud Developer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel
Corrinne
1 months ago
I'd go with Option C, but I'm still trying to figure out why they put 'TEST' at the beginning of the email names. Seems like a strange choice to me.
upvoted 0 times
Evangelina
9 days ago
I agree, using 'TEST' at the beginning of email names can help prevent accidentally sending test emails to subscribers.
upvoted 0 times
...
My
12 days ago
Maybe they use 'TEST' to easily identify test emails in the system. It's a common practice in email marketing.
upvoted 0 times
...
Selma
27 days ago
Option C is the correct choice. It joins the _Job and _Sent data on JobID and selects emails starting with 'TEST'.
upvoted 0 times
...
...
Ora
1 months ago
Option C is the way to go! Gotta love those inner joins and LIKE clauses. Easy peasy lemon squeezy!
upvoted 0 times
Merilyn
13 hours ago
B) SELECT * FROM _Job INNER JOIN _Sent on JobID = JobID WHERE EmailName LIKE 'TEST%'
upvoted 0 times
...
Breana
20 days ago
A) SELECT * FROM _Job J INNER JOIN _Sent S on J.EmailName LIKE 'TEST%'
upvoted 0 times
...
Ashton
1 months ago
C) SELECT * FROM _Job J INNER JOIN _Sent S ON.JobID = S.JobID WHERE J.EmailName LIKE 'TEST%'
upvoted 0 times
...
...
Mari
2 months ago
All these options look pretty similar, but I think Option C is the cleanest and most readable. The other options seem a bit convoluted.
upvoted 0 times
...
Velda
2 months ago
I was thinking along the same lines as Emiko. Option C seems like the most straightforward and efficient way to get the desired result.
upvoted 0 times
...
Emiko
2 months ago
Option C looks good to me. It joins the _Job and _Sent tables on the JobID column and then filters for email names starting with 'TEST'.
upvoted 0 times
Kayleigh
1 months ago
Yes, it joins the _Job and _Sent tables on the JobID column and filters for email names starting with 'TEST'.
upvoted 0 times
...
Colette
1 months ago
I think option C is the correct query.
upvoted 0 times
...
...
Shoshana
2 months ago
Why do you think option C is correct?
upvoted 0 times
...
Elliott
2 months ago
I disagree, I believe option C is the right one.
upvoted 0 times
...
Shoshana
2 months ago
I think the correct query is option A.
upvoted 0 times
...

Save Cancel