Salesforce Certified Marketing Cloud Developer — Question 3

A developer needs to identify all subscribers who were sent Job ID 420 but did not click any links.
Which SQL statement would produce the desired results?

Answer options

• A. SELECT s.SubscriberKey - FROM _Sent s - JOIN _Click c ON s.SubscriberKey = c.SubscriberKey AND s.JobID = c.JobID WHERE s.JobID = 420
• B. SELECT s.SubscriberKey - FROM _Sent s - LEFT JOIN _Click c ON s.SubscriberKey = c.SubscriberKey AND s.JobID = c.JobID WHERE s.JobID = 420
• C. SELECT s.SubscriberKey - FROM _Sent s - LEFT JOIN _Click c ON s.SubscriberKey = c.SubscriberKey AND s.JobID = c.JobID WHERE s.JobID = 420 AND c.SubscriberKey IS NULL

Correct answer: B

Explanation

Option B is correct because it uses a LEFT JOIN to include all subscribers from the _Sent table and will return those who did not have a corresponding entry in the _Click table, indicating they did not click any links. Option A uses an INNER JOIN, which would exclude those who did not click, and Option C adds an unnecessary condition that filters out all clicked subscribers instead of just identifying non-clickers.