Salesforce Marketing-Cloud-Developer Salesforce Certified Marketing Cloud Developer (SU24) Exam Practice Test

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

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.

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.

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

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

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

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)=%%

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

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 populate a data extension with the date of the most recent click for each subscriber, the developer should use the following SQL query:

SELECTc.SubscriberKey,MAX(c.eventDate)ASeventDateFROM_Click cGROUPBYc.SubscriberKey

This query selects the SubscriberKey and the maximum eventDate for each subscriber from the _Click Data View, ensuring that the most recent click date is retrieved.

References:

• Salesforce Marketing Cloud Data Views
• SQL MAX Function

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

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 Contact Delete process can be slow for a large number of contacts. To expedite this process, the best approach is to stop the current delete process and delete smaller groups of contacts. This allows the system to handle smaller chunks of data more efficiently.

• Stop Current Process: Stopping the current large delete process helps avoid system overload and potential timeouts.
• Delete in Smaller Groups: By segmenting the contacts into smaller groups and deleting them in batches, the process becomes more manageable and faster.

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.

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

References:

• Salesforce Marketing Cloud Query Activity
• Salesforce Marketing Cloud Data Extract Activity

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

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 remove contacts mistakenly synced from the User_Salesforce object, the recommended approach is toput 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.

References:

• Salesforce Marketing Cloud Contact Delete
• Managing Contacts in Marketing Cloud

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.

References:

• Salesforce Marketing Cloud Documentation on Contact Deletion
• Contact Builder in Marketing Cloud

A Contact can be reintroduced into the system onlyafter 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.

References:

• Salesforce Marketing Cloud Documentation on Contact Deletion
• Salesforce Marketing Cloud Contact Builder

To build out a series of CloudPages that will interact with several REST APIs, the developer should useSSJS (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.

References:

• Salesforce Marketing Cloud SSJS Guide
• SSJS Functions

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

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 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 aggregate monthly energy usage data stored in variables for each month, you should use theADDfunction in AMPscript to sum up the values. TheADDfunction can be nested to handle multiple values.

• AMPscript Example:

%%[ SET @total = ADD(@jan, ADD(@feb, ADD(@mar, @apr))) ]%%

Transparent Data Encryption (TDE) is designed to protect data at rest by encrypting the underlying storage of the database. This method ensures that data is encrypted on disk to prevent physical data theft while allowing it to remain accessible to authorized users within the system.

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

To execute daily reports on all subscriber activity without impacting send performance, the best practice is tocopy 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.

References:

• Salesforce Marketing Cloud Send Log Best Practices
• Data Extension Best Practices

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

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

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

Before importing zipped files into a Data Extension, a File Transfer activity is needed to unzip the files on the Marketing Cloud Enhanced FTP server. This activity moves and decompresses the files to make them available for import.

• File Transfer Activity: This activity is used to move files from one location to another and to unzip compressed files.

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 add records to a Data Extension using the SOAP API, theDataExtensionObjectobject is utilized. This object represents a row within a data extension.

• DataExtensionObject: This object is specifically designed to interact with data extensions, allowing you to insert, update, and retrieve rows. Here is a basic example of how to use this object to add a record:

DataExtensionExternalKeySubscriberKeyexample@example.comFirstNameJohnLastNameDoe

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

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

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

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.

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

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.

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

SELECTSubscriberKeyFROMOrdersGROUPBYSubscriberKeyHAVINGCOUNT(*)>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.

References:

• SQL GROUP BY Statement
• SQL HAVING Clause

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

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

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