Salesforce MCE-Dev-201 Exam Prep
Salesforce Certified Marketing Cloud Engagement Developer (Page 4 )

Updated On: 27-Sep-2026

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

  1. %%SendBoo1%%
  2. %%SendBoo1 < 1
  3. %%=Lookup ('Excluded' , SendBoo1'. Subscribekey'. _Subscribekey) =%%
  4. %%=Lookup ('Excluded’ , SendBoo1'. _Subscribekey'. _Subscribekey) =%%

Answer(s): B,C

Explanation:

To write an Exclusion Script to exclude sending an email at send time when comparing against a Boolean field in the Sendable Data Extension, the developer can use:
%%SendBoo1 < 1 (B) - This script directly checks if the Boolean field SendBoo1 is less than 1, effectively excluding records where the field is false.
%%=Lookup('Excluded', 'SendBoo1', 'Subscribekey', _Subscribekey) == false (C) - This script performs a lookup to check the value of SendBoo1 in the 'Excluded' data extension, comparing it against the Subscribekey. If the value is false, the email is excluded.


Reference:

AMPscript Guide
Salesforce Marketing Cloud Documentation



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

  1. SELECT * FROM _Job J INNER JOIN _Sent S on J.EmailName LIKE 'TEST%'
  2. SELECT * FROM _Job INNER JOIN _Sent on JobID = JobID WHERE EmailName LIKE 'TEST%'
  3. SELECT * FROM_Job J INNER JOIN _Sent S ON.JobID = S.JobID WHERE J.EmailName LIKE 'TEST%'
  4. SELECT * FROM _Job J INNER JOIN _Sent S on J.JobID = JobID = S.JobID WHERE J.EmailName = 'TEST%'

Answer(s): C

Explanation:

To retrieve subscribers who were sent emails with names starting with "TEST, " we need to join the _Job and _Sent system data views on the JobID field and filter by the EmailName field using a LIKE condition.
Join Condition: The correct join condition between _Job and _Sent is ON J.JobID = S.JobID. This ensures that we are linking the job and sent data correctly.
EmailName Filter: We use J.EmailName LIKE 'TEST%' to filter for emails whose names start with "TEST".
SELECT * FROM _Job J INNER JOIN _Sent S ON J.JobID = S.JobID WHERE J.EmailName LIKE 'TEST%'
: Salesforce Marketing Cloud System Data Views



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

  1. Change the Suppression value to a larger value
  2. Manually delete subscribers in All Contacts
  3. Stop current delete process and delete smaller groups
  4. Delete any unnecessary Sendable Data Extensions

Answer(s): C

Explanation:

The Contact Delete process can be slow for a large number of contacts. To expedite this process, the best approach is to stop the current delete process and delete smaller groups of contacts. This allows the system to handle smaller chunks of data more efficiently.
Stop Current Process: Stopping the current large delete process helps avoid system overload and potential timeouts.
Delete in Smaller Groups: By segmenting the contacts into smaller groups and deleting them in batches, the process becomes more manageable and faster.
: Salesforce Contact Deletion Best Practices



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 toretrieve the status of the API call?

  1. Result Object and EmailAddress
  2. Result Object and ConservationID
  3. ResultItem Object and OrderID
  4. ResultItem Object and RequestID

Answer(s): D

Explanation:

To retrieve the status of an asynchronous SOAP API call to the TriggerSend object, you should use the ResultItem object along with the RequestID attribute.
ResultItem Object: This object provides detailed information about the status of each individual request made within the API call.
RequestID Attribute: This unique identifier is used to track and retrieve the status of the specific API request.
: Salesforce SOAP API Developer Guide



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

  1. Substring
  2. BuildRowSetFromString
  3. IndexOf
  4. Length

Answer(s): B

Explanation:

To determine if a specific text string exists in a tab-delimited list of values, the BuildRowSetFromString AMPscript function is the most appropriate. This function splits the string into a rowset, making it easier to search for the specific text.
BuildRowSetFromString Function: This function converts a delimited string into a rowset, which can then be iterated over or searched using other AMPscript functions.
SET @values = "val1\tval2\tval3" SET @rowset = BuildRowSetFromString(@values, "\t") SET @rowCount = RowCount(@rowset) SET @found = "false" FOR @i = 1 TO @rowCount DO SET @row = Row(@rowset, @i) SET @value = Field(@row, 1) IF @value == "specificText" THEN SET @found = "true" /* exit the loop if found */ BREAK ENDIF NEXT @i
: Salesforce AMPscript Function Reference



Viewing page 4 of 41
Viewing questions 16 - 20 out of 196 questions


Post your Comments and Discuss Salesforce MCE-Dev-201 exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!