MARKETING-CLOUD-DEVELOPER practice question 2 of 10

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?

Full set: 196 questions
Answer options
A: SELECT * FROM _Job J INNER JOIN _Sent S on J.EmailName LIKE 'TEST%'
B: SELECT * FROM _Job INNER JOIN _Sent on JobID = JobID WHERE EmailName LIKE 'TEST%'
C: SELECT * FROM _Job J INNER JOIN _Sent S ON.JobID = S.JobID WHERE J.EmailName LIKE 'TEST%' Correct answer
D: SELECT * FROM _Job J INNER JOIN _Sent S on J.JobID = JobID = S.JobID WHERE J.EmailName = 'TEST%'
Correct Answer:
C. SELECT * FROM _Job J INNER JOIN _Sent S ON.JobID = S.JobID WHERE J.EmailName LIKE 'TEST%'
Explanation

The correct query to retrieve subscribers who were sent emails with names starting with 'TEST' correctly joins the Job and Sent data extensions on JobID and uses a WHERE clause to filter EmailName using the LIKE operator.

Why Incorrect

A. The join condition is incorrect; it uses LIKE improperly in the JOIN rather than in a WHERE clause.
B. This option lacks the necessary alias and uses an incorrect join condition syntax.
D. The join condition has a syntax error with improper use of equals sign (=).

References

1. Salesforce Marketing Cloud Documentation, Query Activities: Link

2. Marketing Cloud Developer Guide, SQL Reference: Link

Scroll to Top