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

To identify all subscribers who were sent Job ID 420 but did not click any links, the developer should use a SQL statement that selects subscribers from the _Sent Data View where the Job ID is 420 and excludes those who are found in the _Click Data View. The correct SQL statement is:

SELECT s.SubscriberKey FROM _Sent s LEFT JOIN _Click c ON s.SubscriberKey = c.SubscriberKey AND s.JobID = c.JobID WHERE s.JobID = '420' AND c.SubscriberKey IS NULL

This query performs a left join between the _Sent and _Click data views and filters the results to include only those subscribers who do not have a corresponding click record.

The error message "Cannot Perform 'Post' on objects of type 'SentEvent'" indicates that the SentEvent object is not updatable via the SOAP API. The SentEvent object is typically read-only and is used for tracking purposes.

Read-Only Object: The SentEvent object is used to log events and is not designed to be modified via API calls. This is why attempts to perform POST operations on it will result in an error.

Salesforce SOAP API Error Codes

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.

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.

To create a lead capture form on a landing page and create a Lead record in Salesforce, you can use either AMPscript or SSJS. AMPscript can be used for interacting with Salesforce, and SSJS can handle form processing. Alternatively, SSJS can handle the entire process, including creating the Salesforce record.

AMPscript and SSJS Combination: You can use AMPscript to interact with Salesforce APIs to create records and SSJS for form handling.

SSJS for Full Functionality: SSJS can handle both the form submission and the interaction with Salesforce to create Lead records.

Salesforce AMPscript and SSJS Integration

After using the messageDefinitionSends REST API endpoint to send a triggered send email, and receiving a 202 (success) response code, the developer can validate if the email was successfully sent by using the messageDefinitionSend/key:(key)/deliveryRecords REST endpoint with the GET method. This endpoint provides delivery records and allows verification of the email's delivery status.

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.

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

Using the RaiseError AMPscript function allows a developer to handle errors when necessary data for building an email is missing. The possible outcomes of using this function include:

The send fails (A) - The entire email send can be stopped if a critical error is encountered.

The email is not sent to the particular subscriber (B) - The send can be aborted for specific subscribers who do not have the necessary data.

A Contact can be reintroduced into the system only after the deletion is fully complete. The Contact Delete process in Salesforce Marketing Cloud is designed to ensure that all references and data associated with the contact are thoroughly removed. Reintroducing the contact before the process is fully complete would disrupt this cleanup process and potentially lead to data integrity issues.

The AMPscript function that returns the number of rows in a specified data extension is DataExtensionRowCount (B). This function provides the count of rows within a data extension, which can be used to dictate what is displayed on a landing page.

Example usage:

SET @rowCount = DataExtensionRowCount("MyDataExtension")

To manage the data model programmatically and access the Attribute Group schema, the REST API should be used. The REST API provides endpoints to interact with and retrieve information about Attribute Groups and their schemas.

Salesforce REST API

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

To build out a series of CloudPages that will interact with several REST APIs, the developer should use SSJS (Server-Side JavaScript) (C). SSJS is supported in Marketing Cloud and provides robust capabilities for interacting with external APIs, handling HTTP requests, and processing data.

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

To optimize the performance when retrieving a large number of rows from a data extension via the API, the following solutions can be used:

Use the REST API instead of the SOAP API (A) - The REST API generally offers better performance for data retrieval operations compared to the SOAP API.

Use the ContinueRequest feature (C) - This feature allows for the pagination of results, enabling the retrieval of large datasets in manageable chunks.

An Exclusion Script is used to exclude certain subscribers from an email send based on defined criteria. It can also log or capture details of those excluded addresses for reporting purposes.

Exclusion Script: This script runs before the send and can dynamically exclude recipients based on logic you define. It allows you to prevent competitors from receiving the email and to log their email addresses.

Salesforce Exclusion Script Documentation

The JobID parameter is required for the LogUnsubEvent request to be tied to the appropriate send. The JobID uniquely identifies the email job that was sent, allowing the system to accurately log the unsubscribe event for that specific send.

JobID: This parameter ensures that the unsubscribe event is correctly associated with the email send job.

Salesforce LogUnsubEvent Documentation

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

Automation Studio provides tools for extracting tracking data from the Marketing Cloud. This can be done using the Data Extract Activity, which allows you to extract various types of tracking data such as email send, open, and click information.

Salesforce Automation Studio Data Extract Activity

To identify all subscribers who are unsubscribed from a specific Business Unit, the correct Data View to query is ListSubscribers (A). This Data View contains information about the subscription status of subscribers at the list level, including unsubscribe status for specific Business Units.

AMPscript is evaluated in the following order before an email is sent:

Subject Line: Evaluates AMPscript in the subject line first.

HTML Body: Evaluates AMPscript within the HTML body of the email.

Text Body: Evaluates AMPscript within the text body of the email.

This order ensures that any dynamic content or personalization logic is correctly applied in all parts of the email.

Salesforce AMPscript Evaluation Order

The operational order of the Contact Delete process for Marketing Cloud is as follows:

Delete initiated - The process begins when the contact delete request is initiated.

Suppression phase - During this phase, the contacts are marked for deletion and are suppressed from further communications.

Final Deletion - The contacts are permanently deleted from the system.

Before importing a compressed file into Marketing Cloud, a File Transfer activity is required to move and decompress the file. The File Transfer activity allows you to specify the source and destination locations and to decompress the file, making it ready for the import process.

Salesforce File Transfer Activity

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

To programmatically inject Contacts into a journey via the REST API, the recommended route is /interaction/v1/events. This endpoint allows you to trigger an event which can be configured to start a journey for the specified contacts.

