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
Latest Marketing Cloud Developer Dumps Valid Version with 141 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
Subscribe
Login
0 Comments
Inline Feedbacks
View all comments