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

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 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 the provided AMPscript, theIFstatement checks the length of the@pointvariable and sets@valueaccordingly. Sincex = 'Tacos'has a length of 5, it meets the first conditionLength(@point) > 1, which sets@valueto 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 ]%%

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 include Server-Side JavaScript (SSJS) in an email message, you need to use the<script>tag with therunat="server"attribute. This ensures that the script runs on the server side before the email is sent.

• : This is a valid way to include SSJS in an email. It specifies that the enclosed code should be executed on the server.

Platform.Load("Core","1");varrows =Platform.Function.LookupRows("DataExtensionName","EmailAddress","example@example.com");

• uk.co.certification.simulator.questionpool.PList@1c42a7e0

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 update Contact data stored in a Data Extension using the REST API, the Data Extension must be in anAttribute Group (A). This is necessary because the REST API interacts with Contact data through Attribute Groups, which organize Data Extensions and their relationships within Contact Builder.

References:

• Salesforce Marketing Cloud REST API
• Contact Builder and Attribute Groups

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

SELECTSubscriberKeyFROM_OpenWHEREJobID='1234'

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

References:

• Salesforce Marketing Cloud Data Views
• Salesforce SQL Reference Guide

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.

The Contact Delete feature can be used within an Enterprise 2.0 accountfrom the Parent account (B). This ensures centralized management and compliance with organizational data governance policies.

References:

• Salesforce Marketing Cloud Documentation on Contact Delete
• Enterprise 2.0 Account Management

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.

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 = "http://example.com/?id=" + AttributeValue("SubscriberID") ]%% Click Here

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

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

Salesforce Marketing Cloud offers various encryption options when creating a new key in Key Management. The three encryption options that can be used are:

• Asymmetric (B)- Asymmetric encryption uses a pair of keys (public and private) for encryption and decryption. This method is highly secure as the private key remains confidential.
• RSA (C)- RSA is a specific type of asymmetric encryption. RSA stands for Rivest-Shamir-Adleman, and it is widely used for secure data transmission.
• Symmetric (E)- Symmetric encryption uses the same key for both encryption and decryption. It is efficient for encrypting large amounts of data.

References:

• Salesforce Marketing Cloud Documentation
• AMPscript Guide

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

In Salesforce Marketing Cloud, access tokens are valid forone hour (D). After one hour, a new access token must be obtained to continue making API calls. This ensures security and helps manage the lifespan of tokens effectively.

References:

• Salesforce Marketing Cloud API Authentication
• Salesforce Marketing Cloud REST API Overview

When logging unsubscribe events from a CloudPage using the LogUnsubEvent Execute Call, it's crucial to capture and provide both the SubscriberKey and the JobID. The SubscriberKey uniquely identifies the subscriber, while the JobID identifies the specific email job from which the subscriber is unsubscribing.

• SubscriberKey: Identifies the subscriber in the Marketing Cloud.
• JobID: Identifies the email job that triggered the unsubscribe event.

TheOutputfunction 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 theOutputfunction is called.

• Example:

ampscript

Copy code

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

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

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}/sendendpoint.
• SOAP API: The SOAP API can also be used to trigger sends by utilizing theTriggeredSendobject.

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.

A developer should request a new tokenonce an hourwhen 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.

References:

• Salesforce Marketing Cloud API Token Management
• Salesforce Marketing Cloud Authentication

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

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

References:

• Salesforce Marketing Cloud Journey Builder API
• Cross-Channel Campaign Management

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

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.

To automate the process of importing encrypted files from an external CRM, the following actions should be included:

• File drop to the SFTP Import directory: Place the encrypted files in the SFTP Import directory to trigger the automation.
• File transfer activity to the Safehouse for decryption: Move the encrypted files to the Safehouse for decryption, ensuring the data is securely handled.
• Import definition to the necessary data extension: After decryption, import the data into the relevant Data Extension for use in marketing sends.

In an Enterprise 2.0 account, the Contact Delete feature can only be used from the Parent account. This centralization ensures that contact deletion is managed consistently and in compliance with organizational policies.

References:

• Salesforce Marketing Cloud Contact Builder
• Contact Management in Enterprise 2.0

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

If the email send's tracking information is not available in Sales Cloud, the next step is to confirm that the audience was a Salesforce Data Extension containing the appropriate Salesforce ID (SFID).

• Salesforce Data Extension: Ensure that the data extension used for the send is a Salesforce Data Extension that includes the appropriate SFID for each subscriber. This is crucial for the integration to correctly match the tracking data with the Salesforce records.

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

References:

• Salesforce Marketing Cloud SOAP API DataExtensionObject
• Salesforce Marketing Cloud SOAP API Reference

To remove line breaks within the Comments field and replace them with a single space, you can use theREPLACEfunction in combination with theCHARfunction. TheCHAR(13)andCHAR(10)functions represent carriage return and line feed characters, respectively.