To build an audience by identifying subscribers who opened a specific email, the developer should use the following query:

SELECT SubscriberKey FROM _Open WHERE JobID = '1234'

This query selects the SubscriberKey from the _Open data view where the JobID matches the specific email send.

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 successfully create a TriggerSend object using AMPscript's API functions, the following objects are required:

TriggerSendDefinition (B) - Defines the parameters of the triggered send, including the email to be sent and the associated attributes.

Subscribers (D) - Represents the individual recipients who will receive the email.

These objects ensure that the correct email is sent to the specified subscribers when the TriggerSend is executed.

To ensure that contacts relate across different channels in Marketing Cloud, you need to link the unique identifier used across channels to the Contact ID in Contact Builder. This involves creating Attribute Groups and establishing the relationships between the unique identifier and the Contact ID.

Link the Numeric Field Value: By linking the numeric unique identifier to the Contact ID in Attribute Groups, you ensure that each contact is uniquely identified across channels.

Create Attribute Groups: Attribute Groups in Contact Builder allow you to map the relationships between different data sources and the Contact object, ensuring that the unique identifier is connected correctly for each channel.

Salesforce Contact Builder Documentation

A File Drop Automation should be configured to handle files that arrive at varying times and have unique filenames. This type of automation triggers when a file is dropped into a specific folder on the Enhanced FTP site, allowing the system to handle imports as soon as the file arrives.

Salesforce File Drop Automations

To dynamically create data extensions in Marketing Cloud, the developer should use the SOAP API using the Create method and the DataExtension object (A). This allows for the creation of data extensions with dynamic names and structures.

To exclude sending an email at send time to those with a record on the 'Exclude' Data Extension where the primary key is Subscriber Key, the developer should use the following Exclusion Script:

ampscript

Copy code

RowCount(LookupRows('Exclude', 'SubscriberKey', _SubscriberKey)) > 0

This script checks if there are any rows in the 'Exclude' Data Extension that match the Subscriber Key. If the count is greater than 0, the email is excluded from being sent.

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 analyze the Send, Click, and Open Data Views and transfer the data to the SFTP, the developer should build the following activities:

Query Activity - To query and gather the data from the Send, Click, and Open Data Views.

Data Extension Extract - To extract the queried data from the data extension and prepare it for transfer to the SFTP.

The RedirectTo AMPscript function prevents link href values from getting recorded in tracking (C). When RedirectTo is used, it bypasses the standard link wrapping and tracking process, causing the link click not to be captured in the tracking data.

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")

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

To add new customers to a cross-channel welcome campaign when they register on the company website, the Journey Builder API (D) should be used. This API allows you to programmatically inject contacts into a journey, triggering personalized marketing interactions across multiple channels.

When importing data files to Marketing Cloud, the supported file encryption options are:

PGP encryption (A) - Pretty Good Privacy (PGP) encryption is supported for securing files.

AES encryption (D) - Advanced Encryption Standard (AES) encryption is also supported for file security.

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

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 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

To export send data to their SFTP, the following automations can be used:

Tracking Extract > File Transfer (B) - This automation extracts tracking data and then transfers the file to an SFTP location.

Query (Data Views) > Data Extension Extract > File Transfer (C) - This automation queries the data views to gather the necessary data, extracts the data from the data extension, and then transfers the file to an SFTP location.

Regarding the Marketing Cloud SOAP API, the following statements are true:

Most SOAP calls can be synchronous or asynchronous (B) - This means that API calls can either wait for the operation to complete (synchronous) or proceed with other tasks while waiting for the response (asynchronous).

Uses XML in request and response body (C) - The SOAP API utilizes XML for both requests and responses, providing a standardized format for data interchange.

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

In AMPscript, the valid syntax for comments is /* comment */. This allows you to add comments within your AMPscript code for documentation or clarification purposes.

Salesforce AMPscript Syntax Guide

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

When configuring a Send Log Data Extension, it is crucial to follow best practices to ensure efficient tracking and data management.

Use Data Retention: Implementing data retention policies helps manage the volume of data stored in the send log, improving performance and reducing storage costs.

Limit Custom Fields: Limiting the number of custom fields to 10 or fewer helps maintain the efficiency and performance of the data extension.

Salesforce Send Log Data Extension

To secure a CloudPage and its elements (such as images) using SSL, a single SSL certificate can be used if both the CloudPage and the images are hosted under the same domain. This SSL certificate ensures that all content served from that domain is encrypted and secure.

Salesforce SSL Certificates

To expedite the process of deleting roughly 10 million subscribers using Contact Delete, the developer should change the Suppression value to a larger value (A). Increasing the suppression period helps in reducing the time taken for the deletion process as it allows the system to handle more deletions at once, thus speeding up the overall process.

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.

When configuring an API integration component in an Installed Package, it is best practice to select the minimum required scope for the integration. This approach ensures that the integration has only the necessary permissions, enhancing security by limiting access to only what is required.

Minimum Required Scope: Selecting only the scopes that are necessary for the integration helps maintain a secure and controlled environment.

Salesforce API Integration Best Practices

The Contact Delete process in Marketing Cloud removes contact data from various locations to ensure complete deletion. This includes both sendable data extensions and mobile lists.

Sendable Data Extensions: The Contact Delete process will remove contact data from sendable data extensions, ensuring that the contact is no longer present in any data used for sending.

Mobile Lists: Contact data will also be removed from mobile lists, ensuring that the contact is fully deleted across all communication channels.

Salesforce Contact Deletion Process