March Special Sale Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 713PS592

Marketing-Cloud-Developer Salesforce Certified Marketing Cloud Developer (WI24) Questions and Answers

Questions 4

A developer built a complex dynamic email with 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?

Options:

A.

HAVING

B.

OVER

C.

NTILE

Buy Now
Questions 5

Certification Aid wants to encrypt data stored in Marketing Cloud. It is fine if unencrypted fields arevisible to Marketing Cloud and Salesforce users, but the underlying data should be encrypted at rest to prevent physical data theft. Which encryption method should be chosen? Choose 1.

Options:

A.

Tokenized Sending

B.

Asymmetric Encryption

C.

Transparent Data Encryption

D.

Field-Level Encryption

Buy Now
Questions 6

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?

Options:

A.

JobID

B.

ListID

C.

Unsub Reason

D.

SubscriberKey

Buy Now
Questions 7

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:

A.

AMPscript to create Salesforce record, SSJS for form handling.

B.

SSJS to create Salesforce record, AMPscript for form handling.

C.

AMPscript for whole functionality.

D.

SSJS for whole functionality.

Buy Now
Questions 8

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:

A.

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

B.

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

C.

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

D.

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

Buy Now
Questions 9

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.

Buy Now
Questions 10

A customer wants to export send data to their SFTP. Which two automationswould accomplish this? Choose 2

Options:

A.

Tracking Extract

B.

Tracking Extract > File Transfer

C.

Query (Data Views) > Data Extension Extract > File Transfer

D.

Query (Data Views) > File Transfer

Buy Now
Questions 11

Northern Trail Outfitters (NTO) uses a numeric identifier for Subscriber Key. Customer data is stored in a data extension with the Subscriber Key set as a Primary Key.

Which step is required for NTO when creating relationships for this data extension in Data Designer'

Options:

A.

Link the Contact ID to the Subscriber Key when creating the relationship

B.

Use a one-to-one cardinality when creating the relationship

C.

Link the Contact Key to the Subscriber's email address when creating the relationship

D.

Set Subscriber Key as a text data type before linking the data extension to Contact Key

Buy Now
Questions 12

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:

A.

Access tokens expire after 24 hours.

B.

REST calls do not require an access token.

C.

Each API call requires a new access token.

D.

Access tokens expire after one hour.

Buy Now
Questions 13

Northern Trail Outfitters' legal team is concerned about the daily import process that brings in subscribers to a Sendable Data Extension, even when records have already been targeted for deletion.

Which two true expected behaviors for these recordsoccur in the event a send is initiated directly to this Sendable Data Extension?

Choose 2 answers

Options:

A.

Records still in the suppression phase will only be excluded if manually specified during send time.

B.

Records still in the suppression phase will beexcluded from sends.

C.

Records that have already been deleted will be treated as new records.

D.

Records that have been deleted will be excluded from sends Indefinitely.

Buy Now
Questions 14

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

Buy Now
Questions 15

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:

A.

REPLACE and CHAR

B.

FORMAT and SPACE

C.

LTRIM and RTRJM

D.

REPLICATE and NCHAR

Buy Now
Questions 16

Certification Aid created following AMPscript code: %%[ SET @var1 = 10 SET @var2 = 20 SET @var3 = 30 ]%% How can the three variables be summed up to evaluate to 60? Choose 1.

Options:

A.

SET @total = Sum(@var1, @var2, @var3)

B.

SET @total = Add(@var1, Add(@var2, @var3))

C.

SET @total = Add(@var1, @var2, @var3)

D.

SET @total = @var1 + @var2 + @var3

Buy Now
Questions 17

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

Buy Now
Questions 18

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

Options:

A.

Change the Suppression value to a larger value

B.

Manually delete subscribers in All Contacts

C.

Stop current delete process and delete smaller groups

D.

Delete any unnecessary Sendable Data Extensions

Buy Now
Questions 19

How can SSJS variables be referenced for content personalization? Choose 1.

Options:

A.

variableName

B.

C.

D.

Buy Now
Questions 20

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

