Salesforce Certified Marketing Cloud Developer - Certified Marketing Cloud Developer Exam
Page: 2 / 13
Total 65 questions
Question #6 (Topic: Exam A)
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?
Which SQL keyword should the developer use to achieve the desired result?
A. OUTER JOIN
B. INNER JOIN
C. ORDER BY PurchaseDate ASC
Answer: C
Question #7 (Topic: Exam A)
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?
Which SQL function should be used to collect a representative sample from a larger data set?
A. OVER
B. NTILE
C. HAVING
Answer: A
Question #8 (Topic: Exam A)
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?
Which method could be used to support the dynamic functionality?
A. Configure
B. Extract
C. Describe
Answer: B
Question #9 (Topic: Exam A)
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?
Which object is required to successfully create a TriggeredSend object?
A. TriggeredSendDefinition
B. Attribute
C. Contact
Answer: B
Question #10 (Topic: Exam A)
A particular data extension needs to be configured to store six months of data.
How should data retention be added to the data extension?
How should data retention be added to the data extension?
A. Update the data extension configuration.
B. Import a file to overwrite the rows with six months of data.
C. Run a query to overwrite the rows with six months of data.
Answer: A
