Salesforce Certified Marketing Cloud Developer (SP25) Marketing-Cloud-Developer Question # 33 Topic 4 Discussion

Salesforce Certified Marketing Cloud Developer (SP25) Marketing-Cloud-Developer Question # 33 Topic 4 Discussion

Marketing-Cloud-Developer Exam Topic 4 Question 33 Discussion:
Question #: 33
Topic #: 4

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 columncalled '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 subscnber.

Which SQL keyword should the developer use to achieve the desired result?


A.

INNER JOIN


B.

OUTER JOIN


C.

ORDER BY PurchaseDate ASC


Get Premium Marketing-Cloud-Developer Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.