Salesforce MCE-Dev-201 Salesforce Certified Marketing Cloud Engagement Developer Exam Practice Test

To execute daily reports on all subscriber activity without impacting send performance, the best practice is to copy new Send Log records to an Archive data extension, then run reports from the Archive data extension (C). This approach ensures that the reporting activity does not interfere with the performance of ongoing send operations.

The first step in using the Transactional Messaging API to send emails is to authenticate and obtain an access token. This is done by making a POST request to the /v2/authorize endpoint with the client credentials.

Salesforce Transactional Messaging API Authentication

A developer would use the LookupRows function instead of the Lookup AMPscript function to return a complete rowset from the data extension (A). The LookupRows function retrieves all rows that match a specified criterion, returning a rowset that can be further processed or iterated over in AMPscript. In contrast, the Lookup function retrieves only a single field value from the first row that matches the specified criteria.

To include Server-Side JavaScript (SSJS) in an email message, you need to use the : This is a valid way to include SSJS in an email. It specifies that the enclosed code should be executed on the server.

Salesforce SSJS Documentation

: This is another valid syntax. It specifies that the code within the script tag is JavaScript and should run on the server.

To sum up multiple variables in AMPscript, the Add function should be used. The Add function can be nested to handle multiple values.

Example:

%%[ SET @total = Add(@var1, Add(@var2, @var3)) ]%%

Salesforce AMPscript Add Function

A developer should request a new token once an hour when making multiple API calls in v1. Salesforce Marketing Cloud access tokens are typically valid for one hour, and refreshing them every hour ensures that the API calls are authenticated.

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

When using the REST API to send emails to customers after a purchase, the developer should make a token API call and re-use the token until the token expires (D). This approach optimizes API usage by reducing the number of token requests, ensuring that the token is reused until it naturally expires, after which a new token can be requested.

To get a list of subscribers who were sent an email within the past 12 months, you should query the Job and Sent data views. These data views contain detailed information about email sends and can be used to filter subscribers based on the send date.

SQL Query Example:

SELECT s.SubscriberKey FROM _Sent s JOIN _Job j ON s.JobID = j.JobID WHERE j.SendDate >= DATEADD(month, -12, GETDATE())

Salesforce Data Views

To trigger an email send in Marketing Cloud when a purchase is made on a website, you can use either the REST API or the SOAP API. Both APIs provide methods to send triggered emails.

REST API: The REST API can be used to trigger emails by making a call to the /messaging/v1/messageDefinitionSends/{key}/send endpoint.

SOAP API: The SOAP API can also be used to trigger sends by utilizing the TriggeredSend object.

Salesforce Marketing Cloud REST API

Salesforce Marketing Cloud SOAP API

Data extension functions in AMPscript, such as LookupRows, LookupOrderedRows, and UpdateDE, can most negatively impact send processing because they involve querying and manipulating data extensions. These operations can be resource-intensive and time-consuming, especially when dealing with large data sets.

Salesforce AMPscript Functions

In the provided AMPscript, the IF statement checks the length of the @point variable and sets @value accordingly. Since x = 'Tacos' has a length of 5, it meets the first condition Length(@point) > 1, which sets @value to 1. Subsequent conditions are not evaluated because the first condition is already true.

AMPscript IF-ELSEIF Example:

%%[ SET @point = RequestParameter('x') SET @value = 5 IF Length(@point) > 1 THEN SET @value = 1 ELSEIF Length(@point) > 2 THEN SET @value = 2 ELSEIF Length(@point) > 3 THEN SET @value = 3 ELSEIF Length(@point) > 4 THEN SET @value = 4 ENDIF ]%%

Salesforce AMPscript Documentation

When using the REST Authorization Service to obtain an OAuth access token, the standard method to include this token in subsequent API requests is by adding it to the Authorization header with the Bearer scheme.

Correct Method: Authorization: Bearer YOUR_ACCESS_TOKEN

This format is a standard practice for OAuth 2.0 token usage.

Salesforce Authentication and Access Tokens

Before using the 'contacts/' route of the REST API to update records in a data extension, the developer should verify that the data extension should be linked in an AttributeGroup in Contact Builder (D). This ensures that the data extension is part of the contact model and can be accessed and updated using the REST API.

Profile attributes like AGE in Profile Manager are not directly accessible via the _Subscribers data view or _EnterpriseAttribute data view. To retrieve subscribers over 30 years of age, creating a filtered Group based on the AGE attribute is the most effective method.

Salesforce Subscriber Filters and Groups

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 select a unique list of subscribers who have made multiple purchases, the developer should use the following SQL statement:

SELECT SubscriberKey FROM Orders GROUP BY SubscriberKey HAVING COUNT(*) > 1

This query groups the records by SubscriberKey and selects only those groups where the count of records is greater than one, indicating multiple purchases.

To alternate the background color of rows in an HTML table using AMPscript, the MOD function can be used to determine if the row number is odd or even.

MOD Function: The MOD function returns the remainder of a division operation. By using MOD(@numerator, 2), the function returns 1 for odd rows and 0 for even rows, allowing the background color to be set accordingly.

AMPscript Example:

%%[ SET @numerator = 1 FOR @i = 1 TO RowCount(@rows) DO SET @color = IF MOD(@numerator, 2) == 1 THEN 'Red' ELSE 'White' ENDIF SET @numerator = ADD(@numerator, 1) ]%% %%[ NEXT @i ]%%

Salesforce AMPscript Functions

The "View Email As Web Page" (VAWP) link relies on the original email content being available. If the email used at the time of send was deleted, updated, or moved, the link will not be able to retrieve and display the content, resulting in the error message.

Salesforce VAWP Documentation

To store only the first 4000 characters of the fields SMTPBounceReason and SMTPCode in a data extension, the developer should use the LEFT (C) SQL function. This function returns the specified number of characters from the beginning of a string.

Example:

SELECT SubscriberKey, LEFT(SMTPBounceReason, 4000) AS SMTPBounceReason, LEFT(SMTPCode, 4000) AS SMTPCode FROM _Bounce

The developer can find information about the available properties for the DataExtensionField SOAP API object in the Developer Center at https://developer.salesforce.com (B). The Developer Center provides comprehensive documentation and reference materials for Salesforce APIs, including the SOAP API.

The Describe method in the SOAP API provides metadata about the objects available in the system, including Profile and Preference Attributes. This method can be used to dynamically retrieve and display these attributes in a custom profile center.

Describe Method: This method returns the schema of the objects, including fields and their properties, which can be used to dynamically generate forms and interfaces.

Salesforce SOAP API Describe Method

To validate that a parent-level data extension can be accessed by a child business unit, the developer should ensure that the data extension is in the Shared Data Extensions folder and the query includes the ENT. prefix (A). This setup allows shared data extensions to be accessible across different business units.

To create a JavaScript Web Token (JWT) using a key from Key Management in Salesforce Marketing Cloud, the GetJWTByKeyName function should be used. This function generates a JWT using the specified key from Key Management.

Salesforce JWT Documentation

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 add and verify From Addresses in Marketing Cloud, you can use the following routes:

POST /messaging/v1/domainverification: This endpoint is used to verify a single domain.

POST /messaging/v1/domainverification/bulk/insert: This endpoint is used to verify multiple domains in bulk.

Salesforce Domain Verification API

QUESTIONNO: 111

Northern Trail Outfitters sends a weekly email with dynamic content, and they want to record custom data inside a send log on each send to record what content was displayed and correlation flags.

What is the maximum number of custom data points recommended by Salesforce to ensure sends speeds are not affected when inserting into the built-in send log?

A. 20 fields or less

B. 10 fields or less

C. No limit

D. 5 fields or less

Answer: C

To ensure the security of Client ID and Client Secret credentials, they should be stored securely and not exposed in the application source code or URL parameters.

Environment Variables: Setting credentials as environment variables in the application platform is a secure way to handle sensitive information. This method ensures that the credentials are not hardcoded in the source code and can be managed securely by the application platform.

Environment Variables

Key Management System (KMS): Storing credentials in a key management system (KMS) provides an additional layer of security. KMS solutions are designed to securely store and manage sensitive information such as API keys, passwords, and other credentials.

The tracking data views in Salesforce Marketing Cloud, such as _Sent, _Open, and _Click, store data for a limited period.

Data Retention Period: Salesforce Marketing Cloud retains tracking data for up to six months in the data views. This means that developers can query up to six months of tracking data using these views.

Salesforce Marketing Cloud Data Views

To add an image to Content Builder via the API and retrieve the image's published URL, the developer should POST to the REST API/asset/v1/content/assets and parse the FileProperties parameter (D). This method uploads the image and returns metadata, including the published URL, which can be extracted from the FileProperties.

The Output function in AMPscript is used to include the result of interpreted code within a code block in the rendered content. This function ensures that the evaluated result of the code is included directly where the Output function is called.

Example:

ampscript

Copy code

%%[ SET @message = "Hello, World!" ]%% %%=Output(@message)=%%

Salesforce AMPscript Output Function

To configure an Email Send Logging Data Extension for a new business unit, the recommended approach is to use the SendLog Data Extension Template. This ensures that all necessary fields and configurations are correctly set up to log email send data.

SendLog Data Extension Template: This template includes predefined fields and settings that are required for logging email sends. Using this template ensures that the data extension is set up correctly for tracking send logs.

Go to Email Studio -> Subscribers -> Data Extensions.

Click on "Create".

Choose "Create from Template" and select the "SendLog" template.

Follow the prompts to configure and save the new Send Log data extension.

Salesforce Email Send Logging

