Marketing-Cloud-Developer: Salesforce Certified Marketing Cloud Developer (SP20) Extension Practice Questions

A data extension contains two fields which are being populated by a query activity. A third field has recently been added to the data extension. Which SELECT statement is optimal for returning all of the columns in the data extension?

• AA. SELECT field*
• BB. SELECT *, field1, field2, field3
• CC. SELECT*
• DD. SELECT 22SE, field2, field3

A developer created a landing page in CloudPages which return unique content when subscriber data is located on a related data extension. The developer does not know if all subscribers have rows in the related data extension, and want default content to render if no subscriber data is found on the related data extension. Which best practice should the developer follow to control the unique and default content?

• AA. Use the RowCount function and an IF statement
• BB. Use the Lookup, Row and Field functions
• CC. Use the LookupOrderRows and Row functions
• DD. Use the DataExtensionRowCount function

A new record is appended to the Orders data extension each time a customer makes a purchase. Which SQL statement would select a unique list of subscribers who have made multiple purchases?

• AA. SELECT TOP 1 SubscriberKey FROM Orders
• BB. SELECT DISTINCT SubscriberKey FROM Orders
• CC. SELECT SubscriberKey FROM Orders GROUP BY SubscriberKey
• DD. SELECT SubscriberKey FROM Orders GROUP BY SubscriberKey HAVING COUNT(*)>1

A developer wants to programmatically inject Contacts into a journey via REST API. What is the recommended route using POST data extension fields and values?

• AA. /interaction/v1/interactions
• BB. /interaction/v1/events
• CC. /interaction/v1/eventDefinitions
• DD. /contacts/v1/contactEvents