Options:

A.

Create and ensure it has the name "Send Log"

B.

Salesforce Support should create the data extension

C.

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

D.

Create using the SendLog Data ExtensionTemplate

Buy Now
Questions 21

Certification Aid wants to update Contact data stored in a Data Extension using the REST API. What is required to achieve this? Choose 1.

Options:

A.

The Data Extension must be in an Attribute Group.

B.

The Data Extensionmust be in a Population.

C.

The Data Extension must be sendable.

D.

The Data Extension must be created in Email Studio.

Buy Now
Questions 22

Certification Aid wants to include SSJS in an email message. Which code block can be used for this? Choose 2.

Options:

A.

B.

C.

D.

Buy Now
Questions 23

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

Options:

A.

Make a token API call and re-use the token until the next API call fails.

B.

Make a token API call before each triggered send API call.

C.

Make a token API call and re-use the token for that subscriber.

D.

Make a token API call and re-use the token until the token expires.

Buy Now
Questions 24

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:

A.

The operands are not the same data type.

B.

The comparison should use the < operator.

C.

Balance is a protected keyword.

D.

Double quotes should be used instead of single quotes.

Buy Now
Questions 25

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

Buy Now
Questions 26

NTO uses an external CRM which only exports encrypted files. NTO's marketing manager team wants to use some of the subscriber data found in the CRM for future marketing sends. Which three actions should be included in an automation given these requirements? Choose 3

Options:

A.

Import definition to the necessary data extension

B.

File transfer activity to the Import directory for decryption

C.

File drop to the SFTP Root directory

D.

File drop to the SFTP Import directory

E.

File transfer activity to the Safehouse for decryption

Buy Now
Questions 27

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

Buy Now
Questions 28

Northern Trail Outfitters (NTO) wants to prevent competitors fromreceiving a coupon email. They also want to capture email addresses of competitors who are included in the targeted audience.

Which feature could NTO use to prevent the coupon from being sent and report the email addresses skipped?

Options:

A.

Auto-Suppression list

B.

RaiseError AMPscript function

C.

Exclusion Script

D.

Try/Catch SSJS functions

Buy Now
Questions 29

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

Options:

A.

--comment

B.

// comment

C.

- comment -->

D.

/* comment */

Buy Now
Questions 30

Certification Aid wants to import data from a CSV file into a Data Extension. The CSV filecontains all relevant data. New records should be added to the Data Extension, and records which are not in the file should be removed from the Data Extension. Which import operation should be chosen for this? Choose 1.

Options:

A.

Add only

B.

Overwrite

C.

Add andupdate

D.

Update only

Buy Now
Questions 31

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:

A.

Use Row to return a specific row of the rowset

B.

Set the rowset to a new array variable

C.

Close the delimited AMPscrlpt Code Block

D.

Use RowCount to ensure the rowset contains data

Buy Now
Questions 32

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

Options:

A.

Data Extensions

B.

Relationships

C.

Populations

D.

Attribute Groups

Buy Now
Questions 33

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:

A.

No rows are updated

B.

All 250,000 subscribers

C.

400 subscribers who were sent the email

D.

Only subscribers who exist in All Subscribers

Buy Now
Questions 34

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

Options:

A.

Use intrisic functions in the WHERE clause

B.

Use SELECT * to include all fields

C.

Use Primary key(s) on fields used in joins

D.

Use intermediate tables to stage data

E.

Only update records that have changed since last execution

Buy Now
Questions 35

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

Buy Now
Questions 36

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

Buy Now
Questions 37

A developer wants to trigger an SMS message to a subscriber using a form published on CloudPages. How should the SMS message be triggered once the subscriber submits the form?

Options:

A.

Outbound SMS template and Automation Send Method

B.

InsertData AMPscript function to add the subscriber to a MobileConnect list

C.

CreateSMSConservation AMPscript function

D.

requestToken and messageContact REST API objects

Buy Now
Questions 38

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:

A.

LookupRowCount

B.

DataExtensionRowCount

C.

RowCount

Buy Now
Questions 39

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:

