Salesforce Marketing-Cloud-Developer today updated questions

Salesforce Certified Marketing Cloud Developer (SP23) Questions and Answers

Question 1

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:

Include the header x-access-token: your_access_token

Include as a query parameter access_token=Y0UR_ACCESS_TOKEN

Include the header Authorization: Basic your_access_token

Include the header Authorization: Bearer YOUR ACCESS TOKEN

Question 2

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 3

A developer is making an API REST call to trigger an email send. An accesstoken is used to authenticate the call.

How long are Marketing Cloud v1 access tokens valid?

Options:

Access tokens expire after 24 hours.

REST calls do not require an access token.

Each API call requires a new access token.

Access tokens expire after one hour.

Question 4

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 5

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:

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

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

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

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

Question 6

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 7

A developer wants to write a query to compile data originating from an HTML form so it can be exported in CSV format. However, the source data extension may containline breaks within the Comments field, which makes it difficult to read and sort the resulting CSV.

Which SQL functions could be used to change each line break to a single space?

Options:

REPLACE and CHAR

FORMAT and SPACE

LTRIM and RTRJM

REPLICATE and NCHAR

Question 8

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

Options:

POST /contacts/v1/contacts route

SOAP API

REST API

Contact object

Question 9

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:

Non-Sendable Data Extensions

Import Files on the Enhanced SFTP

Sendable Data Extensions

Mobile Lists

Question 10

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 longer lasting OAuth token

API calls will no longer fail

Gain access to TSE-specific REST routes

Improved API performance

Question 11

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 12

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:

Sendable data extension with SubscriberKey and EmailAddress fields

Non-sendable data extension with SubscriberKey field

Contact Delete process does not delete rows from data extensions

Sendable data extension with SubsciberKey field

Question 13

The Contact Delete feature can be used within an Enterprise 2.0 account from which business unit?

Options:

Only in Agency accounts

The Parent account

Any business unit

The business unit where the contact was introduced

None of these

Question 14

A developer wants to create a Synchronized Data Extension containing Lead data from Sales Cloud. They only want to include record which contain a phone number. Each of the following flied 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?

Options:

ValidPhone

Phone

ContactType

PhoneExists

Question 15

When appending data to links via Web Analytics Connector, which parameter should be used to track subscriber behavior?

Options:

Email Address

Contact Key

Subscriber Key

Subscriber ID

Question 16

A developer wants to use the RaiseError Ampscript function when a subscriber does not have the necessary data to build an email. Which two outcomes are possible using this function? Choose 2 answer

Options:

The send fails

The email is not sent to the particular subscriber

An error message is sent to the From Address used in the email

The send is retried

Question 17

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?

Options:

/interaction/v1/interactions

/interaction/v1/events

/interaction/v1/eventDefinitions

/contacts/v1/contactEvents

Question 18

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 19

Certification Aid created a journey and event definition in Marketing Cloud. Which of the following resources are relevant to inject Contacts into the journey using the REST API? Choose 2.

Options:

POST/eventDefinitions/key:{key} or /eventDefinitions/{id}

POST /interaction/v1/events

POST /interaction/v1/interactions/contactentry

GET /eventDefinitions/key:{key}

Question 20

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

Options:

Both

Platform

None

Core

Question 21

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 22

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

Options:

Six Months

One Month

12 Months

There is no limit

Question 23

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 24

A developer wants to create an HTML table where rows will alternate background colors between white and red.The developer does not know how many rows will be sent within each email, and decides to use a loop and assigns the RowCount() of the table rows to the variable @numerator. What is the recommended AMPscript logic to determine the background color of each table row within the loop?

Options:

%%[IF DIVIDE(@numerator,2) =1 THEN SET @color = 'Red' ELSE SET @color = 'White' ENDIF]%%

%%[IF SUBSTRING(DIVIDE(@numerator,2),1) = 1 THEN SET @color = 'Red' ELSE SET @color = 'White' ENDIF]%%

%%[IF @numerator/2 = 1 THENSET @color = 'Red' ELSE SET @color = 'White' ENDIF]%%

%%[IF MOD(@numerator,2) = 1 THEN SET @color = 'Red' ELSE SET @color = 'White' ENDIF]%%

Question 25

Contact Builder can be used to create a relational model of an organization's data within Marketing Cloud. Which three factors should be taken into consideration when preparing data to be used in Contact Builder? Choose 3 answer

Options:

Assigningdata relationships and primary keys across all channels

Verifying data address marketing needs

Verifying all data extensions have a sendable value

Verifying each data extension has the required Email Address field populated

