Marketing-Cloud-Developer Practice Exam Questions with Answers Salesforce Certified Marketing Cloud Developer (SP25) Certification

In Salesforce Marketing Cloud, you can use either AMPscript or Server-Side JavaScript (SSJS) in email messages. Both languages are supported and can be used to manipulate data, create dynamic content, and perform other server-side operations.

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.

References:

• AMPscript Guide
• Salesforce Marketing Cloud Documentation

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.

The SQL statement in question does not return any records because it is joining on theEmailAddressfield, which is not present in the_BounceData View. The correct approach is to join using theSubscriberKey(orSubscriberID). Here is the corrected SQL statement:

SELECTs.EmailAddress, s.SubscriberKey, b.JobID, b.EventDate, b.SMTPBounceReasonFROM_Subscribers sJOIN_Bounce bONs.SubscriberKey=b.SubscriberKeyWHEREb.EventDate>DateAdd(DAY,-30, GETDATE())

This ensures that the join is based on theSubscriberKey, which is a common field in both data views.

References:

• Salesforce Marketing Cloud Data Views
• Query Activity Best Practices

To successfully create aTriggerSendobject 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.

References:

• Salesforce Marketing Cloud API
• AMPscript API Functions

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

TheUpdateDEfunction 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 theUpdateDEfunction.

To accurately identify subscribers who have unsubscribed from any of the child business units in an Enterprise 2.0 account, it is necessary to create data extracts of all subscribers within each child business unit. This approach ensures that unsubscribes specific to each business unit are captured.

• Data Extracts: By creating data extracts within each child business unit, you can gather comprehensive unsubscribe data for all subscribers specific to each unit.

In an Enterprise 2.0 account, when querying shared data extensions from a child business unit, the data extension name should be prefixed with 'ENT.' to indicate it resides in the shared data extensions folder.

• Correct Query:

SELECT*FROMENT.MemberDataWHEREState='NY'ANDUS=1

To personalize the welcome email with the recipient's first name from the Customers data extension, you use the Lookup function to retrieve the FirstName field based on the CustomerKey field.

• Lookup Function: The Lookup function retrieves a value from a specified data extension.
• Syntax:

%%=Lookup('Customers', 'FirstName', 'CustomerKey', CustomerKey)=%%

• uk.co.certification.simulator.questionpool.PList@19773ee0

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

References:

• Salesforce Marketing Cloud Data Views
• ListSubscribers Data View

To expedite the process of deleting roughly 10 million subscribers using Contact Delete, the developer shouldchange 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.

References:

• Salesforce Marketing Cloud Documentation on Contact Delete
• Marketing Cloud Contact Deletion Best Practices

Before deleting a sendable data extension that contains a large number of contact records, it is important to manage the contact deletion through Contact Builder. Deleting the data extension from Contact Builder ensures that all related contact information is also removed from the contact model.

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.

References:

• Salesforce Marketing Cloud File Import Activity
• File Transfer and Encryption Options

Transparent Data Encryption (TDE) is the appropriate method for ensuring that the underlying database files are encrypted at rest. TDE encrypts the database files themselves, protecting the data in case the physical media is stolen, while allowing the data to be viewed in clear text by authorized users within the system.

• Transparent Data Encryption: Encrypts data at rest, ensuring that the database files are secure.

In Marketing Cloud, theContact Keyshould be represented as a Text data type, even if it is a numeric value. This is because using the Text data type avoids issues related to numeric value formatting and allows for greater flexibility in handling the values.

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.

TheHTTPGet2andHTTPPost2functions in AMPscript allow you to include additional headers, such as an OAuth token, in your HTTP requests. These functions provide more flexibility for specifying custom headers compared to the standardHTTPGetandHTTPPostfunctions.

• Example:

SET @header = 'Authorization: Bearer your_oauth_token' SET @response = HTTPPost2("https://example.com/api", @header, "data=example")

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 theContactKey. This ensures that only subscribers with matching records in both data extensions are retrieved.

• SQL Query Example:

