Salesforce Exam Marketing Cloud Developer Topic 9 Question 24 Discussion

Actual exam question for Salesforce's Marketing Cloud Developer exam

Question #: 24
Topic #: 9

A developer wants to populate a data extension with the date of the most recent click for each subscriber. Which query would accomplish this?

ASELECT TOP 1 c.SubscriberKey, c.eventDate FROM _Click c ORDER BY c.eventDate DESC

BSELECT c.SubscriberKey, MIN (c.eventDate) AS eventDate FROM _Click c GROUP BY c.SubscriberKey

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

DSELECT c.SubscriberKey, c.eventDate FROM _Click c WHERE c.IsUnique = 1

Show Suggested Answer

Suggested Answer: C

by Twana at May 04, 2022, 07:04 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!