Salesforce Certified Marketing Cloud Developer — Question 6

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?

Answer options

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

Correct answer: C

Explanation

The correct answer is C because the developer needs to order the results by the purchase date to identify those within the last 30 days. Options A and B refer to types of joins, which are not necessary for simply ordering the results based on a specific column.