A.

Ends With operator

B.

%%MMMMdd%%

C.

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

D.

Begins With operator

Buy Now
Questions 40

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

Options:

A.

SMS messages

B.

Marketing Cloud apps

C.

Landing pages

D.

Email messages

Buy Now
Questions 41

A developer wantsto implement a newsletter registration from on NTO's website. Prior to form submission, an email address provided by the visitor should be validated. Which option could be used to support this scenario?

Options:

A.

REST API, /address/v1/validateEmail route

B.

SOAPAPI, Perform method with ValidationAction object

C.

SOAP API, Describe method with EmailAddress object

D.

REST API, /messaging/v1/domainverification route

Buy Now
Questions 42

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:

A.

/interaction/v1/interactions

B.

/interaction/v1/events

C.

/interaction/v1/eventDefinitions

D.

/contacts/v1/contactEvents

Buy Now
Questions 43

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

Buy Now
Questions 44

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.

Buy Now
Questions 45

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

Buy Now
Questions 46

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:

A.

To decryptthe import file on the Enhanced FTP server.

B.

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

C.

To decrypt the import file on the Safehouse.

D.

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

Buy Now
Questions 47

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.

Buy Now
Questions 48

A developer wants to retrieve all recordsin the OrderDetails data extension which are associated with a particular customer.

Which two AMPscript functions would return a suitable rowset?

Choose 2 answers

Options:

A.

LookupRows

B.

LookupOrderedRows

C.

Row

D.

Lookup

Buy Now
Questions 49

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 answers

Options:

A.

Email Studio

B.

Automation Studio

C.

Journey Builder

D.

Mobile Studio

Buy Now
Questions 50

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',)

Buy Now
Questions 51

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?

Options:

A.

Server-Side 3avaScript function Stringify

B.

Server-Side JavaScript function ParseJSON

C.

AMPscript function BuildRowsetFromXML

D.

AMPscript function BuildRowsetFromString

Buy Now
Questions 52

A company needs to retrieve a large number of rows from a data extension via the API.

Which two solutions would optimize the performance?

Choose 2 answers

Options:

A.

Use the REST API instead of the SOAP API.

B.

Use the AMPscript API functions on a CloudPage.

C.

Use the ContinueRequest feature.

D.

Use a SimpleFilterPart to retrieve small sets of relevant data.

Buy Now
Questions 53

When do synchronous REST API calls to Marketing Cloudtime out? Choose 2.

Options:

A.

240 seconds for tracking and data retrieve operations.

B.

300 seconds for tracking and data retrieve operations.

C.

120 seconds for non-tracking operations.

D.

240 seconds for non-tracking operations.

Buy Now
Questions 54

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:

A.

The send fails

B.

The email is not sent to the particular subscriber

C.

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

D.

The send is retried

Buy Now
Questions 55

NTO is using an asynchronous SOAP API call to the TriggerSend object to send order confirmation email to their customers. Which API object and attribute should be used toretrieve the status of the API call?

Options:

A.

Result Object and EmailAddress

B.

Result Object and ConservationID

C.

ResultItem Object and OrderID

D.

ResultItem Object and RequestID

Buy Now
Questions 56

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

Buy Now
Questions 57

Northern Trail Outfitters has created subscriber attributes including AGE underProfile Manager within their Enterprise 2.0 account.

How would a developer retrieve subscribers over 30 years of age?

Options:

A.

The data cannot be retrieved with a query

B.

Create a filtered Group of subscribers with AGE more than 30

C.

Create a query thatreferences the _Subscribers data view

D.

Create a query that references the _EnterpriseAttribute data view

Buy Now
Questions 58

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%'

Buy Now
Exam Name: Salesforce Certified Marketing Cloud Developer (WI24)
Last Update: Mar 29, 2024
Questions: 195

PDF + Testing Engine

$66.4  $165.99

Testing Engine

$46  $114.99
buy now Marketing-Cloud-Developer testing engine

PDF (Q&A)

$42  $104.99
buy now Marketing-Cloud-Developer pdf