Normalizing data toreduce redundancy

Question 26

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

Options:

Attribute

TriggerSendDefinition

Contact

Subscribers

Question 27

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:

Bulk

SOAP

XML

REST

Question 28

A developer identified duplicate contacts and wants to delete roughly 10 million subscribers usingContact Delete. How could the process be expedited?

Options:

Change the Suppression value to a larger value

Delete any unnecessary Sendable Data Extensions

Manually delete subscribers in All Contacts

Stop the current delete process and delete smaller groups

Question 29

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 30

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 31

A developer wants to build an audience by identifying subscribers who opened a specific email. Which query should the developer use?

Options:

SELECT * FROM _Open WHERE ListID = '1234'

SELECT * FROM_Open WHERE JobID = "1234"

SELECT SubscriberID FROM _Open WHERE JobID = "1234"

SELECT SubscriberKey FROM _Open WHERE JobID = '1234'

Question 32

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 33

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:

Query Activity > Tracking Extract

Data Views Extract > Filter Activity

Filter Activity > Data Extension Extract

Query Activity > Data Extension Extract

Question 34

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 35

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 36

Certification Aid wants to add records to a Data Extension using the SOAP API. Which object can be used for this? Choose 1.

Options:

DataExtensionObject object

Subscriber object

Attribute object

DataExtension object

Question 37

What parameter should a developer include to ensure the MobileConnect Contactis tied to the Email Contact when making a QueueMO call for an existing email subscriber?

Options:

mobilenumbers

phonenumbers

emailaddress

subscribers

Question 38

How can subscriber, system, and sendable Data Extension attributes be referenced for content personalization using SSJS? Choose 1.

Options:

Question 39

A developer identified duplicate contactsand initiated a Contact Delete process for 10 million subscribers. How could the process be expedited?

Options:

Change the Suppression value to a larger value

Manually delete subscribers in All Contacts

Stop current delete process and delete smaller groups

Delete any unnecessary Sendable Data Extensions

Question 40

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 41

A developer wants to expand thefunctionality 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?

Options:

Var.Get("subKey");

Variable.GetTValue (''@subKey") ;

Variable.SetValue("subKey", "Value");

Var.Retrieve("@subKey");

Question 42

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 43

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

Options:

AMPscript only

Both

Either AMPscript or SSJS

SSJS only

Question 44

A marketer from Cloud Kicks wants to make sure no email from their welcome journey getssent 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 answers

Options:

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 the Rainbow Run domain for use In the activity

Question 45

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 46

A company need to retrieve a large number of rows from a DE via the API. Which two solutions would optimize the performance? Choose2

Options:

Use a SimpleFilterPart to retrieve small sets of relevant data.

Use AMPscript API functions on a CloudPage

Use the ContinueRequest feature

Use the REST API instead of the SOAP API

Question 47

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.

Which encryption method should NTO use?

Options:

Encrypted Data Sending

Field-Level Encryption

Tokenized Sending

Transparent Data Encryption

Question 48

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 49

A developer wants to design a custom subscription center in CloudPages. The developer prefers to code in AMPscript, but is also skilled in Server-Side JavaScript. While the developer is confident their code is of high quality, they would still like to handle unexprected errors gracefully to ensure the best user experience. Whichfeature should handle this scenario?

Options:

Wrapping the code in a Server-Side JavaScript Try/Catch block

Using RaiseError AMPscript function when an error occurs

Marketing Cloud automatically handles any error scenario that may occur

Wrapping thecode in a AMPscript HandleError block

Question 50

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?

Options:

No rows are updated

All 250,000 subscribers

400 subscribers who were sent the email

Only subscribers who exist in All Subscribers

Question 51

Which AMPscript function group could most negatively Impact send processing?

Options:

String functions

Data extension functions

Date Time

Math functions

Question 52

Certification Aid wants to implement a custom profile center using SOAP API. Which SOAP API methods are relevant to achieve this? Choose 2.

Options:

Extract

Describe

Update

Configure

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:

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 54

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:

Send

ListSend

SentEvent

LinkSend

Question 55

In which three ways should a developer optimize a query activity if it is currently timing out? Choose 3

Options:

Use intrisic functions in the WHERE clause

Use SELECT * to include all fields

Use Primary key(s) on fields used in joins

Use intermediate tables to stage data

Only update records that have changed since last execution

Question 56

Why woulda developer use LookupRows Instead of the Lookup AMPscript function?

Options:

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

Load More Marketing-Cloud-Developer Questions

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

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

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:

Explanation:

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: