Salesforce Marketing-Cloud-Developer Exam Practice Questions Answers

Salesforce Certified Marketing Cloud Developer (SP23) Questions and Answers

Question 1

A developer wants to aggregate monthly energy usage data over a four month period for each subscriber within an email. The monthly usage values are stored in variables for eachmonth in the following way:

How should the developer use AMPscript to generate the total?

Options:

SET @total - (@jan - 3fet - @mar @apr>

SET @total = AZD((@jan @feb) @mar) @apr)

SET @total - ADD(@jan,ADD(@feb,ADD(@mar,@apr)))

SET @total = (ADD(@jan,@feb), ADD(@mar, @apr))

Question 2

Northtrn Trail Outfitters 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?

Options:

ListSubscribers

ENT._Subscribers

_BusinessUnitUnsubscribes

.Subscribers

Question 3

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

Options:

2Lookup

Contact

RedirectTo

HTTPGet

Question 4

NTO wants use Personally Identifiable Information (PII) data to personalize email communications, but does not want to store PII data in Marketing Cloud. Which feature could they use topersonalize emails from an external data source?

Options:

External Objects

Tokenized Sending

Salesforce Shield

Single Sign-On

Question 5

Where can the SSJS Core library be used? Choose 2.

Options:

SMS messages

Marketing Cloud apps

Landing pages

Email messages

Question 6

NTO puts the word TEST at the beginning of the namefor each test email. Which query would return the subs who were sent those emails?

Options:

SELECT * FROM _Job J INNER JOIN _Sent S on J.EmailName LIKE 'TEST%'

SELECT * FROM _Job INNER JOIN _Sent on JobID = JobID WHERE EmailName LIKE 'TEST%'

SELECT * FROM_Job J INNER JOIN _Sent S ON.JobID = S.JobID WHERE J.EmailName LIKE 'TEST%'

SELECT * FROM _Job J INNER JOIN _Sent S on J.JobID = JobID = S.JobID WHERE J.EmailName = 'TEST%'

Question 7

A developer is notified the View Email As Web Page (VAWP) link, when clicked, displays the message, The system is temporarily unavailable. We apologize for any inconvenience. Please try again later.

What could be a possible cause for the error

Options:

The data in the data extensions used at the time of send was overwritten.

The email used at the time of send was deleted, updated, or moved.

The sender profile used at the time of send was overwritten.

The data extension used at the time of send was moved to another folder.

Question 8

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?

Options:

Platform.Function.InvokeRetrieve(); Platform.Function.ParseJSON(); Platform.Function.UpsertData();

Platform.Function.HTTPGet(); Platform.Function.ParseJSON(); Platform.Function.UpsertData();

Platform.Function.InvokeRetrievef); Platform.Function.Stringify(); Platform.Function.UpsertDE();

Platform.Function.HTTPGe(); Platform.Function.Stringify(); Platform.Response.Write();

Question 9

A developer is leveraging the SOAP API to dynamically display Profile and PreferenceAttributes in a custom profile center. Which method could be used to support the dynamic functionality?

Options:

Describe

Extract

Perform

Configure

Question 10

Customer data has been imported into a staging data extension andneeds to be normalized before adding into the master data extension. A text field named 'birthday' contains date values in various formats. Some of the values are valid dates, but some are not.

Which SQL keywords and functions could be used to write the query'' Choose 2 answers

Options:

CASE, ISDATE, CONVERT

WHERE, ISDATE, CONVERT

CASE, ISDATE, CAST

UPDATE, ISDATE, CONVERT

Question 11

A developer is troubleshooting why an API client Jd and chent_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?

Options:

The Installed Package has full Enterprise access to all available child business units

The Installed Package has access to the selected child business unit

The account id and parent MIDare included in the authorization call

Question 12

A developer wants to add an image to Content Builder via the API and retrieve the image's published URL. Which method should the developer use?

Options:

GET using the REST API/asset/v1/content/assets and parse the FileProperties parameter

Use the SOAP API to create a Porfoglio object and idenfity the Source property

POST to the REST API/asset/v1/content/categories and parse the Description parameter

POST to the REST API/asset/v1/content/assets and parse the FileProperties parameter

Question 13

Certification Aid uses Marketing Cloud Connect and wants to create a lead capture form on a landing page. When a customer submits the form, a Lead record should be created in Salesforce. Which scripting language can be used for this? Choose 2.

Options:

AMPscript to create Salesforce record, SSJS for form handling.

SSJS to create Salesforce record, AMPscript for form handling.

AMPscript for whole functionality.

SSJS for whole functionality.

Question 14

A developer wants to populate a data extension with the date of the most recent click for each subscriber. Which query would accomplish this?

Options:

SELECT TOP 1 c.SubscriberKey, c.eventDate FROM _Click c ORDER BY c.eventDate DESC

SELECT c.SubscriberKey, MIN (c.eventDate) AS eventDate FROM _Click c GROUP BY c.SubscriberKey

SELECT c.SubscriberKey, MAX(c.eventDate) AS eventDate FROM _Click c GROUP BY c.SubscriberKey

SELECT c.SubscriberKey, c.eventDate FROM_Click c WHERE c.IsUnique = 1

Question 15

Northern Trails Outfitters (NTO)has a sendable data extension with 1,500,000 contact records they want to delete.

Which step is required before deleting the contacts?

Options:

Query the records into a new sendable data extension and delete it

Navigate to Contact Builder and delete the dataextension

Divide the records in half and delete each resulting data extension

Navigate to Email Studio and delete the data extension

Question 16

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?

Options:

RIGHT

FIRST

LEFT

Question 17

NTO uses data extensions to manage the subscriber information usedfor their email sends, and those sends includes 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 updated usingan InsertDE() call if the record doesn't yet exist. Why would the developer receive an error stating the application cannot insert a duplicate value for the primary key in the data extension?

Options:

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

Question 18

A developer wants to configure an automation to import files placed on the SFTP shared by a customer's data vendor. The automation will start when a file matching a specific namingpattern is encountered in the Import folder. The first step of the automation is a File Import Activity referencing a substion string for the matching file. Which substituon string represents the name of the file?

Options:

%%FILENAME%%

%%TRIGGER_FILENAME%%

%%FILENAME_FROM_TRIGGER%%

%%FILENAME_FROM_IMPORT%%

Question 19

Which of the following statements are correct concerning Contacts and Subscribers? Choose 2.

Options:

A Contact is subscribed to any channel.

Each Contact is also a Subscriber.

Each Subscriber is also a Contact.

A Contact is subscribed to a specific channel.

Question 20

From which business unit could the Contact Delete feature be used within an Enterprise 2.0 account?

Options:

Any business unit

The Parent account

Only in Agency accounts

The business unit where the contactwas introduced

Question 21

A developer is troubleshooting why a parent-level data extension cannot be accessed by a child business unit.

What should the developer check to validatethe data available can be accessed for child business unit queries?

Options:

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

Question 22

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:

The Data Extension must be in an Attribute Group.

The Data Extensionmust be in a Population.

The Data Extension must be sendable.

The Data Extension must be created in Email Studio.

Question 23

A developer uses an API to send data to a Marketing Cloud data extension once every fiveminutes using the REST API. They notice data does not always write to the data extension, leading to data loss.

Which three best practices are recommended to avoid this issue? Choose 3 answers

Options:

In case of 'Not Authorized' errors, request a new Access Token and attempt the call again.

In case of Server errors, request a new Access Token before each request.

In case of Server errors, ensure the Server is available and attempt the call again.

Use Username and Password authentication instead of oAuth client ID and client secret.

Store the expiry of the access token to ensure a new token is requested if the old one is invalid.

Question 24

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?

Options:

INNER JOIN

OUTER JOIN

ORDER BY PurchaseDate ASC

Question 25

A developer wants to create a JavaScript Web Token using a key from Key Management.

What function should the developer use?

Options:

ContentBlockByKey()

GetJWTByKeyName()

RegExMatch()

GeUWT()

Question 26

A developer initiated a batch delete of Contacts in Contact Builder due to an import error during implementation. There are over two million records that need to be deleted.

Which two factors should be considered when batch deleting large volumes of contacts?Choose 2 answers

Options:

Up to one million records can be deleted in each batch.

To more quickly remove contact information, use the suppression period length of 14.

The deletion process supersedes other automated account activities.

The suppression status does not show for individual contacts until the entire batch processes.

Question 27

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 functionreturns the number of rows in a specified data extension?

Options:

LookupRowCount

DataExtensionRowCount

RowCount

Question 28

A developer wants a link to be dynamic based on subscriber attributes. Rather than create numerous links, the developer uses AMPscript to set the link's value as a variable. The variable will be used within the tag. What should thedeveloper do within the tag to ensure clicks are tracked for the variable? Choose 2

Options:

Wrap the variable in a RedirectTo function

Ensure the Conversion attribute is 'true'

Wrap the variable in a v function

Include a variable for the Alias attribute

Question 29

A particular data extension need to be configured to store six months of data.

How shoulddata retention be added to the data extension in Email Studio?

Options:

Run a query to overwrite the rows with six months of data

Import a file to overwrite the rows with six months of data

Create a new data extension that includes data retention settings

Update the data extension configuration to include data retention settings.

Question 30

A developer needs to configure an Email Send Logging Data Extension for a new business unit. Which option should be used?

Options:

Create and ensure it has the name "Send Log"

Salesforce Support should create the data extension

Create from a copy of an existing Send Log in another business unit

Create using the SendLog Data ExtensionTemplate

Question 31

A marketer is sending an email with dynamic content contained in a series of conditionals.

Which AMPscript function should be used to track the different versions of the content within the email?

Options:

ContentArea

BeginImpressionRegion

ContentAreaByName

ContentBlockName

Question 32

What can be created in Attribute Groups within Contact Builder? Choose 2.

Options:

Data Extensions

Relationships

Populations

Attribute Groups

Question 33

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

Options:

_Subscribers

_AllSubscribers

_Click

Question 34

NTO wants to exclude sending an email at send time to those with a record on the 'Exclude' Data Extension. The primary key on this data extension is Subscriber Key.

How would a developer write the Exclusion Script?

Options:

Lookup ('Exclude','EmailAddress','SubscriberKey',SubscriberKey)

Lookup ('Exclude','SubscriberKey', 'EmailAddress', emailddr_)

