Font size
WorksheetsDeveloper Cert practice exam #5
Total questions: 65
Worksheet time: 2hrs 10mins
Certification Aid wants to add new customers to a cross-channel welcome campaign when the register on the company website. Which API should be used for this?
Personalization Builder API
Event Notification API
Transactional Messaging API
Journey Builder API
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.
Set credentials as environment variables in the application platform
Pass credentials in URL parameters over HTTPS
Set credentials as variables in application source code
Store credentials in a key management system (KMS)
A developer wants to create a Synchronized Data Extension containing Lead data from Sales Cloud. They only want to include records which contain a phone number. Each of the following fields contains this information per these rules:
Phone is not black (Data Type = Phone)
PhoneExist is true (Data Type = Boolean)
ValidPhone is 'true' (Data Type = Formula(Boolean))
ContactType equals 'Phone' (Data Type = Text)
Which field could be used to select a subset of records in the synchronization configuration?
ValidPhone
Phone
ContactType
PhoneExist
NTO uses data extensions to manage the subscriber information used for their email sends, and those sends include calls to update records with new or different subscriber information. The developer handling these records writes some AMPscript to check and see if the data extension containing those records has been updated using an InsertDE() call if the record doesn't exist yet. Why would the developer receive an error stating the application cannot insert a duplicate value for the primary key in the data extension?
The InsertDE() function will always insert two rows into a data extension as part of the call
The InsertDE() function cannot be used with name and value pairs
The InsertDE() function comes after the system added the row as part of the email send
The InsertDE() function cannot be used at send time
Which of the following is a valid comment within an AMPscript code block?
--comment
// comment
comment -->
/* comment */
Which programming language should be used in email messages?
AMPscript only
Either AMPscript or SSJS
SSJS only
A developer wants to inject a Contact into a journey using API. What method and route would be used to accomplish this?
Post/contact/v1/contacts
Post/v1hub/dataevents/key:[key]/rows/{primaryKeys}
Post/interaction/v1/events
Post/interaction/v1/interactions
In what order is AMPscript evaluated before an email is sent?
Subject Line, HTML Body, Text Body
HTML Body, Text Body, Subject Line
Text Body, HTML Body, Subject LIne
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?
SELECT field*
SELECT *, field1, field2, field3
SELECT*
SELECT field1, field2, field3
A developer wants to expand the functionality of existing code which was written in AMPscript, but prefers to use Server-Side JavaScript (SSJS) for updates. Which SSJS statement will retrieve the value of the AMPscript variable named subKey?
Var.Get("subKey");
Variable.GetValue("@subKey");
Variable.SetValue("subKey","Value");
Var.Retrieve("@subKey");
A developer wants CloudPages to work with a REST API returning data in JavaScript Object Notation. The developer wants to efficiently ingest the data and write it to a data extension. Which function should be used?
Server-Side JavaScript function Stringify
Server-Side JavaScript funtion ParseJSON
AMPscript funtion BuildRowsetFromXML
AMPscript funtion BuildRowsetFromString
A developer is implementing a custom profile center and using the LogUnsubEvent request. Which parameter is required for the event to be tied to the appropriate send?
JobID
ListID
Unsub Reason
SubscriberKey
A developer is leveraging the SOAP API to dynamically display Profile and Preference Attributes in a custom profile center. Which method could be used to support the dynamic functionality?
Describe
Extract
Perform
Configure
An email requires custom AMPscript to append the subscriber's zip code to a link in the email. A field name zipcode already exists in the sending data extension. It's important Marketing Cloud tracks subscribers who click on the link. Which AMPscript function should be used in the setup?
vLookup
Contact
RedirectTo
HTTPGet
NTO has set up their North American business unit to unsubscribe at the business unit level. Which dataview would they query to identify all subscribers who are unsubscribed from that Business Unit?
ListSubscribers
ENT._Subscribers
_BusinessUnitUnsubscribes
Subscribers
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? Choose 2.
PGP Encryption
RSA Encryption
GPG Encryption
AES Encryption
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? Choose 2.
Email Studio
Automation Studio
Journey Builder
Mobile Studio
NTO mistakenly synced the User_Salesforce object which added to their billable contact count. What should be recommended to remove these contacts?
Update the sync to remove these contacts from the All Contacts table.
Use the REST API to delete the contacts from the All Subscribers table.
Put the synced records into a sendable data extension and use Contact Delete.
Use the SOAP API to delete the contacts from the All Contacts table.
A developer is creating a CloudPage which accepts secure parameters via an email link and will submit those parameters to another CloudPage for data upsert. The page currently captures an Appointment ID parameter passed into it and sets the value to the variable @apptId. The developer does NOT want the Appointment ID to be visible to anyone using the form. What is the best method to ensure the parameters are passed successfully to the data upsert page?
<input id="apptId" type="textarea" value="%%=v(@apptId)=%%" readonly>
<form action="%%= MicrositeURL(123,'apptId', @apptId)=%%" method="post">
<form action="%%=CloudPagesURL(123,'apptId',@apptId)=%%">
<input id="MaaptId" type="textarea" value="%%=v(@apptId)=%%" hidden>
NTO has an Enterprise 2.0 account with 15 business units. Each business unit can access a Shared Data Extension named 'Inventory', which contains the details for each product. A Boolean field named 'InStock' indicates whether the item is available. Which snippet of AMPscript would return all products which are currently available?
LookupRows ('Ent.Inventory', 'true' 'InStock'`)
LookupRows ('Ent.Inventory', itemName, 'InStock', 'true')
LookupRows ('Ent.Inventory', 'InStock', 'true')
LookupRows ('Inventory', 'InStock', 'true')
A developer needs to display a value which has been calculated using an AMPscript block. This value is stored in the variable named 'Label'. Which two ways should the developer display this value in the body of an email? Choose 2.
%%=v(@Label)=%%
<ctrl:vr name=@label />
%%@Label%%
%%(Write (@Label))%%
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.
Use the REST API instead of the SOAP API
Use the AMPscript API functions on a CloudPage
Use the ContinueRequest feature
Use a SimpleFilterPart to retrieve small sets of relevant data
NTO wants to determine the best identifier for subscribers across all channels. What should be recommended?
Contact Key
Mobile ID
Email Address
Subscriber ID
A customer wants a list of subscribers who were sent an email within the past 12 months. How should this request be completed?
Create a measure with the criteria sent_date is after today minus 365 days
Run a tracking extract via the SOAP API
Query against the Job and Sent data views
Locate the email sends in the Tracking tab within Email Studio
Which two AMPscript HTTP functions allow an OAuth token to be passed in a header? Choose 2.
HTTPPost
HTTPGet
HTTPGet2
HTTPPost2
A marketer is planning a weekly promotional send. Which two types of data extensions could be sent to? Choose 2.
Synchronized Data Extension
Sendable Data Extension
Salesforce Data Extension
Send Log Data Extension
NTO has a sendable data extension with 1,500,000 contact records they want to delete. Which step is required before deleting the contacts?
Query the records into a new sendable data extension and delete it
Navigate to Contact Builder and delete the data extension
Divide the records in half and delete each resulting data extension
Navigate to Email Studio and delete the data extension
A developer needs to process a payload from an external system in a CloudPage. What Marketing Cloud Server-Side JavaScript platform function should be used for converting a string payload in JSON format to a JavaScript object?
Base64Decode
ParseJSON
CreateObject
Stringify
A developer wants to build out a series of CloudPages that will interact with several REST APIs. Which Marketing Cloud supported scripting tool should be used?
AMPscript
GTL
SSJS
A developer wants to review the available properties for using the DataExtensionField SOAP API object. Where could the developer find this information?
Open the Object Inspector in the Salesforce Developer Console
Developer Center at https://developer.salesforce.com
Contact Support and request the information
A developer is querying data from the _Bounce data view and storing it in a data extension. They have found that sometimes the fields SMTPBounceReason and SMTPCode exceed the 4000 character limits for each field as specified in the DE schema. After consulting with the original requestor, it was decided that they could simply store the first 4000 characters for each of those fields. Which SQL function could be used for this purpose?
RIGHT
FIRST
LEFT
A company has chosen to use the REST API for triggering 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?
ErrorDescription
OverallStatus
ErrorCode
A developer is working on cross-channel campaign functions for the email team at NTO. They are reviewing available APIs for the different Marketing Cloud applications to determine the most appropriate solution for each. Which application utilizes the REST API?
Automation Studio
Classic Content
Content Builder
Which aspect should a developer consider before creating a Server-to-Server Installed Package and associated API Integration in Marketing Cloud?
Using an Installed Package, APIs will have access to resources in all Business Units
Scope (Permissions) will be granted based on the User who is creating the Installed Package
Scope (Permissions) must be specifically granted when creating an API Integration component inside an Installed Package
A developer is troubleshooting why an API client ID and client Secret are authenticating yet failing to access data from a child business unit. What should be checked to validate the installed package can access the child business unit data?
The Installed Package has full Enterprise access to all available child business units
The Installed Package has access to the selected business unit
The account id and parent MID are included in the authorization call
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 column called 'PurchaseDate'. Contacts are identified in both data extension by a column called 'ContactKey', and the Orders data extension can contain many instances of the same subscriber. Which SQL keyword should the developer use to achieve the desired result?
INNER JOIN
OUTER JOIN
ORDER BY PurchaseDate ASC
A developer needs to know how many records are contained in a particular data extension. This will dictate what is displayed on a landing page. Which AMPscript function returns the number of rows in a specified data extension?
LookupRowCount
DataExtensionRowCount
RowCount
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?
Text
Number
Decimal(9,2)
Which action could the RaiseError AMPscript function be configured to perform?
Delete the subscriber record
Update the subscriber's status
Log the source of the error
Which AMPscript function returns the result of interpreted code within a code block and includes the result in the rendered content, where the code block is located?
V
Output
TreatAsContentArea
A developer wants to extract tracking data from the Market Activity in the user interface. Which option would be available to extract the data?
Automation Studio
Journey Builder
REST API
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. Which action should be configured?
File Drop Automation
Scheduled Automation
Dynamic File Import
A developer is configuring a new Marketing CLoud account and has decided to use a unique 10 digit integer as each customer's Contact Key. Which data type should be used when representing the value of the Contact Key?
Number
Decimal
Text
A developer built a complex dynamic email w3ith many data variants. Rather than create test data manually, they want to use a subset of live data to validate the dynamic aspects of the email. Which SQL function should be used to collect a representative sample from a larger data set?
HAVING
OVER
NTILE
NTO's account is configured with two child BUs: US and Global. The account has a data extension 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 be created in the US business unit to query all records on 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."?
Incorrect syntax; Query Activities are written in SOQL
MemberData should be prefixed with ENT
Query should check for a US value of 'True'
Query Activities cannot use the '' wildcard
A developer wants to populate a data extension with information about all emails deployed in the last seven days. The data extension needs to contain JobID, EventDate, and the counts of how many emai8ls were sent with each JobID. Which data view is required to gather this information?
Job
Sent
Journey
Subscribers
A developer wants to retrieve all records in the OrderDetails data extension which are associated with a particular customer. Which two AMPscript functions would return a suitable rowset? Choose 2.
LookupRows
LookupOrderedRows
Row
Lookup
Why would a developer use LookupRows instead of Lookup in AMPscript?
To return a complete rowset from the data extension
To stay at the limit of two Lookup calls in one email
To see how many rows are in a data extension
To access a data extension, as Lookup only targets lists
A developer needs to use the 'contacts/ route' of the REST API to update records in a data extension. What should the developer verify before making the API call?
Each contact should already exist in All Subscribers.
Journey Builder should be configured to use the data extension.
Contact Key should be equal to Subscriber Key in the underlying data extensions to unsure proper joining.
The data extension should be linked in an Attribute Group in Contact Builder
A developer wants to create a complex dynamic email with three different sections and four different possible content blocks in each section. The email will be sent to an audience of over one million contacts. Which best practice should the developer use to ensure a blank email will not be sent?
Send a test of every possible version using Test Send
Review every possible version using Subscriber Preview
Create separate emails for each version
Confirm every version has default content
NTO is using REST API to send emails to customers after a purchase. Which considerations should be taken regarding the token used in the API call?
Make a token API call and re-use the token until the next API call fails.
Make a token API call before each triggered send API call.
Make a token API call and re-use the token for that subscriber.
Make a token API call and re-use the token until the token expires.
A developer wants to create a JavaScript Web Token using a key from Key Management. What function should the developer use?
ContentBlockByKey()
GetJWTByKeyName()
RegExMatch()
GetJWT()
NTO developers want to use the Transactional Messaging API to send email receipts to customers. What is the first step required to send using the API?
POST to /messaging/v1/email/messages/ with clientId
Request a token using the v1/requestToken endpoint
Request a token using the v2/authorize endpoint
POST to /messaging/v1 with clientId and client secret
A marketer from Cloud Kicks wants to make sure no email from their welcome journey gets sent to their competitor at Rainbow Run. Which two best practices should the developer use when setting up the Send Email Activity in the welcome journey? Choose 2.
Create a Filter Activity in the journey that removes the Rainbow Run domain
Create a Suppression List with all possible email addresses from Rainbow Run
Create a data extension with the Rainbow Run domain for use with a Domain Exclusion
Create an Exclusion Script with t he Rainbow Run domain for use in the activity
Which AMPscript function group could most negatively impact send processing?
String functions
Data extension functions
Date Time
Math functions
A developer used LookupRows to retrieve data when building a dynamic email. What should be the next step before using this rowset within a FOR loop?
Use Row to return a specific row of the rowset
Set the rowset to a new array variable
Close the delimited AMPscript code block
Use RowCount to ensure the rowset contains data
A developer is troubleshooting the cause of incomplete results in the link tracking data for an email send. How should the RedirectTo AMPscript function be described as it relates to link tracking?
It ensures link href values containing AMPscript variables are recorded in tracking
It ensures link href values containing HTML bookmarks or anchors are recorded in tracking
It prevents link href values from getting recorded in tracking
It ensures static link href values are recorded in tracking
A developer is troubleshooting why a parent-level data extension cannot be accessed by a child business unit. What should the developer check to validate the data available can be accessed for child business unit queries?
The data extension is in the Shared Data Extensions folder and the query includes the ENT. prefix
The data extension is in the Shared Items root folder and is accessible to the child business unit
The data extension is in the Salesforce Data Extensions folder and is accessible to the child business unit
The data extension is in the Synchronized Data Extensions folder and the query includes the ENT. prefix
NTO's 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 records occur in the event a send is initiated directly to this Sendable Data Extension? Choose 2.
Records still in the suppression phase will only be excluded if manually specified during send time.
Records still in the suppression phase will be excluded from the sends.
Records that have already been deleted will be treated as new records.
Records that have been deleted will be excluded from sends indefinitely.
A developer needs to create a fully-branded CloudPage which 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?
Three
Two
None
One
Which activity is required before a compressed file can be imported?
Import File
Data Extract
Decompress File
File Transfer
NTO has created subscriber attributes including AGE under Profile Manager within their Enterprise 2.0 account. How would a developer retrieve subscribers over 30 years of age?
The data cannot be retrieved with a query
Create a filtered Group of subscribers with AGE more than 30
Create a query that references the _Subscribers data view
Create a query that references the _EnterpriseAttribute data view
An UpdateDE AMPscript function is used to update a column value in a data extension row when an email is sent. The email is 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?
No rows are updated
All 250,000 subscribers
400 subscribers who were sent the email
Only subscribers who exist in All Subscribers
A developer needs to add From Addresses to Marketing Cloud and wants to ensure they are verified before being used for sending. Which two routes would allow this? Choose 2.
POST /messaging/v1/domainverification
POST /messaging/v1/domainverification/bulk/insert
POST /messaging/v1/dataevents/domainverification
POST /messaging/v1/push/domain/verification
NTO 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 send speeds are not affected when inserting into the built-in send log?
20 fields or less
10 fields or less
No limit
5 fields or less
