Marketing-Cloud-Developer Salesforce Certified Marketing Cloud Developer (SU24) Questions and Answers

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

References:

• Salesforce Developer Center
• SOAP API DataExtensionField Object

To sum up multiple variables in AMPscript, theAddfunction should be used. TheAddfunction can be nested to handle multiple values.

• Example:

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

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

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

When an email is sent to a list where subscribers have no associated Subscriber Key, Marketing Cloud will use the Email Address as the Contact Key by default. This ensures that each subscriber can still be uniquely identified even if they do not have a predefined Subscriber Key.

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:

SELECTs.SubscriberKeyFROM_Sent sLEFTJOIN_Click cONs.SubscriberKey=c.SubscriberKeyANDs.JobID=c.JobIDWHEREs.JobID='420'ANDc.SubscriberKeyISNULL

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.

References:

• Salesforce Marketing Cloud Data Views
• SQL Join and Subquery Documentation

To ensure that clicks are tracked for a dynamic link created using AMPscript, the developer should wrap the link variable in aRedirectTofunction and include an alias attribute for tracking purposes.

• RedirectTo Function: This function helps ensure that the link click is properly tracked by Salesforce Marketing Cloud (SFMC). The function takes a URL and ensures that tracking parameters are appended correctly.

%%[ SET @dynamicLink = "https://example.com/?id=" + AttributeValue("SubscriberID") ]%% Click Here

• uk.co.certification.simulator.questionpool.PList@17d31af0

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.

To avoid data loss and ensure reliable data transfer to Marketing Cloud data extensions, follow these best practices:

• Handle 'Not Authorized' Errors: If a 'Not Authorized' error occurs, it is likely due to an expired or invalid access token. Request a new access token and retry the API call.
• Retry on Server Errors: If a server error occurs, it might be a temporary issue. Ensure the server is available and retry the call.
• Token Expiry Management: Store the expiry time of the access token and request a new one before the old token expires to prevent authorization issues.

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

References:

• Salesforce Marketing Cloud SOAP API
• Salesforce Marketing Cloud DataExtension Object

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.

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

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

Exclusion Scripts are used to exclude subscribers from email sends based on specific criteria. This functionality can be applied in various sending scenarios within Salesforce Marketing Cloud.

• Journey Builder Send Email Activity: In Journey Builder, exclusion scripts can be applied to Email Activities to ensure specific subscribers are excluded based on the business rules.

The newly created data model in Contact Builder can be used for segmentation in the following applications:

• Email Studio (A)- Email Studio can use data extensions and attribute groups from Contact Builder for segmentation.
• Journey Builder (C)- Journey Builder can leverage the data model created in Contact Builder for creating targeted journeys and audience segments.

References:

• Salesforce Marketing Cloud Contact Builder
• Journey Builder Data Integration

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.

References:

• Salesforce Marketing Cloud AMPscript Date Functions
• Salesforce Marketing Cloud Documentation

To securely pass parameters between CloudPages without exposing them, use theCloudPagesURLfunction 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 thepostmethod ensures parameters are sent in the request body, adding another layer of security.

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.

References:

• Salesforce Marketing Cloud Data Views
• SQL Reference Guide

To successfully create a TriggeredSend object using AMPscript's API functions to send a confirmation email when an email is texted into their shortcode, the following objects are required:

• Subscribers (A)- Represents the individual recipients who will receive the triggered email.
• TriggeredSendDefinition (B)- Defines the parameters of the triggered send, including the email to be sent and the associated attributes.

References:

• Salesforce Marketing Cloud Triggered Send
• Salesforce Marketing Cloud AMPscript API Functions

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.

References:

• Salesforce Marketing Cloud Contact Delete Process
• Contact Suppression and Deletion

To reference subscriber, system, and sendable Data Extension attributes for content personalization using SSJS, the correct syntax is<ctrl:field name="attributeName" />. This tag allows you to dynamically insert the value of an attribute into the email content.

• Tag: This tag is used to insert the value of an attribute from a Data Extension or subscriber attribute into the content. Thenameattribute of thetag specifies which attribute's value should be used.

%%[ var @firstName set @firstName = AttributeValue("FirstName") ]%% Hello,!

• uk.co.certification.simulator.questionpool.PList@184aa130

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:

SELECTs.SubscriberKeyFROM_Sent sJOIN_Job jONs.JobID=j.JobIDWHEREj.SendDate>=DATEADD(month,-12, GETDATE())

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.

To track the performance of dynamically created content via AMPscript in an email, the following steps should be performed:

• Request the Impression Tracking feature be enabled on the account: This feature must be enabled to track impressions of dynamic content.
• Include the functions BeginImpressionRegion and EndImpressionRegion: These functions are used within the AMPscript code to mark the beginning and end of the content region that needs to be tracked.

• Example:

ampscript

Copy code

%%[BeginImpressionRegion('DynamicContent')]%%