SELECTc.ContactKeyFROMCustomers cINNERJOINOrders oONc.ContactKey=o.ContactKeyWHEREo.PurchaseDate>=DATEADD(day,-30, GETDATE())

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.

References:

• Salesforce Marketing Cloud Tracking Extract Activity
• Salesforce Marketing Cloud File Transfer Activity

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

When using Server-Side JavaScript (SSJS) in Salesforce Marketing Cloud, the developer can leverage the following features:

• Wrapping of AMPscript in SSJS code (A)- SSJS can include AMPscript within its code, allowing for dynamic content generation and manipulation.
• Include Try/Catch blocks within the code (D)- SSJS supports the use of Try/Catch blocks to handle errors and exceptions in the script, providing better control over error management.

References:

• Salesforce Marketing Cloud Server-Side JavaScript Guide
• AMPscript and SSJS Integration

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

When creating relationships in Data Designer, it's essential to link the Contact ID to the Subscriber Key. The Contact ID in Marketing Cloud represents a unique identifier for contacts across various data sources, and linking it to the Subscriber Key ensures accurate data mapping and integration.

To optimize a query activity that is currently timing out, a developer can use the following strategies:

• Use Primary key(s) on fields used in joins (C)- Ensures that the join operations are efficient by utilizing indexed fields.
• Use intermediate tables to stage data (D)- Breaks down complex queries into simpler steps, improving manageability and performance.
• Only update records that have changed since last execution (E)- Reduces the amount of data processed by focusing only on changes since the last query run.

References:

• Salesforce Marketing Cloud SQL Optimization
• Query Activity Best Practices

