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

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

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

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.

Before using the 'contacts/' route of the REST API to update records in a data extension, the developer should verify thatthe data extension should be linked in an AttributeGroup in Contact Builder (D). This ensures that the data extension is part of the contact model and can be accessed and updated using the REST API.

References:

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

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

Questions no:153Verified Answer:DComprehensive Detailed Step by Step Explanation with References:To ensure a blank email will not be sent when creating a complex dynamic email with multiple sections and content blocks, the developer shouldconfirm every version has default content (D). This practice ensures that if any dynamic content fails to load or meet the conditions, the default content will be displayed, preventing a blank email from being sent.

References:

• Salesforce Marketing Cloud AMPscript Guide
• Salesforce Marketing Cloud Dynamic Content Best Practices

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

Questions no:154Verified Answer:DComprehensive Detailed Step by Step Explanation with References:When using the REST API to send emails to customers after a purchase, the developer shouldmake a token API call and re-use the token until the token expires (D). This approach optimizes API usage by reducing the number of token requests, ensuring that the token is reused until it naturally expires, after which a new token can be requested.

References:

• Salesforce Marketing Cloud API Authentication
• Token Management Best Practices

Top of Form

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

To ensure a blank email will not be sent when creating a complex dynamic email with multiple sections and content blocks, the developer shouldconfirm every version has default content (D). This practice ensures that if any dynamic content fails to load or meet the conditions, the default content will be displayed, preventing a blank email from being sent.

References:

• Salesforce Marketing Cloud AMPscript Guide
• Salesforce Marketing Cloud Dynamic Content 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.

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

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

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

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

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.

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

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

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

The Contact Delete process in Marketing Cloud removes contact data from the contact model but does not remove records from the data extensions themselves.

• Contact Delete Process: When you perform a Contact Delete in Contact Builder, it removes the contact data from the contact model but leaves the actual rows in the data extensions intact.

The outdated subject line variable could be locatedin the HTML body which is processed after the subject line (D). This is because AMPscript variables declared in the HTML body can affect the overall email content, including the subject line, and if not updated, they can cause discrepancies in the displayed subject line.

References:

• Salesforce Marketing Cloud AMPscript Guide
• Email Subject Line Best Practices

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

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

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.

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.

The best Data Type to use for thePurchase_Pricecolumn, which includes values ranging from '$.05' to '$100', isDecimal(9,2) (C). This data type ensures that values are stored accurately without data loss, allowing for precision up to two decimal places.

References:

• Salesforce Marketing Cloud Data Extensions
• Decimal Data Type

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

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

Regarding Contacts and Subscribers in Salesforce Marketing Cloud:

• Each Subscriber is also a Contact (C)- In Marketing Cloud, a Subscriber is a type of Contact that is specifically associated with the Email channel.
• A Contact is subscribed to a specific channel (D)- A Contact can be subscribed to one or more channels, such as Email, Mobile, or Web, within Marketing Cloud.

References:

• Salesforce Marketing Cloud Contacts and Subscribers
• Understanding Contact Management

To configure a data extension to store data for six months, you should update the data extension configuration to include data retention settings.

• Data Retention Settings: You can configure data retention directly within the data extension settings in Email Studio to specify how long data should be retained. This ensures that data older than the specified period is automatically deleted.

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

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

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.

When thesubjectLinevariable is declared in multiple locations throughout the email, the value used at the time of deployment will be the last value assigned to the variable. In the provided declarations, the last assignment is:

%%[ SET @subjectLine = 'Enjoy 20% off today' ]%% was declared within the Subject Line

Therefore, the subject line used at the time of deployment will be"Enjoy 20% off today" (C).

References:

• Salesforce Marketing Cloud AMPscript Variable Scope
• AMPscript Guide: Variable Declaration

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

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.

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

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

Synchronous REST API calls to Marketing Cloud have different timeout limits based on the type of operation:

• 300 seconds for tracking and data retrieve operations: These operations involve more extensive data processing, hence the higher timeout limit.
• 120 seconds for non-tracking operations: Standard non-tracking API calls have a shorter timeout limit.

TheLookupRowsfunction retrieves rows from a data extension where specified criteria are met. In an Enterprise 2.0 account, the data extension name in shared data extensions should be prefixed with 'Ent.' to indicate it is in the shared space.

• Example:

SET @rows = LookupRows('Ent. Inventory', 'InStock', 'true')

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

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

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

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

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.

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.

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.

The "Overwrite" import operation is used when you want to completely replace the contents of a Data Extension with the contents of the import file. This operation adds new records from the file and removes any records that are not present in the file.

• Overwrite Operation: This will ensure that the Data Extension contains only the records present in the CSV file. Any existing records in the Data Extension that are not in the file will be deleted.