Labour Day Special Limited Time Flat 70% Discount offer - Ends in 0d 00h 00m 00s - Coupon code: 70spcl

Salesforce Marketing-Cloud-Developer Salesforce Certified Marketing Cloud Developer (SP23) Exam Practice Test

Page: 1 / 20
Total 195 questions

Salesforce Certified Marketing Cloud Developer (SP23) Questions and Answers

Question 1

A developer, who is new to Marketing Cloud, needs to design a landing page for a new customer. They choose to use Server-Side JavaScript (SSJS) due to their extensive knowledge of JavaScript from previous projects.

Which two features would the developer be able to leverage in their Server-Side code? Choose 2 answers

Options:

A.

Wrapping of AMPscript inSSJS code

B.

Direct modification of the DOM

C.

External Libraries to extend functionality

D.

Include Try/Catch blocks within the code

Question 2

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

Options:

A.

Data Extensions

B.

Relationships

C.

Populations

D.

Attribute Groups

Question 3

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?

Options:

A.

File Drop Automation

B.

Scheduled Automation

C.

Dynamic File Import

Question 4

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:

Question # 4

Which subject line will be used at the time of deployment?

Options:

A.

Enjoy 10% off today

B.

Enjoy 15% off today

C.

Enjoy 20% off today

Question 5

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:

A.

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

B.

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

C.

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

D.

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

Question 6

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

Question 7

How many month of data can a developer query from the tracking data views (_Sent, _Open, _Click)?

Options:

A.

Six Months

B.

One Month

C.

12 Months

D.

There is no limit

Question 8

A marketing director at Northern Trail Outfitters wants to analyze the Send, Click, and Open Data Views. Which activities should the developer build togenerate the data before transferring it to the SFTP?

Options:

A.

Query Activity > Tracking Extract

B.

Data Views Extract > Filter Activity

C.

Filter Activity > Data Extension Extract

D.

Query Activity > Data Extension Extract

Question 9

A developer has a text field in a data extension they want to format using the FormatCurrency AMPscript function. Which two values would return $6.96? Choose 2

Options:

A.

6,961

B.

6.96

C.

$6.96

D.

6.96

Question 10

Which two AMPscript HTTP functions allow an OAuth token to be passed in a header?

Choose 2 answers

Options:

A.

HTTPPost

B.

HTTPGet

C.

HTTPGet2

D.

HTTPPost2

Question 11

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:

A.

External Objects

B.

Tokenized Sending

C.

Salesforce Shield

D.

Single Sign-On

Question 12

A marketer is planning a weekly promotionalsend.

Which two types of data extensions could be sent to?

Choose 2 answers

Options:

A.

Synchronized Data Extension

B.

Sendable Data Extension

C.

Salesforce Data Extension

D.

Send Log Data Extension

Question 13

A developer is using the REST Authorization Service to obtain an OAuth access token. Which method should be used to include the access token in the API requests

Options:

A.

Include the header x-access-token: your_access_token

B.

Include as a query parameter access_token=Y0UR_ACCESS_TOKEN

C.

Include the header Authorization: Basic your_access_token

D.

Include the header Authorization: Bearer YOUR ACCESS TOKEN

Question 14

A developer uses the messageDefinitionSends REST API endpoint to send a triggered send email. This method returns a 202 (success) response code. How could the developer validate if the email was successfully sent?

Options:

A.

Use the messageDefinitionSend/key:(key)/deliveryRecords REST endpoint with GET method

B.

The202 response code indicates the message was sent successfully; no further action is required.

C.

Use the validateEmail REST resource with POST method to obtain the email delivery details from the request.

D.

Confirm the record was successfully inserted into the associated Triggered Send Data Extension.

Question 15

A developer wants to include a comment within an AMPscript code block for the benefit of other developers who will be reviewing the code.

Which syntax should the developer use?

Options:

A.

< !- This is a comment

B.

// This is acomment

C.

-- This is a comment

D.

/" This is a comment */

Question 16

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 caapptld. 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?

Options:

A.

apptld)»%%" readonly>

B.

C.

D.

Question 17

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

Options:

A.

