Marketing-Cloud-Developer Sample Questions Answers

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

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

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

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

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

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

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

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

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 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 retrieve daily JSON data from a customer's API and write it to a data extension, the developer should use the following set of Server-Side JavaScript activities:

• Platform.Function.HTTPGet();- To make the HTTP GET request to the customer's API and retrieve the JSON data.
• Platform.Function.ParseJSON();- To parse the retrieved JSON data.
• Platform.Function.UpsertData();- To upsert the parsed data into a data extension.

Example code snippet:

varresponse =Platform.Function.HTTPGet("https://api.customer.com/data" );varjsonData =Platform.Function.ParseJSON(response);Platform.Function.UpsertData("DataExtensionName", ["PrimaryKeyField"], jsonData);

References:

• Salesforce Marketing Cloud SSJS HTTP Functions
• Salesforce Marketing Cloud SSJS Data Functions

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

To define a filename pattern that matches files starting with the current month and day, you can use the%%MMDD%%pattern and the "Begins With" operator.

• %%MMDD%% Pattern: This pattern represents the month and day in a two-digit format.
• Begins With Operator: This operator ensures that the automation matches filenames that start with the specified pattern.

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

To retrieve the value of the AMPscript variable namedsubKeyin Server-Side JavaScript (SSJS), the following statement should be used:

Var.Get("subKey");

This statement retrieves the value of the specified AMPscript variable within SSJS.

References:

• Salesforce Marketing Cloud SSJS Guide
• AMPscript and SSJS Integration

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

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

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.

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

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

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.

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.

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.

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

Profile attributes like AGE in Profile Manager are not directly accessible via the _Subscribers data view or _EnterpriseAttribute data view. To retrieve subscribers over 30 years of age, creating a filtered Group based on the AGE attribute is the most effective method.

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 validate an email address prior to form submission, the REST API endpoint/address/v1/validateEmailcan be used. This endpoint allows you to check if the email address is formatted correctly and potentially validate it against known email address patterns.

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 create a Call-To-Action (CTA) link in an email that will display personal information about the subscriber on a landing page, the developer should use theAMPscript CloudPagesURL function (A). This function generates a URL for a CloudPage and can include parameters such as SubscriberKey or EmailAddress, which will be passed to the landing page securely.

Example usage:

rectTo(@url)=%%">View Your Information

This ensures that the SubscriberKey is securely passed to the CloudPage without exposing it directly in the URL.

References:

• Salesforce Marketing Cloud AMPscript Guide: CloudPagesURL
• Salesforce Marketing Cloud Documentation

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.

When configuring a Send Log Data Extension, it is crucial to follow best practices to ensure efficient tracking and data management.

• Use Data Retention: Implementing data retention policies helps manage the volume of data stored in the send log, improving performance and reducing storage costs.
• Limit Custom Fields: Limiting the number of custom fields to 10 or fewer helps maintain the efficiency and performance of the data extension.

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.

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

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.

To secure a CloudPage and its elements (such as images) using SSL, a single SSL certificate can be used if both the CloudPage and the images are hosted under the same domain. This SSL certificate ensures that all content served from that domain is encrypted and secure.

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

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.

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

A Query Activity in an Automation can fail for several reasons, including:

• The query takes more than 60 minutes to run (A)- Long-running queries are subject to timeouts, which can cause the query to fail.
• The query results in duplicate rows not allowed by the primary key (C)- If the query attempts to insert duplicate rows into a data extension that has a primary key constraint, it will fail.
• The query is inserting a value that is larger than the size of a field (E)- If the query attempts to insert data that exceeds the field size limits, it will result in an error.

References:

• Salesforce Marketing Cloud Query Activity
• Salesforce Marketing Cloud SQL Best Practices

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

To ensure the MobileConnect Contact is tied to the Email Contact when making a QueueMO call for an existing email subscriber, the parameter to include isemailaddress. This ensures that the MobileConnect Contact is correctly linked to the existing Email Contact.

References:

• Salesforce Marketing Cloud MobileConnect API
• AMPscript and MobileConnect

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

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

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

Data extension functions in AMPscript, such asLookupRows,LookupOrderedRows, andUpdateDE, can most negatively impact send processing because they involve querying and manipulating data extensions. These operations can be resource-intensive and time-consuming, especially when dealing with large data sets.

Before importing a compressed file into Marketing Cloud, a File Transfer activity is required to move and decompress the file. The File Transfer activity allows you to specify the source and destination locations and to decompress the file, making it ready for the import process.

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

The purpose of the IF statement in the AMPscript code is to check if any rows are returned by theLookupRowsfunction. If rows are returned, it retrieves the image field from the data extension and sets the image source accordingly. If no rows are returned, it defaults to using a standard image.