%%=v(@DynamicContent)=%%

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

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.

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

To ensure performance, it is recommended to createone Population (D). Creating multiple populations can lead to complexity and performance issues. Having a single population helps in managing contacts efficiently and reduces the overhead on the system.

References:

• Salesforce Marketing Cloud Documentation on Populations
• Contact Builder Overview

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.

References:

• Salesforce Marketing Cloud REST API
• Salesforce Marketing Cloud SOAP API ContinueRequest

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

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.

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/authorizeendpoint with the client credentials.

TheIIFfunction 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!')=%%

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

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

To set a variable to use a field from a Sendable Data Extension in an AMPscript block, the following options can be used:

• SET @firstName = %%First Name%% (B)- This syntax directly references the field value within AMPscript.
• SET @firstName = AttributeValue('First Name') (C)- This function retrieves the value of the specified attribute (field) for the current subscriber context.

References:

• Salesforce Marketing Cloud AMPscript Guide
• AttributeValue Function

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 retrieve which subscribers were sent a particular email using the Marketing Cloud SOAP API, the developer should use theSentEvent (C)SOAP API object. This object records the event when an email is successfully sent to a subscriber.

References:

• Salesforce Marketing Cloud SOAP API
• SentEvent Object

To convert a string payload in JSON format to a JavaScript object on a CloudPage, the developer should use theParseJSON (B)function in Marketing Cloud Server-Side JavaScript (SSJS). This function parses a JSON string and returns a corresponding JavaScript object.

Example:

varjsonString ='{"key1":"value1", "key2":"value2"}';varjsonObject =Platform.Function.ParseJSON(jsonString);

References:

• Salesforce Marketing Cloud SSJS Guide
• SSJS Platform.Function.ParseJSON

For a data extension to be selected for journey entry in Journey Builder, it must be configured for sending. This configuration ensures that the data extension is recognized as a source for sending communications.

• Configure for Sending: When creating or editing a data extension, ensure that it is set as "Sendable." This involves specifying the appropriate fields for sending, such as Subscriber Key and Email Address.

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.

References:

• Salesforce Marketing Cloud SOAP API Overview
• Salesforce SOAP API Developer Guide

To retrieve subscribers who were sent emails with names starting with "TEST," we need to join the_Joband_Sentsystem data views on theJobIDfield and filter by theEmailNamefield using aLIKEcondition.

• Join Condition: The correct join condition between_Joband_SentisON J.JobID = S.JobID. This ensures that we are linking the job and sent data correctly.
• EmailName Filter: We useJ.EmailName LIKE 'TEST%'to filter for emails whose names start with "TEST".

SELECT*FROM_Job JINNERJOIN_Sent SONJ.JobID=S.JobIDWHEREJ.EmailNameLIKE'TEST%'

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

After usingLookupRowsto retrieve data when building a dynamic email, the next step before using this rowset within a FOR loop is touseRowCountto ensure the rowset contains data (D). This validation ensures that there are rows to iterate over, preventing potential errors or empty iterations in the FOR loop.

Example:

SET @rows = LookupRows("DataExtensionName", "FieldName", "Value") SET @rowCount = RowCount(@rows) IF @rowCount > 0 THEN FOR @i = 1 TO @rowCount DO SET @row = Row(@rows, @i) /* process each row */ NEXT @i ENDIF

References:

• Salesforce Marketing Cloud AMPscript Guide
• AMPscript RowCount Function

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

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.

The error stating that the application cannot insert a duplicate value for the primary key in the data extension occurs becausethe InsertDE function cannot be used at send time. The InsertDE function is designed to insert records into a data extension, but it cannot handle the transactional nature of email sends where records might be added simultaneously.

References:

• Salesforce Marketing Cloud AMPscript InsertDE Function
• Salesforce Marketing Cloud Data Extension Best Practices

TheRaiseErrorAMPscript function can be configured tolog the source of the error (C). This functionality is useful for error handling and debugging, allowing administrators to identify the cause of an issue and take appropriate action.

References:

• Salesforce Marketing Cloud AMPscript Guide: RaiseError

When receiving an "insufficient Privileges" error while attempting to upload a base64-encoded file to Content Builder using an API Installed Package, the developer shouldvalidate the Client Id and Client Secret are correct. These credentials are necessary for authentication and authorization when interacting with Salesforce Marketing Cloud APIs.

References:

• Salesforce Marketing Cloud API Authentication
• Salesforce Marketing Cloud Content Builder API

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

References:

• Salesforce Marketing Cloud Tracking Extract Activity
• Salesforce Marketing Cloud Data Views

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

Example:

SELECTSubscriberKey,LEFT(SMTPBounceReason,4000)ASSMTPBounceReason,LEFT(SMTPCode,4000)ASSMTPCodeFROM_Bounce

References:

• SQL LEFT Function
• Salesforce Marketing Cloud SQL Reference