LookupRows ('Ent. Inventory*, 'true', 'InStock')

B.

LookupRows ('Ent. Inventory*, itemName, 'InStock', 'true')

C.

LookupRows ('Ent. Inventory*, 'InStock', 'true', )

D.

LookupRows ('Inventory*, 'InStock' 'true',)

Question 18

A developer started a Contact Delete process that is now complete.

In which twoplaces would the Contact Delete process remove data? Choose 2 answers

Options:

A.

Non-Sendable Data Extensions

B.

Import Files on the Enhanced SFTP

C.

Sendable Data Extensions

D.

Mobile Lists

Question 19

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

How shouldthis request be completed?

Options:

A.

Create a measure with criteria sent_date is after today minus 565 days

B.

Run a tracking extract via the SOAP API

C.

Query against the Job and Sent data views

D.

Locate the email sends in the Tracking tab within Email Studio

Question 20

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:

A.

2Lookup

B.

Contact

C.

RedirectTo

D.

HTTPGet

Question 21

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

B.

MemberData should be prefixed with ENT

C.

Query should check for a US value of True'

D.

Query Activities cannot use the " wildcard

Question 22

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

D.

Storecredentials in a key management system (KMS)

Question 23

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:

A.

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

B.

The Installed Package has access to the selected child business unit

C.

The account id and parent MIDare included in the authorization call

Question 24

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:

A.

Select the minimum required scope for the integration

B.

Select all available options to enable package reuse for the futureintegrations

C.

Select the 'Require Secret for Web Flor' option

D.

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

Question 25

A field value returned from a DE lookupcontains a tab-delimited list of values. Which AMPscript function could easily determine if a specific text string exist anywhere in the list?

Options:

A.

Substring

B.

BuildRowSetFromString

C.

IndexOf

D.

Length

Question 26

Certification Aid wants to create Contacts in Marketing Cloud via API calls. Which API should be used for this? Choose 2.

Options:

A.

POST /contacts/v1/contacts route

B.

SOAP API

C.

REST API

D.

Contact object

Question 27

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

Options:

A.

SET @firstName = [First Name]

B.

SET @firstName = %%First Name%%

C.

SET @firstName = attributeValue (''First Name'')

D.

SET @firstName = ''First Name'']

Question 28

A developer wants to use the Marketing Cloud SOAP API to retrieve which subscribers were sent a particular email. Which SOAP API object should be used?

Options:

A.

Send

B.

ListSend

C.

SentEvent

D.

LinkSend

Question 29

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:

A.

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

B.

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

C.

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

D.

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

Question 30

A developer wants to populate a data extension with information about all emails deployed in the last seven days. The data extension needsto contain JobID, EventDate, and the counts of how many emails were sent with each JobID.

Which data view is required to gather this information?

Options:

A.

Job

B.

Sent

C.

Journey

D.

Subscribers

Question 31

A developer is using the legacy endpoint www.exacttargetapis.com and hasbeen asked to switch to Tenant Specific Endpoints (TSEs). What is a benefit of switching to TSEs?

Options:

A.

A longer lasting OAuth token

B.

API calls will no longer fail

C.

Gain access to TSE-specific REST routes

D.

Improved API performance

Question 32

Northern Trail Outfitters uses a number to uniquely identify contacts across different marketing channels.

Which two actions should the developertake to ensure the contacts relate across channels in Marketing Cloud when working with the data model?

Choose 2 answers

Options:

A.

store the numeric unique identifier value as a Text data type In data extensions.

B.

Link the numeric field value to the Contact IDin Attribute Groups in Contact Builder.

C.

Use a unique identifier spec fie to each channel and automatically connect then-..

D.

Create Attribute Groups linking the unique identifier to the Contact for each channel.

Question 33

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

Options:

A.

The account lacks theprivileges necessary to perform the request

B.

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

C.

OAuth is not supported for the requested resource

D.

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

Question 34

Adeveloper is working on cross-channel campaign functions for the email team at Northern Trail Outfitters. 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?

Options:

A.

Automation Studio

B.

Classic Content

C.

Content Builder

Question 35

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

Question 36

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:

A.

SubscriberKey and JobID

B.

SubscriberID and BatchID

C.

EmailAddress and JobID

D.

SubscriberKey and BatchID

Question 37

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

Options:

A.

A Contact is subscribed to any channel.

B.

Each Contact is also a Subscriber.

C.

Each Subscriber is also a Contact.

D.

A Contact is subscribed to a specific channel.

Question 38

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:

A.

TriggerSend object and Update method

B.

TriggerSend object and Create method

C.

TriggerSendDefinition object and Execute method

D.

TriggerSendDefinitionobject and Update method

Question 39

A developer is managing the data model programmatically and needs to access Attribute Group schema via the API. Which API should the developer use?

Options:

A.

Bulk

B.

SOAP

C.

XML

D.

REST

Question 40

A developer needs to write AMPscript to ensure the expiration date on a coupon is the last day of the month. What would produce the desired result?

Options:

A.

Find the first day of next month and subtract one day

B.

Use the date format stringfor last day of month within FormatDate

C.

Add one month using DateAdd to now

D.

Add 30 days using DateAdd to now

Question 41

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

Options:

A.

Delete the subscriber record

B.

Update the subscriber's status

C.

Log the source of theerror

Question 42

A developer wants to create a CloudPage which is linked from an email. %%[SET @point = RequestParameter(x) SET @value = 5 IF Length(@point) > 1 THEN SET @value = 1 ELSEIF Length(@point)>2 THEN SET @value = 2 ELSEIF Length(@point) >3 THEN SET@value = 3 ELSEIF Length(@point) >4 THEN SET @value = 4 ENDIF]%% Which is the expected value of @value if x = 'Tacos'?

Options:

A.

3

B.

1

C.

5

D.

4

Question 43

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:

A.

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

B.

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

C.

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

D.

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

Question 44

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:

A.

Use the AMPscript CloudPagesURLfunction.

B.

Append EmailAddress to the URL as an encoded parameter.

C.

Append SubscnberKey to the URL as an encoded parameter.

Question 45

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.

Options:

A.

Personalization Builder API

B.

Event Notification API

C.

Transactional Messaging API

D.

Journey Builder API

Question 46

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?

Options:

A.

mobilenumbers

B.

phonenumbers

C.

emailaddress

D.

subscribers

Question 47

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.

Question 48

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:

A.

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

B.

Navigate to Contact Builder and delete the dataextension

C.

Divide the records in half and delete each resulting data extension

D.

Navigate to Email Studio and delete the data extension

Question 49

Which SSJS library can be used in email messages? Choose 1.

Options:

A.

Both

B.

Platform

C.

None

D.

Core

Question 50

A developer wants to retrieve a row of data from a data extension using the SOAP API. Which API Object should be used for this call?

Options:

A.

DataExtensionField

B.

DataExtension

C.

DataExtensionObject

D.

Row

Question 51

A developer wants to delete a batch of subscribers from Marketing Cloud. The developer performs a Contact Delete on a batch of records in a data extension in Contact Builder. Which scenario would cause subscriber records to remain in the data extension?

Options:

A.

Sendable data extension with SubscriberKey and EmailAddress fields

B.

Non-sendable data extension with SubscriberKey field

C.

Contact Delete process does not delete rows from data extensions

D.

Sendable data extension with SubsciberKey field

Question 52

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?

Options:

A.

Send a test of every possible version using Test Send

B.

Review every possible version using Subscriber Preview

C.

Create separate emails for each version

D.

Confirm every version has default content

Question 53

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.

Question 54

A developer created a landing page in CloudPages which return unique content when subscriber data is located on a related data extension. The developer does not know if all subscribers have rows in the related data extension, and want default content to render if no subscriber data is found on the related data extension. Which best practice should the developer follow to control the unique and default content?

Options:

A.

Use the RowCount function and an IF statement

B.

Use the Lookup, Row and Field functions

C.

Use the LookupOrderRows and Row functions

D.

Use the DataExtensionRowCount function

Question 55

A developer identified a use case where a triggeredsend of an email is needed. The developer already successfully set up authentication with a Client ID and Client Secret has used them in several REST calls. When the REST call is made, a "401 Unauthorized" error is returned. What is the first thing the developer should check?

Options:

A.

The send permissions have been granted for the Client ID and Client Secret within Installed Packages.

B.

The email interaction has been started

C.

The automation permissions have been granted for the Client ID and Client Secret within Installed Packages.

D.

The email interaction has been published.

Question 56

A developer wants to include an AMPscript if/else statement in an email to satisfy the condition "if the subscriber's tier is not premier then display heading encouraging them to upgrade." The tier value has already been set as variable named @level. How should the developer write this AMPscript conditional statement?

Options:

A.

%%[IF @level == 'premier' THEN SET @message = You are premier member

B.

" ENDIF IF @level == 'premier' THEN SET @message = 'Upgrade to premier now

C.

'" ENDIF]%% %%=v(message)=%%%%=IF(@level IS 'premier', Upgrade to premier now! You are a premier member%%=IIF(@level = 'premier', 'You are a premier member!', Upgrade to premier now!

D.

%%=IIF @level == premier, You are a premier member" Upgrade to premier now!

E.

%%IF(@level == 'premier') THEN 'Upgrade to premier now!' ELSE 'You are a premier member' ENDIF]%%

Question 57

A developer receives Error Code 5 when performing a SOAP API call. The error states: "Cannot Perform 'Post' on objects of type 'SentEvent'".

What could be the issue?

Options:

A.

SOAP does not support POST; useREST

B.

The authentication token has expired.

C.

It may be a temporary network issue.

D.

'SentEvent' is not able to be updated using SOAP.

Question 58

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'

Options:

A.

Text

B.

Number

C.

Decimal(9,2)

Page: 1 / 20
Total 195 questions