Content Builder uses the REST API to manage content within Salesforce Marketing Cloud. The REST API allows developers to create, update, retrieve, and delete content assets, making it suitable for cross-channel campaign functions.

Salesforce Content Builder API

To track different versions of content within an email using dynamic content contained in a series of conditionals, the marketer should use the BeginImpressionRegion AMPscript function. This function marks the beginning of a region of content to track impressions, making it easier to analyze which versions of the content were viewed.

To define a filename pattern that matches files starting with the current month and day, you can use the %%MMDD%% pattern and the "Begins With" operator.

%%MMDD%% Pattern: This pattern represents the month and day in a two-digit format.

Begins With Operator: This operator ensures that the automation matches filenames that start with the specified pattern.

Salesforce File Drop Automations

In Salesforce Marketing Cloud, landing pages can use the Core Library and the Platform Library of Server-Side JavaScript (SSJS). The Core Library provides fundamental functions, while the Platform Library provides additional functionality to interact with Marketing Cloud-specific features.

Core Library: Provides basic SSJS functionality.

Platform Library: Extends SSJS functionality with additional methods specific to Marketing Cloud.

Salesforce SSJS Documentation

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

When batch deleting large volumes of contacts, it is important to consider the following factors:

Batch Deletion Limits: Up to one million records can be deleted in each batch. This helps manage and control the deletion process without overwhelming the system.

Suppression Status Visibility: The suppression status does not show for individual contacts until the entire batch processes. This means that you will not see the status updates for individual contacts until the deletion batch is fully processed.

Salesforce Contact Deletion Process

To securely pass parameters between CloudPages without exposing them, use the CloudPagesURL function within a form action. This method encodes the parameters and securely posts them to the target CloudPage.

CloudPagesURL: Encodes and includes parameters securely.

Form Method: Using the post method ensures parameters are sent in the request body, adding another layer of security.

Salesforce CloudPagesURL 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 create a query that aggregates clicks grouped by the language of the recipient, the developer needs to use Data Views that store subscriber and click information. The required Data Views are:

_Subscribers (A) - This Data View contains information about subscribers, including their profile attributes such as language.

_Click (D) - This Data View contains information about click events for email messages, which can be used to aggregate clicks.

The query would join these Data Views on a common identifier (e.g., SubscriberKey) and group the results by the language attribute.

To retrieve a row of data from a data extension using the SOAP API, the developer should use the DataExtensionObject API Object. This object allows for operations such as retrieving, updating, and inserting rows within a data extension.

Switching to Tenant Specific Endpoints (TSEs) provides the benefit of improved API performance (D). Tenant Specific Endpoints are designed to provide optimized performance by ensuring that API calls are routed through endpoints that are dedicated to a specific tenant, reducing latency and potential congestion issues associated with shared endpoints.

To ensure the expiration date on a coupon is the last day of the month, the developer should find the first day of the next month and subtract one day (A). This approach guarantees that the expiration date is set to the last day of the current month.

Example AMPscript:

SET @firstDayNextMonth = DateAdd(DatePart(Now(), "MM"), 1, "M") SET @lastDayCurrentMonth = DateAdd(@firstDayNextMonth, -1, "D")

To remove contacts mistakenly synced from the User_Salesforce object, the recommended approach is to put the synced records into a sendable data extension and use Contact Delete (C). This method allows for the systematic deletion of these contacts from the All Contacts table without affecting other data.

For a weekly promotional send, the marketer can use:

Sendable Data Extension: These are standard data extensions that are configured for sending and contain the necessary fields like Email Address and Subscriber Key.

Salesforce Data Extension: These are data extensions that are synchronized with Salesforce objects and can be used for sending emails.

Salesforce Data Extensions

To collect a representative sample from a larger data set, the developer should use the NTILE (C) SQL function. The NTILE function is used to distribute rows into a specified number of approximately equal-sized buckets or tiles, which can be useful for sampling purposes.

Example usage:

SELECT * FROM ( SELECT *, NTILE(10) OVER (ORDER BY SomeField) AS TileNumber FROM LargeDataSet ) AS Sample WHERE TileNumber = 1

This query divides the dataset into 10 tiles and selects rows from the first tile, effectively providing a sample.

To inject a contact into a journey using the API, you use the POST /interaction/v1/events route. This endpoint allows you to inject events into Journey Builder, effectively adding contacts to the journey based on the event definition.

Salesforce Journey Builder API

The UpdateDE function in AMPscript updates the data extension rows as the emails are being sent. If the send is canceled and only 400 emails are sent, then only the 400 subscribers who received the email will have their data extension rows updated by the UpdateDE function.

Salesforce AMPscript UpdateDE Function

To determine the best identifier for subscribers across all channels, Contact Key (A) should be recommended. The Contact Key is a unique identifier that can be used consistently across all channels, ensuring a unified view of the subscriber's interactions and data.