Free Salesforce MCE-Dev-201 Practice Exam with Questions & Answers | Set: 3

To configure a File Drop Automation with a filename pattern that allows for timestamps and starts with the month and day, the developer should use:

Begins With operator (D) - This ensures that the automation triggers when the file name begins with the specified pattern.

%%Month%%%%Day%% (C) - This is the correct syntax to match the month and day in the file name. For example, if the file name is "MAY15", the pattern will be %%MMMM%%dd.

To find all subscribers who made a purchase in the last 30 days, an INNER JOIN should be used to join the Customers data extension with the Orders data extension on the ContactKey. This ensures that only subscribers with matching records in both data extensions are retrieved.

SQL Query Example:

SELECT c.ContactKey FROM Customers c INNER JOIN Orders o ON c.ContactKey = o.ContactKey WHERE o.PurchaseDate >= DATEADD(day, -30, GETDATE())

Salesforce SQL JOINs

To transform the date and time 'Data_Enrolled' from Daylight Savings time and fall back one hour, the developer should use the following AMPscript function:

%%=DateAdd(Data_Enrolled, -1, 'H')=%%

This function subtracts one hour from the 'Data_Enrolled' date and time.

To inject contacts into a journey using the REST API, the correct endpoints involve the event definitions and events.

POST /eventDefinitions/key:{key} or /eventDefinitions/{id}: This endpoint allows you to interact with event definitions by key or ID, which is essential for managing journey events.

POST /interaction/v1/events: This endpoint is used to inject events into the journey, thus adding contacts to the journey based on the defined event.

Salesforce Journey Builder API

To remove line breaks within the Comments field and replace them with a single space, you can use the REPLACE function in combination with the CHAR function. The CHAR(13) and CHAR(10) functions represent carriage return and line feed characters, respectively.

REPLACE Function: This function is used to replace occurrences of a specified string with another string.

CHAR Function: This function returns the character based on the ASCII code provided.

Example:

SELECT REPLACE(REPLACE(Comments, CHAR(13), ' '), CHAR(10), ' ') AS Comments FROM YourDataExtension

Salesforce SQL Reference

When a send is initiated directly to a Sendable Data Extension that includes records targeted for deletion, the following behaviors are expected:

Records still in the suppression phase will be excluded from sends (B) - These records are in the process of being deleted and will not be included in the send.

Records that have been deleted will be excluded from sends indefinitely (D) - Once records are deleted, they are permanently excluded from future sends.

To ensure the MobileConnect Contact is tied to the Email Contact when making a QueueMO call for an existing email subscriber, the parameter to include is emailaddress. This ensures that the MobileConnect Contact is correctly linked to the existing Email Contact.

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 "401 Unauthorized" error typically indicates an issue with authentication or permissions. Since the Client ID and Client Secret have been successfully used in other REST calls, the most likely cause is insufficient permissions for sending emails.

Check Send Permissions: Ensure that the appropriate permissions for sending emails have been granted to the Client ID and Client Secret in the Installed Packages. Without these permissions, the API call will fail with a 401 error.

Salesforce Installed Packages and Permissions