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?

ASELECT * FROM _Job J INNER JOIN _Sent S on J.EmailName LIKE 'TEST%'

BSELECT * FROM _Job INNER JOIN _Sent on JobID = JobID WHERE EmailName LIKE 'TEST%'

CSELECT * FROM _Job J INNER JOIN _Sent S ON.JobID = S.JobID WHERE J.EmailName LIKE 'TEST%'

DSELECT * FROM _Job J INNER JOIN _Sent S on J.JobID = JobID = S.JobID WHERE J.EmailName = 'TEST%'

Show Suggested Answer

Suggested Answer: A

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

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

5 hours 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

...

1 days 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

...

13 days 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

...

23 days ago

Why do you think option C is correct?

upvoted 0 times

...

24 days ago

I disagree, I believe option C is the right one.

upvoted 0 times

...

27 days ago

I think the correct query is option A.

upvoted 0 times

...