• REPLACE Function: This function is used to replace occurrences of a specified string with another string.
• CHAR Function: This function returns the character based on the ASCII code provided.

• Example:

SELECTREPLACE(REPLACE(Comments,CHAR(13),' '),CHAR(10),' ')ASCommentsFROMYourDataExtension

To control the rendering of unique and default content based on the presence of subscriber data in a related data extension, the best practice is to use theRowCountfunction and anIFstatement:

%%[ VAR @rowCount SET @rowCount = RowCount(LookupRows("RelatedDataExtension", "SubscriberKey", _subscriberKey)) IF @rowCount > 0 THEN /* Render unique content */ ELSE /* Render default content */ ENDIF ]%%

This approach checks if there are any rows in the related data extension for the subscriber and conditionally renders the appropriate content.

References:

• AMPscript Guide
• Salesforce Marketing Cloud Documentation

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.

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

To trigger an SMS message to a subscriber using a form published on CloudPages, the developer should use therequestToken and messageContact REST API objects (D). These objects can be used to authenticate and send the SMS message programmatically when the form is submitted.

References:

• Salesforce Marketing Cloud MobileConnect API
• Salesforce Marketing Cloud REST API

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.

To append the subscriber's zip code to a link and ensure that the clicks are tracked, you should use theLookupfunction to retrieve the zip code from the data extension and theRedirectTofunction to create the link with tracking enabled.

• Lookup: Retrieves the zip code from the data extension.
• RedirectTo: Ensures that the link with the appended zip code is tracked.

• Example:

ampscript

Copy code

%%[ SET @zipcode = Lookup("DataExtensionName", "zipcode", "SubscriberKey", _subscriberkey) SET @link = Concat("http://example.com?zip=", @zipcode) ]%% Click Here

TheSentdata view contains records of all emails that have been sent, including details such as JobID, EventDate, and other relevant information. To gather the required information about emails deployed in the last seven days, theSentdata view should be used.

• Query Example:

SELECTJobID, EventDate,COUNT(*)asSentCountFROM_SentWHEREEventDate>=DATEADD(day,-7, GETDATE())GROUPBYJobID, EventDate

When importing an encrypted file from the Enhanced FTP server, you need to move the file to the Safehouse first, and then decrypt it within the Safehouse.

• Move to Safehouse: Use a File Transfer activity to move the encrypted file from the Enhanced FTP server to the Safehouse.
• Decrypt in Safehouse: Use another File Transfer activity to decrypt the file within the Safehouse.

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

When preparing data to be used in Contact Builder, the following factors should be taken into consideration:

• Assigning data relationships and primary keys across all channels (A)- This ensures that data is linked properly and can be utilized across different marketing channels.
• Verifying data address marketing needs (B)- Ensuring that the data aligns with the marketing goals and requirements.
• Normalizing data to reduce redundancy (E)- Organizing the data to eliminate duplicate entries and improve efficiency.

References:

• Salesforce Marketing Cloud Documentation on Contact Builder
• Data Preparation Best Practices

=========================

The Event Notification Service (ENS) in Salesforce Marketing Cloud provides real-time event notifications, such as email opens and clicks. Using ENS, Northern Trail Outfitters can trigger follow-up messages based on real-time engagement data.

Regarding Populations in Contact Builder:

• Populations need to be added to an Attribute Group (B)- This is necessary to define the relationship between the population and the associated data extensions and attributes.
• No more than three Populations should be created (C)- Creating more than three populations can lead to performance issues and complexity in managing contacts.

References:

• Salesforce Marketing Cloud Contact Builder
• Populations in Contact Builder

TheBalancefield is a text field and contains the value "S6.96", which is a string. TheIFstatement is comparing a string with a numeric value (6.00). Since the operands are not of the same data type, this can yield unintended results. To correctly compare the balance, the string should be converted to a numeric value.

• Example:

%%[ SET @Balance = "6.96" /* Simulating text field value */ IF (Value(@Balance) > 6.00) THEN SET @Result = 'Balance is more than $6.00' ENDIF ]%%

To retrieve multiple records associated with a particular customer from theOrderDetailsdata extension, theLookupRowsandLookupOrderedRowsfunctions 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.

ampscript

Copy code

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

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

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

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

To ensure the expiration date on a coupon is the last day of the month, the developer shouldfind 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")

References:

• Salesforce Marketing Cloud AMPscript Guide
• Salesforce Marketing Cloud Documentation

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.

When making a QueueMO call for an existing email subscriber in MobileConnect, the developer should include theemailaddress (C)parameter. This ensures that the MobileConnect Contact is correctly tied to the corresponding Email Contact.

References:

• Salesforce Marketing Cloud MobileConnect API
• AMPscript and MobileConnect

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.

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.

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

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

%%[ 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 ]%%