Exam4Training

Which query would accomplish this?

A developer wants to populate a data extension with the date of the most recent click for each subscriber.

Which query would accomplish this?
A . SELECT TOP 1 c.SubscriberKey, c.eventDate FROM _Click c ORDER BY c.eventDate DESC
B. SELECT c.SubscriberKey, MIN (c.eventDate) AS eventDate FROM _Click c GROUP BY c.SubscriberKey
C. SELECT c.SubscriberKey, MAX(c.eventDate) AS eventDate FROM _Click c GROUP BY c.SubscriberKey
D. SELECT c.SubscriberKey, c.eventDate FROM _Click c WHERE c.IsUnique = 1

Answer: C

Exit mobile version