Question 6 of 130
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?
Correct Answer: C

Question 7 of 130
A developer built a complex dynamic email with many data variants. Rather than create test data manually, they want to use a subset of live data to validate the dynamic aspects of the email.
Which SQL function should be used to collect a representative sample from a larger data set?
Correct Answer: A

Question 8 of 130
A developer is leveraging the SOAP API to dynamically display Profile and Preference Attributes in a custom profile center.
Which method could be used to support the dynamic functionality?
Correct Answer: B

Question 9 of 130
Northern Trail Outfitters is using a mobile campaign to collect email addresses of interested subscribers. Using AMPscript's API functions they will send a confirmation email when an email is texted into their short code.
Which object is required to successfully create a TriggeredSend object?
Correct Answer: B

Question 10 of 130
A particular data extension needs to be configured to store six months of data.
How should data retention be added to the data extension?
Correct Answer: A