Salesforce marketing cloud developer practice test

From which business unit could the Contact Delete feature be used within an Enterprise 2.0 account?

• A. Any business unit
• B. The Parent account
• C. Only in Agency accounts
• D. The business unit where the contact was introduced

Which two ways would a developer write an Exclusion Script to exclude sending an email at send
time when comparing against a Boolean field in the Sendable Data Extension?
Choose 2 answers

• A. %%SendBoo1%%
• B. %%SendBoo1 < 1
• C. %%=Lookup ('Excluded' , SendBoo1'. Subscribekey'. _Subscribekey) =%%
• D. %%=Lookup ('Excluded’ , SendBoo1'. _Subscribekey'. _Subscribekey) =%%

NTO puts the word TEST at the beginning of the name for each test email. Which query would return
the subs who were sent those emails?

• A. SELECT * FROM _Job J INNER JOIN _Sent S on J.EmailName LIKE 'TEST%'
• B. SELECT * FROM _Job INNER JOIN _Sent on JobID = JobID WHERE EmailName LIKE 'TEST%'
• C. SELECT * FROM _Job J INNER JOIN _Sent S ON.JobID = S.JobID WHERE J.EmailName LIKE 'TEST%'
• D. SELECT * FROM _Job J INNER JOIN _Sent S on J.JobID = JobID = S.JobID WHERE J.EmailName = 'TEST%'

A developer identified duplicate contacts and initiated a Contact Delete process for 10 million
subscribers. How could the process be expedited?

• A. Change the Suppression value to a larger value
• B. Manually delete subscribers in All Contacts
• C. Stop current delete process and delete smaller groups
• D. Delete any unnecessary Sendable Data Extensions

NTO is using an asynchronous SOAP API call to the TriggerSend object to send order confirmation
email to their customers. Which API object and attribute should be used to retrieve the status of the
API call?

• A. Result Object and EmailAddress
• B. Result Object and ConservationID
• C. ResultItem Object and OrderID
• D. ResultItem Object and RequestID

A field value returned from a DE lookup contains a tab-delimited list of values. Which AMPscript
function could easily determine if a specific text string exist anywhere in the list?

• A. Substring
• B. BuildRowSetFromString
• C. IndexOf
• D. Length

A developer want to email a subscriber who is currently being processed for a Contact Deletion
request. When could the Contact be reintroduced after a Contact Delete operation has started?

• A. Never
• B. 14 days after deletion process is complete
• C. After deletion is fully complete
• D. Anytime

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?

• A. /interaction/v1/interactions
• B. /interaction/v1/events
• C. /interaction/v1/eventDefinitions
• D. /contacts/v1/contactEvents

A company need to retrieve a large number of rows from a DE via the API. Which two solutions
would optimize the performance? Choose 2

• A. Use a SimpleFilterPart to retrieve small sets of relevant data.
• B. Use AMPscript API functions on a CloudPage
• C. Use the ContinueRequest feature
• D. Use the REST API instead of the SOAP API

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