marketing-cloud-developer question 136 discussion

View all Certified Marketing Cloud Developer here
back to salesforce forum

Question 136

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


User Votes:
A
50%
B
50%
C 1 votes
50%
D
50%
Discussions
0 / 1000
carloscuartasm
1 year, 8 months ago

C. SELECT c.SubscriberKey, MAX(c.eventDate) AS eventDate FROM _Click c GROUP BY c.SubscriberKey

0