Exam Certified Marketing Cloud Developer topic 1 question 6 discussion

Actual exam question from Salesforce's Certified Marketing Cloud Developer

Question #: 6
Topic #: 1

[All Certified Marketing Cloud Developer Questions]

A developer needs to find all subscribers on the Customers data extension who made a purchase in the last 30 days. Purchase data is on the Orders data extension which contains a column called 'PurchaseDate'. Contacts are identified in both data extensions by a column called 'ContactKey', and the Orders data extension can contain many instances of the same subscriber.
Which SQL keyword should the developer use to achieve the desired result?

A. OUTER JOIN
B. INNER JOIN
C. ORDER BY PurchaseDate ASC

Show Suggested Answer

Suggested Answer: C 🗳️

by lugiricy at April 4, 2025, 3:37 p.m.

Comments

Submit Cancel

SG87_S

1 week, 5 days ago

Selected Answer: B

GPT explanation: Why INNER JOIN is correct: An INNER JOIN between Customers and Orders on ContactKey will return only those customers who have matching records in Orders. You then apply a WHERE clause to filter by PurchaseDate. C. ORDER BY PurchaseDate ASC → This only sorts the result; it doesn’t help with filtering the data based on logic. It’s irrelevant to the requirement.

upvoted 1 times

...