The AMPscript function that returns the number of rows in a specified data extension isDataExtensionRowCount (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")

References:

• Salesforce Marketing Cloud AMPscript Guide: DataExtensionRowCount

TheRedirectToAMPscript functionprevents link href values from getting recorded in tracking (C). WhenRedirectTois used, it bypasses the standard link wrapping and tracking process, causing the link click not to be captured in the tracking data.

References:

• Salesforce Marketing Cloud AMPscript Guide
• Link Tracking in Marketing Cloud

To validate that a parent-level data extension can be accessed by a child business unit, the developer should ensure thatthe 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.

References:

• Salesforce Marketing Cloud Shared Data Extensions
• Query Activities with Shared Data Extensions

Switching to Tenant Specific Endpoints (TSEs) provides the benefit ofimproved 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.

References:

• Salesforce Marketing Cloud Tenant Specific Endpoints
• API Best Practices

QUESTIONNO: 115

A data extension contains two fields which are being populated by a query activity. A third field has recently been added to the data extension.

Which SELECT statement is optimal for returning all of the columns in the data extension?

A. SELECT field*

B. SELECT *, field1, field2, field3

C. SELECT*

D. SELECT 22SE, field2, field3

Answer: C

The optimal SELECT statement for returning all columns in the data extension, including the newly added third field, is:

SELECT*

This statement ensures that all fields, including any new fields added to the data extension, are returned without needing to list them explicitly.

References:

• Salesforce Marketing Cloud SQL Reference
• Query Activity Best Practices

To retrieve the status of an asynchronous SOAP API call to the TriggerSend object, you should use theResultItemobject along with theRequestIDattribute.

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

When creating a Server-to-Server Installed Package and associated API Integration in Marketing Cloud, it is essential to grant specific scopes (permissions) to the API Integration component. This ensures that the integration has the necessary access to perform its tasks without granting unnecessary permissions.

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.

To determine if a specific text string exists in a tab-delimited list of values, theBuildRowSetFromStringAMPscript function is the most appropriate. This function splits the string into a rowset, making it easier to search for the specific text.

• BuildRowSetFromString Function: This function converts a delimited string into a rowset, which can then be iterated over or searched using other AMPscript functions.

SET @values = "val1\tval2\tval3" SET @rowset = BuildRowSetFromString(@values, "\t") SET @rowCount = RowCount(@rowset) SET @found = "false" FOR @i = 1 TO @rowCount DO SET @row = Row(@rowset, @i) SET @value = Field(@row, 1) IF @value == "specificText" THEN SET @found = "true" /* exit the loop if found */ BREAK ENDIF NEXT @i

After using themessageDefinitionSendsREST 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 themessageDefinitionSend/key:(key)/deliveryRecordsREST endpoint with the GET method. This endpoint provides delivery records and allows verification of the email's delivery status.

References:

• Salesforce Marketing Cloud REST API Reference
• Triggered Send Email Validation

To add an image to Content Builder via the API and retrieve the image's published URL, the developer shouldPOST 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.

References:

• Salesforce Marketing Cloud REST API: Content Builder
• Salesforce Marketing Cloud Asset API

To dynamically populate the physical address of a company's locations using the variable@addressand ensure the fastest possible performance for millions of subscribers, the recommended AMPscript solution is:

%%[ SET @address = Lookup("Building_Locations", "Address", "Id", @Id) ]%%

This solution uses theLookupfunction, which retrieves a specific field value from a data extension based on the given criteria. It is efficient and performs well for high-volume sends.

References:

• Salesforce Marketing Cloud AMPscript Guide
• Salesforce Marketing Cloud Documentation

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.

TheSubscriberKeyis the appropriate parameter to use when appending data to links via the Web Analytics Connector. This parameter uniquely identifies subscribers across all sends and ensures accurate tracking of subscriber behavior.

• Subscriber Key: A unique identifier for a subscriber that remains consistent across all data extensions and sends.

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.

References:

• Salesforce Marketing Cloud Contact Builder
• Contact Key Overview

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.

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.

For pushing real-time updates to a data extension, the following API options are available:

• Use the DataExtensionObject SOAP object (A)- This object allows you to perform various operations such as insert, update, and delete on data extensions through SOAP API calls.
• Use the DataExtension SOAP object (C)- Similar to DataExtensionObject, this object provides capabilities to manage data extensions and their records via SOAP API.

These APIs allow for real-time interaction with data extensions, making them suitable for updating the product catalog.

References:

• Salesforce Marketing Cloud SOAP API Developer Guide
• Data Extension Objects in SOAP API

A 401 Unauthorized HTTP status message indicates that the request was not authenticated properly. This error commonly occurs when the access token is missing, invalid, or expired.

• Access Token Issues: The most common cause of a 401 error in REST API requests is related to the access token. The request must include a valid access token in the authorization header.

To validate an email address prior to form submission, the REST API endpoint/address/v1/validateEmailcan be used. This endpoint allows you to check if the email address is formatted correctly and potentially validate it against known email address patterns.

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.

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.

References:

• Salesforce Marketing Cloud REST API
• Journey Builder API

To reference SSJS (Server-Side JavaScript) variables for content personalization in Salesforce Marketing Cloud, you use the<ctrl:eval>tag. This tag evaluates the SSJS variable and inserts its value into the content. The correct usage is:

variableName

This syntax allows you to dynamically insert the value ofvariableNameinto the email content.

References:

• Salesforce Marketing Cloud Documentation
• AMPscript and SSJS Guide

In the SOAP API response, the element that provides detailed information about the error, including missing required data extension fields, isErrorDescription (A). This element contains a description of the error, helping developers understand and resolve the issue.

References:

• Salesforce Marketing Cloud SOAP API
• SOAP API Error Handling

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

• Correct Method:Authorization: Bearer YOUR_ACCESS_TOKEN

TheFormatCurrencyAMPscript function is used to format a numeric value as a currency. To return a value of $6.96, the function would correctly format inputs like:

• 6.96 (B)- This is a direct numeric value that will be formatted to $6.96.
• 6.96 (D)- Same as above, the numeric value is directly formatted to $6.96.

UsingFormatCurrency(6.96)in AMPscript will result in$6.96.

References:

• Salesforce Marketing Cloud Documentation on FormatCurrency
• AMPscript Guide

To create contacts in Marketing Cloud via API calls, both the REST API and the specific POST route for contacts can be used:

• POST /contacts/v1/contacts route: This is a specific REST API endpoint designed to create new contacts in Marketing Cloud.
• REST API: The broader REST API provides various endpoints for managing contacts, including creation, updating, and deletion.