Salesforce Certified Marketing Cloud Engagement Developer Free Sample Questions

Programmatic Languages · SSJS and AMPscript for Performance

1. A

   Use an SSJS Script Activity to iterate through Customers, perform lookups to Accounts and Transactions, build a JSON string for each customer, and upsert it into a staging DE. Then, in the email, use AMPscript's Lookup and BuildRowsetFromJSON to parse and display the data.

2. B

   In the email, use a single, complex AMPscript block with nested LookupRows and FOR loops to gather all data in real-time. Use RaiseError for customers with excessive data to prevent timeouts.

3. C

   Use an SSJS Script Activity to perform all lookups and build the final HTML table for each subscriber, storing the complete HTML block in a staging DE. In the email, use a simple AMPscript Lookup to retrieve the pre-rendered HTML.

4. D

   Use a SQL Query Activity to join the three data extensions and aggregate the data, but use FOR XML PATH to generate an XML string for each customer. In the email, use AMPscript's BuildRowsetFromXML to parse and render the data.

API · SOAP vs REST API for Transactional Sends

1. A

   SOAP API, because it provides more robust error handling and guaranteed delivery for transactional sends.

2. B

   REST API's Transactional Messaging endpoint, because it is optimized for high-throughput, personalized, non-promotional sends and bypasses the standard marketing send queue.

3. C

   SOAP API, because it allows for more complex data structures to be passed in the Subscribers array, which is necessary for the order line items.

4. D

   REST API's Journey API (/interaction/v1/events), as it allows the customer to be injected into an Order Confirmation journey for better tracking.

Data Management · SQL Query Optimization

SELECT
s.StudentID,
s.GPA,
s.Major
FROM
Student_Master s
INNER JOIN
Course_Enrollment c ON s.StudentID = c.StudentID
WHERE
s.GPA > 3.5 AND c.CourseCode LIKE 'CS%'

1. A

   Add WITH (NOLOCK) to both table references to reduce read locks.

2. B

   Create a Sendable Data Extension as the target and ensure StudentID is the Subscriber Key.

3. C

   Add an index to the GPA column in the Student_Master DE and the CourseCode column in the Course_Enrollment DE.

4. D

   Break the query into two separate activities: first, select students with GPA > 3.5 into a staging DE, then join that staging DE with Course_Enrollment.

Data Modeling · Contact Delete Process

1. A

   True

2. B

   False

Programmatic Languages · AMPscript for CloudPages

1. A

   LookupRows()

2. B

   RequestParameter()

3. C

   UpdateData()

4. D

   RaiseError()

5. E

   Redirect()

Security · Secure CloudPage Development

1. A

   On page load, retrieve OrderID and SubscriberKey from the URL. Perform a LookupRows() on Orders_DE using both OrderID and CustomerID (where CustomerID matches the passed SubscriberKey). If a match is found, display the OrderDetails.

2. B

   Encrypt the OrderID and SubscriberKey together into a single token before generating the email link. On the CloudPage, decrypt the token, validate the parameters, and then look up the order. Use the TreatAsContent() function to display all retrieved data.

3. C

   On page load, retrieve OrderID and SubscriberKey from the URL. Perform a LookupRows() using only the OrderID. Then, in a separate step, compare the CustomerID from the result with the SubscriberKey from the URL. If they match, display the data wrapped in the AttributeValue() function for XSS protection.

4. D

   On page load, retrieve OrderID and SubscriberKey from the URL. Perform a LookupRows() on Orders_DE using both OrderID and CustomerID (where CustomerID matches the passed SubscriberKey). If a match is found, use the AttributeValue() function on each data field before displaying it to prevent XSS.

Programmatic Languages · Programmatic Exclusions

1. A

   Skip()

2. B

   Exit()

3. C

   RaiseError()

4. D

   Abort()

Data Modeling · Shared Data Extensions

1. A

   Create the data extension in the parent BU, mark it as 'Shared,' and place it in a shared folder with permissions granted to all child BUs.

2. B

   Create the data extension in each child BU and use a daily SQL query automation to synchronize them with a master list in the parent BU.

3. C

   Create a standard data extension in the parent BU and use the API to query it from each child BU during the send process.

4. D

   Utilize the out-of-the-box All Subscribers list at the Enterprise (parent) level, as it automatically handles global unsubscribes.

API · REST API Bulk Operations

1. A

   Implement an exponential backoff strategy for retrying failed requests.

2. B

   Switch to the SOAP API, as its UpdateBatch method is better suited for bulk operations.

3. C

   Utilize the REST API's asynchronous processing mode by including the async=true query parameter in the requests.

4. D

   Use the REST API's batch endpoint (/asset/v1/content/assets/batch) to create or update up to 25 assets in a single request.

Programmatic Languages · AMPscript Conditional Logic

1. A

   Hi %%=v(IF(@FirstName != "" THEN @FirstName ELSE "Valued Customer" ENDIF))=%%

2. B

   Hi %%=IIF(Empty(AttributeValue("FirstName")), "Valued Customer", AttributeValue("FirstName"))=%%

3. C

   Hi %%=Lookup("Subscribers", "FirstName", "SubscriberKey", _subscriberkey)=%%

4. D

   Hi %%=Iif(Not IsNull(FirstName), FirstName, "Valued Customer")=%%