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

When batch deleting large volumes of contacts, it is important to consider the following factors:

• Batch Deletion Limits: Up to one million records can be deleted in each batch. This helps manage and control the deletion process without overwhelming the system.
• Suppression Status Visibility: The suppression status does not show for individual contacts until the entire batch processes. This means that you will not see the status updates for individual contacts until the deletion batch is fully processed.

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.

Content Builder uses the REST API to manage content within Salesforce Marketing Cloud. The REST API allows developers to create, update, retrieve, and delete content assets, making it suitable for cross-channel campaign functions.

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.

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.

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 manage the data model programmatically and access the Attribute Group schema, the REST API should be used. The REST API provides endpoints to interact with and retrieve information about Attribute Groups and their schemas.

To select a subset of records that contain a phone number, the field that ensures the phone number is valid and non-blank should be used.

• ValidPhone Field: TheValidPhonefield is a formula field that evaluates to 'true' if the phone number is valid. This ensures that only records with a valid phone number are included in the synchronization.

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

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

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

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

To exclude sending an email at send time to those with a record on the 'Exclude' Data Extension where the primary key is Subscriber Key, the developer should use the following Exclusion Script:

ampscript

Copy code

RowCount(LookupRows('Exclude', 'SubscriberKey', _SubscriberKey)) > 0

This script checks if there are any rows in the 'Exclude' Data Extension that match the Subscriber Key. If the count is greater than 0, the email is excluded from being sent.

References:

• AMPscript Guide
• Salesforce Marketing Cloud Documentation

To optimize a SQL Query Activity in Automation Studio that is experiencing timeouts, the developer shoulduse intermediate tables to break queries into smaller parts (B). This approach helps in managing complex queries by breaking them down into smaller, more manageable steps, thus reducing the likelihood of timeouts.

References:

• Salesforce Marketing Cloud Documentation on Query Activity
• SQL Query Optimization Tips

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

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

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

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

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.

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.

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

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.

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

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.

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

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

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

Content Builder uses the REST API to manage content within Salesforce Marketing Cloud. The REST API allows developers to create, update, retrieve, and delete content assets, making it suitable for cross-channel campaign functions.

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

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.

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

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.

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

References:

• Salesforce Marketing Cloud SOAP API
• SOAP API Error Handling

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

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

The tracking data views in Salesforce Marketing Cloud, such as_Sent,_Open, and_Click, store data for a limited period.

• Data Retention Period: Salesforce Marketing Cloud retains tracking data for up to six months in the data views. This means that developers can query up to six months of tracking data using these views.

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

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

Using the RaiseError AMPscript function allows a developer to handle errors when necessary data for building an email is missing. The possible outcomes of using this function include:

• The send fails (A)- The entire email send can be stopped if a critical error is encountered.
• The email is not sent to the particular subscriber (B)- The send can be aborted for specific subscribers who do not have the necessary data.

References:

• Salesforce Marketing Cloud AMPscript RaiseError Function
• Salesforce Marketing Cloud Documentation

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