Practice Free Salesforce Certified Marketing Cloud Engagement Developer Exam Online Questions
New subscribers at Northern Trail Outfitters (NTO) are added to a data extension. NTO would like to send these subscribers a welcome series with Journey Builder.
What would allow the data extension to be selected for journey entry’
- A . At least one Campaign must be associated to the data extension.
- B . The Triggered Send Template must be used to create the data extension.
- C . The data extension must be configured for sending.
- D . The data extension must contain a field of the EmailAddress data type.
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?
- A . SELECT TOP 1 SubscriberKey FROM Orders
- B . SELECT DISTINCT SubscriberKey FROM Orders
- C . SELECT SubscriberKey FROM Orders GROUP BY SubscriberKey
- D . SELECT SubscriberKey FROM Orders GROUP BY SubscriberKey HAVING COUNT(*)>1
A company has chosen to use the REST API for triggered sends, but they continue to get the following error during their testing: "Unable to queue Triggered Send request. There are no valid subscribers." They were informed that the SOAP API provides more information about the error, and found that their payload did not include a required data extension field.
Which element of the SOAP API response provides this level of detail?
- A . ErrorDescription
- B . OverallStatus
- C . ErrorCode
A developer is managing the data model programmatically and needs to access Attribute Group schema via the API.
Which API should the developer use?
- A . Bulk
- B . SOAP
- C . XML
- D . REST
A developer receives a request for tracking data for alt sends associated with a specific JoblD. The developer needs to see Sends, Opens, Clicks, and Bounces.
Which two activities could the developer use? Choose 2 answers
- A . Tracking Extract Activity
- B . Server-Side JavaScript Activity
- C . Campaign Data Extract
- D . SQL Query Activity
A developer uses the messageDefinitionSends REST API endpoint to send a triggered send email. This method returns a 202 (success) response code.
How could the developer validate if the email was successfully sent?
- A . Use the messageDefinitionSend/key:(key)/deliveryRecords REST endpoint with GET method
- B . The 202 response code indicates the message was sent successfully; no further action is required.
- C . Use the validateEmail REST resource with POST method to obtain the email delivery details from the request.
- D . Confirm the record was successfully inserted into the associated Triggered Send Data Extension.
A developer needs to import a file nightly that will be used for multiple SQL Query Activities. The file could arrive any time between 2 a.m. and 5 a.m., and one of the requirements is that there is a unique file name for each import, rather than overwriting the file on the FTP site.
Which action should be configured?
- A . File Drop Automation
- B . Scheduled Automation
- C . Dynamic File Import
NTO uses data extensions to manage the subscriber information used for their email sends, and those sends includes calls to update records with new or different subscriber information. The developer handling these records writes some AMPscript to check and see if the data extension containing those records updated using an InsertDE() call if the record doesn’t yet exist.
Why would the developer receive an error stating the application cannot insert a duplicate value for the primary key in the data extension?
- A . The InsertDE function will always insert two rows into a data extension as part of the call
- B . The InsertDE function cannot be used with name and value pairs
- C . The InsertDE function comes after the system added the row as part of the email send
- D . The InsertDE function cannot be used at send time
NTO wants to exclude sending an email at send time to those with a record on the ‘Exclude’ Data Extension. The primary key on this data extension is Subscriber Key.
How would a developer write the Exclusion Script?
- A . Lookup (‘Exclude’,’EmailAddress’,’SubscriberKey’,SubscriberKey)
- B . Lookup (‘Exclude’,’SubscriberKey’, ‘EmailAddress’, emailddr_)
- C . Rowcount (LookupRows(‘Exclude’,SubsciberKey,_SubscriberKey) >0
- D . Rowcount (LookupRows(‘Exclude’,’SubscriberKey,_SubscriberKey) >1
A developer wants CloudPages to work with a REST API returning data in JavaScript Object Notation. The developer wants to efficiently ingest the data and write it to a data extension.
Which function should be used?
- A . Server-Side 3avaScript function Stringify
- B . Server-Side JavaScript function ParseJSON
- C . AMPscript function BuildRowsetFromXML
- D . AMPscript function BuildRowsetFromString