Free Practice Questions for Salesforce MCE-Dev-201 Exam

The Contact Delete process in Marketing Cloud removes contact data from the contact model but does not remove records from the data extensions themselves.

Contact Delete Process: When you perform a Contact Delete in Contact Builder, it removes the contact data from the contact model but leaves the actual rows in the data extensions intact.

Salesforce Contact Deletion Process

The IIF function in AMPscript is a shorthand way to perform conditional logic within an inline expression. It evaluates a condition and returns one of two values based on whether the condition is true or false.

AMPscript IIF Example:

%%=IIF(@level = 'premier', 'You are a premier member!', 'Upgrade to premier now!')=%%

Salesforce AMPscript IIF Function

To retrieve multiple records associated with a particular customer from the OrderDetails data extension, the LookupRows and LookupOrderedRows functions are suitable. These functions return a rowset containing the records that match the specified criteria.

LookupRows: Retrieves a rowset of records based on specified criteria.

Example:

ampscript

Copy code

SET @rows = LookupRows('OrderDetails', 'CustomerID', @customerID)

LookupOrderedRows: Retrieves a rowset of records based on specified criteria and allows for sorting.

Example:

SET @rows = LookupOrderedRows('OrderDetails', 0, 'OrderDate DESC', 'CustomerID', @customerID)

Salesforce AMPscript LookupRows

To optimize a SQL Query Activity in Automation Studio that is experiencing timeouts, the developer should use intermediate tables to break queries into smaller parts (B). This approach helps in managing complex queries by breaking them down into smaller, more manageable steps, thus reducing the likelihood of timeouts.

To ensure that emails are not sent to a competitor, the best practices are:

Suppression List: Create a Suppression List that includes all possible email addresses from Rainbow Run. This list will prevent these email addresses from receiving emails.

Exclusion Script: Create an Exclusion Script that checks the domain of the email address and excludes addresses from Rainbow Run.

Salesforce Suppression Lists

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

When working with a REST API that returns data in JavaScript Object Notation (JSON) and needing to efficiently ingest the data and write it to a data extension, the developer should use the Server-Side JavaScript function ParseJSON. This function parses a JSON string and converts it into a JavaScript object, which can then be manipulated and written to a data extension.

To retrieve tracking data for all sends associated with a specific JobID, including Sends, Opens, Clicks, and Bounces, the developer can use the following activities:

Tracking Extract Activity (A) - This activity extracts tracking data such as sends, opens, clicks, and bounces into a file, which can then be used for reporting or further processing.

SQL Query Activity (D) - This activity can query the data views to gather tracking data directly from the Salesforce Marketing Cloud databases. The developer can write SQL queries to select specific tracking information based on the JobID.