Certified Marketing Cloud Developer

Certified Marketing Cloud Developer practice questions, page 2 of 6, with answer review and explanations.

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?

  1. OUTER JOIN
  2. INNER JOIN
  3. ORDER BY PurchaseDate ASC

Question 7

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?

  1. OVER
  2. NTILE
  3. HAVING

Question 8

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?

  1. Configure
  2. Extract
  3. Describe

Question 9

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?

  1. TriggeredSendDefinition
  2. Attribute
  3. Contact

Question 10

A particular data extension needs to be configured to store six months of data. How should data retention be added to the data extension?

  1. Update the data extension configuration.
  2. Import a file to overwrite the rows with six months of data.
  3. Run a query to overwrite the rows with six months of data.