Rowcount (LookupRows('Exclude',SubsciberKey,_SubscriberKey) >0

Rowcount (LookupRows('Exclude','SubscriberKey,_SubscriberKey) >1

Question 35

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

Options:

Ends With operator

%%MMMMdd%%

%%Month%%%%Day%°/o

Begins With operator

Question 36

A developer used LookupRowsto retrieve data when building a dynamic email.

What should be the next step before using this rowset within a FOR loop?

Options:

Use Row to return a specific row of the rowset

Set the rowset to a new array variable

Close the delimited AMPscrlpt Code Block

Use RowCount to ensure the rowset contains data

Question 37

Clock Kicks would like to encrypt and storeform data submitted from a CloudPage in a data extension using AMPscript. Which three encryption options could be used when creating a new key in Key Management? Choose 3

Options:

SAML

Asymmetric

RSA

Salt

Symmetric

Question 38

A developer is building an integration with theMarketing Cloud API. Which configuration should be used for the API integration component in the associated Installed Package?

Options:

Select the minimum required scope for the integration

Select all available options to enable package reuse for the futureintegrations

Select the 'Require Secret for Web Flor' option

Select the 'Admin-approved users are pre-authorized' option under Permitted Users.

Question 39

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?

Options:

Output

TreatAsContentArea

Question 40

A developer wants to build an email that dynamically populates the physical address of a company's locations using the variable ©address. The deployment goes to millions of subscribers and the developer wants the fastest possible performance.

Which AMPscript solution should be recommended?

Options:

%%[ SET @address = field(Lookcup("Building_Locations"/ "Address", "Id",@Id), "Address") ]%%

%% [ SET @address - field(Row(LookupRows("Building_Locations", "Address","Id"), 1),"Address") ]%%

%%; SET @address = LookupRows(Building_Locations", "Address", "Id") ]%%

%: SET @address = Lookup(''Building_locations'', Address'', ''id''@id) ] %%

Question 41

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?

Options:

Base64Decode

ParseJSON

CreateObject

Stringify

Question 42

Which action could the RaiseError AMPscript function be configured to perform?

Options:

Delete the subscriber record

Update the subscriber's status

Log the source of theerror

Question 43

NTO wants to trigger a receipt email via the SOAP API whenever a customer makes a purchase. Their developer wrote the call using the TriggerSendDefinition object and the Create method, but noemails have been sent during his initial testing. Which object and method should the developer use?

Options:

TriggerSend object and Update method

TriggerSend object and Create method

TriggerSendDefinition object and Execute method

TriggerSendDefinitionobject and Update method

Question 44

A developer needs to add From Addresses to Marketing Cloud and wants to ensure they are verified before being used for sending.

Which tworoutes would allow this?

Choose 2 answers

Options:

POST /messaging/vl/domainverification

POST /messaging/vl/domainverification/bulk/insert

POST /messaging/vl/dataevents/domainverification

POST/messaging/vl/push/domain/verification

Question 45

A developer receives a 401 Unathorized HTTP status message from a REST API request. What is the reason for this error?

Options:

The account lacks theprivileges necessary to perform the request

The access token was not found in the request, or it is invalid or expired

OAuth is not supported for the requested resource

API requests are temporarily blocked due to too many concurrent requests.

Question 46

A developer needs to configure a process that can store encrypted data from Marketing Cloud as a file on an external server. What steps shouldthe developer take?

Options:

Data Extract > File Transfer with Marketing Cloud Public Key

Create PGP Key > Data Extract > File Transfer with PGP checked

Shield Platform Encryption is required for encrypted data export

Data from Marketing Cloud cannot beencrypted

Question 47

A customer wants a list of subscribers who were sent an email within the past 12 months.

How shouldthis request be completed?

Options:

Create a measure with criteria sent_date is after today minus 565 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

Question 48

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?

Options:

SubscriberKey and JobID

SubscriberID and BatchID

EmailAddress and JobID

SubscriberKey and BatchID

Question 49

Which of the followingis a valid comment within an AMPscript code block? Choose 1.

Options:

--comment

// comment

- comment -->

/* comment */

Question 50

Certification Aid wants to import an encrypted CSV file from the Marketing Cloud Enhanced FTP server. Which two File Transfer activities are needed to achieve this? Choose 2.

Options:

To decryptthe import file on the Enhanced FTP server.

To move the import file from the Safehouse to Marketing Cloud.

To decrypt the import file on the Safehouse.

To move the import file from the Enhanced FTP server to the Safehouse

Question 51

Which activity is required before a compressed file can be imported?

Options:

Import File

Data Extract

Decompress File

File Transfer

Question 52

A sendable data extension with a text field named 'Balance' contains the value S6.96 fora particular record. The following AMPscript statement is included in an email:

IF (Balance > 6.00) THEN

SET @Result = 'Balance is more than $6.00

ENDIF

Why would this IF statement yield unintended results?

Options:

The operands are not the same data type.

The comparison should use the < operator.

Balance is a protected keyword.

Double quotes should be used instead of single quotes.

Question 53

A developer is building a landing page in Marketing Cloud and an email with a Call-To page will display personal information about the subscriber.

In which way could the developer create the CTA link?

Options:

Use the AMPscript CloudPagesURLfunction.

Append EmailAddress to the URL as an encoded parameter.

Append SubscnberKey to the URL as an encoded parameter.

Question 54

Northern Trail Outfitters (NTO) wants to determine the best identifier for subscribers across all channels.

What should be recommended5

Options:

Contact Key

Mobile ID

Email Address

Subscriber ID

Question 55

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?

Options:

Each contact should alreadyexist 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 ensure proper joining.

The data extension should be linked in an AttributeGroup in Contact Builder.

Question 56

How often should a developer request a new token when making multiple API calls in v1?

Options:

When changing routes/objects

Before every new call

Once an hour

Every 15 minutes

Question 57

Which programming language should be used in email messages? Choose 1.

Options:

AMPscript only

Both

Either AMPscript or SSJS

SSJS only

Labour Day Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Salesforce Marketing-Cloud-Developer Dumps

Salesforce Certified Marketing Cloud Developer (SP23) Questions and Answers

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options: