Salesforce Certified Marketing Cloud Engagement Developer Questions and Answers
MCE-Dev-201 Salesforce Certified Marketing Cloud Engagement Developer Questions and Answers
Questions 4
Northern Trail Outfitters' legal team is concerned about the daily import process that brings in subscribers to a Sendable Data Extension, even when records have already been targeted for deletion.
Which two true expected behaviors for these recordsoccur in the event a send is initiated directly to this Sendable Data Extension?
Choose 2 answers
Options:
A.
Records still in the suppression phase will only be excluded if manually specified during send time.
B.
Records still in the suppression phase will beexcluded from sends.
C.
Records that have already been deleted will be treated as new records.
D.
Records that have been deleted will be excluded from sends Indefinitely.
When a send is initiated directly to a Sendable Data Extension that includes records targeted for deletion, the following behaviors are expected:
Records still in the suppression phase will be excluded from sends (B) - These records are in the process of being deleted and will not be included in the send.
Records that have been deleted will be excluded from sends indefinitely (D) - Once records are deleted, they are permanently excluded from future sends.
A developer wants to personalize a welcome email with the recipient's first name from the Customers data extension, which is different from the targeted sending data extension named NewSubscribers. Both data extensionscontain the unique identifier in a field named CustomerKey. Which AMPscript Syntax would populate the first name personalization as requested?
To personalize the welcome email with the recipient's first name from the Customers data extension, you use the Lookup function to retrieve the FirstName field based on the CustomerKey field.
Lookup Function: The Lookup function retrieves a value from a specified data extension.
'Customers' is the name of the data extension from which to retrieve data.
'FirstName' is the field to retrieve.
'CustomerKey' is the field to match on.
CustomerKey is the value to match in the 'CustomerKey' field of the 'Customers' data extension.
Salesforce AMPscript Lookup Function
Questions 6
Certification Aid wants to create a file drop automation with a filename pattern. An import file is placed daily on the Marketing Cloud Enhanced FTP server, and thefile name always starts with the current month and day (e.g. OCT26). How should the filename pattern be defined? Choose 2.
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.
Salesforce File Drop Automations
Questions 7
Certification Aid wants to create Contacts in Marketing Cloud via API calls. Which API should be used for this? Choose 2.
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.
Salesforce Contacts API
Questions 8
Northtrn Trail Outfitters (NTO) wants to import a data file. It will be uploaded at regular intervals to their Enhanced FTP Account where an automation will import the file Into a data extension. NTO requires the file to be encrypted.
Which two file encryption options are supported when importing data files to Marketing Cloud?
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, , , , , ]
Questions 9
Northern Trail Outfitters uses a Send Log and sends more than one million emails per day. They want to execute daily reports on all subscriber activity without impacting send performance.
Which set of best practices should be implemented''
Options:
A.
Add a data retention policy to the Send Log. then run reports from the Send Log data extension.
B.
Add a data retention policy to the Send Log. then run reports from the _Opens data view.
C.
Copy new Send Log records to an Archive data extension, then run reports from the Archive data extension.
D.
Copy new Send Log records to an Archive data extension, then run reports from the Send Log data extension.
To execute daily reports on all subscriber activity without impacting send performance, the best practice is to copy 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, , , , , , ]
Questions 10
A developer needs to find all subscribers on the Customers data extension who made a purchase in the last 30 days. Purchase data is on the Orders data extension which contains a columncalled 'PurchaseDate'. Contacts are identified in both data extensions by a column called 'ContactKey', and the Orders data extension can contain many instances of the same subscnber.
Which SQL keyword should the developer use to achieve the desired result?
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 the ContactKey. This ensures that only subscribers with matching records in both data extensions are retrieved.
SQL Query Example:
SELECT c.ContactKey FROM Customers c INNER JOIN Orders o ON c.ContactKey = o.ContactKey WHERE o.PurchaseDate >= DATEADD(day, -30, GETDATE())
Salesforce SQL JOINs
Questions 11
A company has chosen to use the REST API for triggered sends, but they continue to get the following error during their testing: "Unable to queue Triggered Send request. There are no valid subscribers." They were informed that the SOAP API provides more information about the error, and found that their payload did not include a required data extension field.
Which element of the SOAP API response provides this level of detail?
In the SOAP API response, the element that provides detailed information about the error, including missing required data extension fields, is ErrorDescription (A). This element contains a description of the error, helping developers understand and resolve the issue.
A developer wants to trigger an SMS message to a subscriber using a form published on CloudPages. How should the SMS message be triggered once the subscriber submits the form?
Options:
A.
Outbound SMS template and Automation Send Method
B.
InsertData AMPscript function to add the subscriber to a MobileConnect list
To trigger an SMS message to a subscriber using a form published on CloudPages, the developer should use the requestToken and messageContact REST API objects (D). These objects can be used to authenticate and send the SMS message programmatically when the form is submitted.
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.
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.
Salesforce Contact Deletion Process
Questions 15
An UpdateDE AMPscript function is used to update a column value in a data extension row when an email is sent. The emailis being sent to 250,000 subscribers, but the user decides to cancel the send during the sending process and only 400 emails are sent.
How many subscriber rows would be affected by the UpdateDE function?
The UpdateDE function 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 the UpdateDE function.
Salesforce AMPscript UpdateDE Function
Questions 16
A developer identified duplicate contacts and wants to delete roughly 10 million subscribers usingContact Delete. How could the process be expedited?
Options:
A.
Change the Suppression value to a larger value
B.
Delete any unnecessary Sendable Data Extensions
C.
Manually delete subscribers in All Contacts
D.
Stop the current delete process and delete smaller groups
To expedite the process of deleting roughly 10 million subscribers using Contact Delete, the developer should change 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, , , , , ]
Questions 17
A company needs to retrieve a large number of rows from a data extension via the API.
Which two solutions would optimize the performance?
Choose 2 answers
Options:
A.
Use the REST API instead of the SOAP API.
B.
Use the AMPscript API functions on a CloudPage.
C.
Use the ContinueRequest feature.
D.
Use a SimpleFilterPart to retrieve small sets of relevant data.
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.
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.
Salesforce Domain Verification API
QUESTIONNO: 111
Northern Trail Outfitters sends a weekly email with dynamic content, and they want to record custom data inside a send log on each send to record what content was displayed and correlation flags.
What is the maximum number of custom data points recommended by Salesforce to ensure sends speeds are not affected when inserting into the built-in send log?
A. 20 fields or less
B. 10 fields or less
C. No limit
D. 5 fields or less
Answer: C
Questions 19
A developer needs to import a file nightly that will be used for multiple SQL Query Activities. The file could arrive any time between 2 a.m. and 5 a.m., and one of the requirements is that there is a unique file name for each import, rather than overwriting the file on the FTP site.
A File Drop Automation should be configured to handle files that arrive at varying times and have unique filenames. This type of automation triggers when a file is dropped into a specific folder on the Enhanced FTP site, allowing the system to handle imports as soon as the file arrives.
Salesforce File Drop Automations
Questions 20
A developer wants to create a Send LogData Extension to increase efficiency with tracking email sends.
Which two best practices should the developer remember when configuring the Send Log Data Extension? Choose 2 answers
Options:
A.
Use Data Retention to limit the amount of data captured.
B.
Limitcustom fields in the data extension to 10 or fewer.
C.
Create a number of fields equal to the fields in the source data extension.
D.
Maximize the field size to accommodate all incoming data.
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.
Salesforce Send Log Data Extension
Questions 21
Certification Aid wants to update Contact data stored in a Data Extension using the REST API. What is required to achieve this? Choose 1.
Options:
A.
The Data Extension must be in an Attribute Group.
B.
The Data Extensionmust be in a Population.
C.
The Data Extension must be sendable.
D.
The Data Extension must be created in Email Studio.
To update Contact data stored in a Data Extension using the REST API, the Data Extension must be in an Attribute 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.
To identify all subscribers who are unsubscribed from a specific Business Unit, the correct Data View to query is ListSubscribers (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, , , , , ]
Questions 23
A developer wantsto implement a newsletter registration from on NTO's website. Prior to form submission, an email address provided by the visitor should be validated. Which option could be used to support this scenario?
Options:
A.
REST API, /address/v1/validateEmail route
B.
SOAPAPI, Perform method with ValidationAction object
C.
SOAP API, Describe method with EmailAddress object
To validate an email address prior to form submission, the REST API endpoint /address/v1/validateEmail can be used. This endpoint allows you to check if the email address is formatted correctly and potentially validate it against known email address patterns.
Salesforce REST API for Email Validation
Questions 24
A developer is building an integration with the Marketing Cloud API. In which two ways should the Client ID and Client Secret credentials be stored? Choose 2
Options:
A.
Set credentials as environment variables in the application platform
B.
Pass credentials in URL parameters over HTTPS
C.
Set credentials as variables in application source code
To ensure the security of Client ID and Client Secret credentials, they should be stored securely and not exposed in the application source code or URL parameters.
Environment Variables: Setting credentials as environment variables in the application platform is a secure way to handle sensitive information. This method ensures that the credentials are not hardcoded in the source code and can be managed securely by the application platform.
Environment Variables
Key Management System (KMS): Storing credentials in a key management system (KMS) provides an additional layer of security. KMS solutions are designed to securely store and manage sensitive information such as API keys, passwords, and other credentials.
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.
Example Authorization Header: Authorization: Bearer YOUR_ACCESS_TOKEN
Salesforce API Access Tokens
Questions 26
A developer wants to create a data model in Contact Builder.
Which two applications will be able to use this newly-created data model for segmentation?
When using the REST API to send emails to customers after a purchase, the developer should make 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, , , ]
Questions 29
Certification Aid wants to automate the import of zipped files into a Data Extension. The zip files are placed on the Marketing Cloud Enhanced FTP server every night. Which activity is needed before those files can be imported? Choose 1.
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.
Salesforce File Transfer Activity
Questions 30
A developer created an email using the fasubjectLine variable as the subject line. Due to revisions, the developer declared <>subjectLine in multiple locations throughout the email, including:
Which subject line will be used at the time of deployment?
When the subjectLine variable 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).
To implement a custom profile center using SOAP API, the relevant SOAP API methods are:
Describe (B) - This method is used to retrieve metadata about objects, such as their fields and properties. It is useful for understanding the structure of the data you are working with.
Update (C) - This method is used to update existing records in Marketing Cloud. It is essential for modifying subscriber data in the custom profile center.
[References:, Salesforce Marketing Cloud SOAP API Methods, Custom Profile Center Implementation, , , ]
Questions 32
Which statements are trueregarding the Marketing Cloud SOAP API? Choose 2.
Options:
A.
More than 2000 SOAP calls can be performed per minute.
B.
Most SOAP calls can be synchronous or asynchronous.
Regarding the Marketing Cloud SOAP API, the following statements are true:
Most SOAP calls can be synchronous or asynchronous (B) - This means that API calls can either wait for the operation to complete (synchronous) or proceed with other tasks while waiting for the response (asynchronous).
Uses XML in request and response body (C) - The SOAP API utilizes XML for both requests and responses, providing a standardized format for data interchange.
[References:, Salesforce Marketing Cloud SOAP API Overview, Salesforce SOAP API Developer Guide, , , ]
Questions 33
A developer wants to set a variable to use a field from a Sendable Data Extension.
Which two options could be used in an AMPscript block to set the variable as a 'First Name" field from a Sendable Data Extension usedto send the email? Choose 2 answers
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.
Northern Trail Outfitters (NTO) stores most of their customer data in Marketing Cloud. They do not mind their data being viewed in clear text within SFMC to users who have access, but they want to ensure the underlying database files are encrypted at rest in case the physical media is stolen.
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.
Salesforce Transparent Data Encryption
Questions 35
A developer needs to determine why a Query Activity in an Automation has failed.
Which three scenarios could have caused this? Choose 3 answers
Options:
A.
The query takes more than 60 minutes to run.
B.
The query is returning more than one million rows.
C.
The query results in duplicate rows not allowed by the primary key.
D.
The query is not returning a value for a non-nullable field.
E.
The query is inserting a value that is larger than the size of a field.
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.
What parameter should a developer include to ensure the MobileConnectContact is tied to the Email Contact when making a QueueMO call for an existing email subscriber?
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 is emailaddress. This ensures that the MobileConnect Contact is correctly linked to the existing Email Contact.
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.
Salesforce Marketing Cloud Data Views
Questions 38
Certification Aid wants to add new customers to a cross-channel welcome campaign when they register on the company website. Which API should be used for this? Choose 1.
To add new customers to a cross-channel welcome campaign when they register on the company website, the Journey Builder API (D) should be used. This API allows you to programmatically inject contacts into a journey, triggering personalized marketing interactions across multiple channels.
A developer wants to create an AMPscript FOR loop that populates HTML table rows based on the number of rows and data in a target DE. Where should the developer place the FOR keyword to begin the loop?
To optimize the performance when retrieving a large number of rows from a Data Extension via the API:
Use a SimpleFilterPart to retrieve small sets of relevant data (A) - This approach helps in fetching only the necessary data by applying filters, thus reducing the amount of data transferred and processed.
Use the ContinueRequest feature (C) - This feature in the SOAP API allows for pagination of results, making it possible to handle large sets of data in manageable chunks.
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.
Salesforce SSJS Documentation
Questions 42
A developer is configuring a File Drop Automation and wantsto use a Filename Pattern to allow for timestamps on the file. The file name will always start with the month and day (e.g. MAY15) the file is dropped onto the SFTP site.
Which two configurations should be used for the automation to successfully start? Choose 2 answers
To configure a File Drop Automation with a filename pattern that allows for timestamps and starts with the month and day, the developer should use:
Begins With operator (D) - This ensures that the automation triggers when the file name begins with the specified pattern.
%%Month%%%%Day%% (C) - This is the correct syntax to match the month and day in the file name. For example, if the file name is "MAY15", the pattern will be %%MMMM%%dd.
[References:, Salesforce Marketing Cloud File Drop Automations, Automation Studio Filename Patterns, , , , ]
Questions 43
A developer wants to programmatically inject Contacts into a journey via REST API. What is the recommended route using POST data extension fields and values?
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.
NTO is using a mobile campaign to collect an email addresses of interested subscribers. Using AMPscript's API functions they will send a confirmation email when an email is texted into their short code. Which two objects are required tosuccessfully create a TriggerSend object? Choose 2
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.
Salesforce Programming Languages in Emails
Questions 46
Which of the following statements are correct concerning Contacts and Subscribers? Choose 2.
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.
NTO is reconsidering the requirement to have English, Spanish and French versions of their email campaigns. They request a developer to create a query which aggregates clicks grouped by language of the recipient. Language is stored in a Profile Attribute. Which two Data Views would be included in the query? Choose 2 answer
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.
An email requires custom AMPscript to append the subscriber's zip code to a link in theemail. A field name zipcode already exist in the sending data extension. Its important Marketing Cloud tracks subscribers who click on the link. Which two AMPscript functions should be used in the setup? Choose
To append the subscriber's zip code to a link and ensure that the clicks are tracked, you should use the Lookup function to retrieve the zip code from the data extension and the RedirectTo function 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
Salesforce AMPscript Lookup Function
Salesforce AMPscript RedirectTo Function
Questions 49
A developer needs to create a fully-branded CloudPagewhich includes images hosted in Content Builder. The developer wants to secure the page and its elements using the SSL protocol.
What is the minimum number of SSL certificates required?
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.
Salesforce SSL Certificates
Questions 50
What is the purpose of the IF statement below?
Options:
A.
To handle when no row is returned by the LookupRows function
B.
To handle when the subscriber is in a held status
C.
To handle when images are broken
D.
To handle when there are multiple records in the data extension for the subscriber
The purpose of the IF statement in the AMPscript code is to check if any rows are returned by the LookupRows function. 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.
Salesforce AMPscript LookupRows Function
Questions 51
A new record is appendedto the Orders data extension each time a customer makes a purchase. Which SQL statement would select a unique list of subscribers who have made multiple purchases?
Options:
A.
SELECT TOP 1 SubscriberKey FROM Orders
B.
SELECT DISTINCT SubscriberKey FROM Orders
C.
SELECT SubscriberKey FROM Orders GROUP BY SubscriberKey
D.
SELECT SubscriberKey FROM Orders GROUP BY SubscriberKey HAVING COUNT(*)>1
To select a unique list of subscribers who have made multiple purchases, the developer should use the following SQL statement:
SELECT SubscriberKey FROM Orders GROUP BY SubscriberKey HAVING COUNT(*) > 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, , , , , , , ]
Questions 52
A developerwants to retrieve daily JSON data from a customer's API and write it to a data extension for consumption in Marketing Cloud at a later time.
What set of Server-Side JavaScript activities should the developer use?
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:
var response = Platform.Function.HTTPGet("https://api.customer.com/data "); var jsonData = Platform.Function.ParseJSON(response); Platform.Function.UpsertData("DataExtensionName", ["PrimaryKeyField"], jsonData);
A developer is creating a custom preference center and wants to log unsubscribeevents from the CloudPage. Which set of parameters should be captured and provided to the LongUnsubEvent Execute Call to ensure accurate unsubscribe information?
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.
Salesforce LogUnsubEvent Documentation
Questions 54
In which three ways should a developer optimize a query activity if it is currently timing out? Choose 3
Options:
A.
Use intrisic functions in the WHERE clause
B.
Use SELECT * to include all fields
C.
Use Primary key(s) on fields used in joins
D.
Use intermediate tables to stage data
E.
Only update records that have changed since last execution
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.
A developer needs to import a file into a data extension which contains transactional data. The file includes a column labeled Purchase_Price with values varying from '$.05' to '$100'.
What Data Type should be used to prevent loss of data'
The best Data Type to use for the Purchase_Price column, which includes values ranging from '$.05' to '$100', is Decimal(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, ======================, , ]
Questions 56
Certification Aid wants to include SSJS in an email message. Which code block can be used for this? Choose 2.
To include Server-Side JavaScript (SSJS) in an email message, you need to use the : This is a valid way to include SSJS in an email. It specifies that the enclosed code should be executed on the server.
Salesforce SSJS Documentation
: This is another valid syntax. It specifies that the code within the script tag is JavaScript and should run on the server.
In Salesforce Marketing Cloud, access tokens are valid for one 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, , , , , ]
Questions 58
Northern Trail Outfitters' account is configured with two child BU(s): US and Global. The account has a dataextension In the Shared Data Extensions folder named 'MemberData'. This data extension contains basic address information, as well as Boolean fields labeled 'US' and 'Global' indicating to which business unit the subscriber belongs. Automation needs to becreated in the US business unit to query all records in New York who are members of the business unit US.
SELECT * FROM MemberData WHERE State = 'NY' AND US = 1
What would cause this query to report the following error: "An error occurred while checking the query syntax. Errors: MemberData is not a known data extension or system data view. You can only query existing data extensions or system data views."?
Options:
A.
Incorrect syntax; Query Activities are written in SOQL
In an Enterprise 2.0 account, when querying shared data extensions from a child business unit, the data extension name should be prefixed with 'ENT.' to indicate it resides in the shared data extensions folder.
Correct Query:
SELECT * FROM ENT.MemberData WHERE State = 'NY' AND US = 1
