Certified Marketing Cloud DeveloperDemo

Question

A developer is writing a query to select distinct subscribers who opened any emails sent since the start of the previous day.

Which query would return that result?

A SELECT DISTINCT o.SubscriberKey -FROM _Open o -INNER JOIN _Job j ON j.JobID = o.JobIDWHERE j.PickupTime >= CONVERT(date, GETDATE()-1))
B SELECT DISTINCT o.SubscriberKey -FROM _Open o -INNER JOIN _Job j ON j.JobID = o.JobIDWHERE o.SendDate >= CONVERT(date, GETDATE()-1))
C SELECT DISTINCT o.SubscriberKey -FROM _Open o -WHERE o.OpenDate >= CONVERT(date, GETDATE()-1))

Explanation

_Open supplies the subscribers associated with open events, and joining it to _Job by JobID allows the query to filter on the job’s PickupTime, which represents the relevant email-send timing. Applying DISTINCT to SubscriberKey returns each qualifying subscriber only once.

Certified Marketing Cloud DeveloperDemo

AstroTutor

Notes

Readiness

QuestionQ73

Community Discussion