Salesforce Marketing Cloud Developer Certification Update Dumps

test2023-01-16T07:55:23+00:00

By test Marketing Cloud Developer real questions, Salesforce Marketing Cloud Developer Certification Update Dumps 0 Comments

Passing the Salesforce Marketing Cloud Developer exam demonstrates your expertise in the platform and can open up new career opportunities and advancement opportunities. It is also a great way to validate your skills to employers and clients. Salesforce Marketing Cloud Developer exam dumps have been updated, providing an even more comprehensive and challenging test of your skills and knowledge in this field.

If you’re looking to take your career in Marketing Cloud development to the next level, consider studying for and taking the updated Salesforce Marketing Cloud Developer exam dumps. You’ll be demonstrating your knowledge of the platform and your ability to utilize it to create effective marketing campaigns and automations.

Page 1 of 5

1. 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.

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

POST /interaction/v1/events

POST /interaction/v1/interactions/contactentry

GET /eventDefinitions/key:{key}

2. 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

_Subscribers

_AllSubscribers

_Click

3. A company has chosen to use the REST API for triggered sends, but they continue to get the following error during their testing: "Unable to queue Triggered Send request. There are no valid subscribers." They were informed that the SOAP API provides more information about the error, and found that their payload did not include a required data extension field.

Which element of the SOAP API response provides this level of detail?

ErrorDescription

OverallStatus

ErrorCode

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

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

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

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

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

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

How long are Marketing Cloud v1 access tokens valid?

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.

6. A developer is creating a custom preference center and wants to log unsubscribe events from the CloudPage.

Which set of parameters should be captured and provided to the LongUnsubEvent Execute Call to ensure accurate unsubscribe information?

SubscriberKey and JobID

SubscriberID and BatchID

EmailAddress and JobID

SubscriberKey and BatchID

7. A new record is appended to 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?

SELECT TOP 1 SubscriberKey FROM Orders

SELECT DISTINCT SubscriberKey FROM Orders

SELECT SubscriberKey FROM Orders GROUP BY SubscriberKey

SELECT SubscriberKey FROM Orders GROUP BY SubscriberKey HAVING COUNT(*)>1

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

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

9. A sendable data extension with a text field named 'Balance' contains the value S6.96 for a 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?

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.

10. 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 naming pattern 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?

%%FILENAME%%

%%TRIGGER_FILENAME%%

%%FILENAME_FROM_TRIGGER%%

%%FILENAME_FROM_IMPORT%%

Page 2 of 5

11. Which of the following statements are correct concerning Populations in Contact Builder? Choose 2.

Populations are used to create large subgroups Contacts.

Populations need to be added to an Attribute Group.

No more than three Populations should be created.

Populations should be used for segmentation

12. A developer is configuring a File Drop Automation and wants to 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

Ends With operator

%%MMMMdd%%

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

Begins With operator

13. 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

Use the REST API instead of the SOAP AP

Use the AMPscript API functions on a CloudPage.

Use the ContinueRequest feature.

Use a SimpleFilterPart to retrieve small sets of relevant data.

14. 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'

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

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

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

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

15. Certification Aid wants to create a file drop automation with a filename pattern. An import file is placed daily on the Marketing Cloud Enhanced FTP server, and the file name always starts with the current month and day (e.g. OCT26).

How should the filename pattern be defined? Choose 2.

%%Month%%%%Day%%

%%MMDD%%

Ends With operator

Begins With operator

16. A developer needs to determine why a Query Activity in an Automation has failed.

Which three scenarios could have caused this? Choose 3 answers

The query takes more than 60 minutes to run.

The query is returning more than one million rows.

The query results in duplicate rows not allowed by the primary key.

The query is not returning a value for a non-nullable field.

The query is inserting a value that is larger than the size of a field.

17. A developer wants 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?

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();

18. A marketing director at Northern Trail Outfitters wants to analyze the Send, Click, and Open Data Views.

Which activities should the developer build to generate the data before transferring it to the SFTP?

Query Activity > Tracking Extract

Data Views Extract > Filter Activity

Filter Activity > Data Extension Extract

Query Activity > Data Extension Extract

19. What is the purpose of the IF statement below?

To handle when no row is returned by the LookupRows function

To handle when the subscriber is in a held status

To handle when images are broken

To handle when there are multiple records in the data extension for the subscriber

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

Use the AMPscript CloudPagesURL function.

Append EmailAddress to the URL as an encoded parameter.

Append SubscnberKey to the URL as an encoded parameter.

Page 3 of 5

21. A developer needs to identify all subscribers who were sent Job ID 420 but did not click any links.

Which SQL statement would produce the desired results?

A)

Option A

Option B

Option C

Option D

22. A developer want to email a subscriber who is currently being processed for a Contact Deletion request. When could the Contact be reintroduced after a Contact Delete operation has started?

Never

14 days after deletion process is complete

After deletion is fully complete

Anytime

23. 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 no emails have been sent during his initial testing.

Which object and method should the developer use?

TriggerSend object and Update method

TriggerSend object and Create method

TriggerSendDefinition object and Execute method

TriggerSendDefinition object and Update method

24. A developer identified duplicate contacts and initiated a Contact Delete process for 10 million subscribers.

How could the process be expedited?

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

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

mobilenumbers

phonenumbers

emailaddress

subscribers

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

Both

Platform

None

Core

27. A developer used LookupRows to retrieve data when building a dynamic email.

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

Use Row to return a specific row of the rowset

Set the rowset to a new array variable

Close the delimited AMPscrlpt Code Block

Use RowCount to ensure the rowset contains data

28. A developer needs to create a fully-branded CloudPage which includes images hosted in Content Builder. The developer wants to secure the page and its elements using the SSL protocol.

What is the minimum number of SSL certificates required?

Three

Two

None

One

29. A developer wants to build an audience by identifying subscribers who opened a specific email.

Which query should the developer use?

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'

30. Which AMPscript function group could most negatively Impact send processing?

String functions

Data extension functions

Date Time

Math functions

Page 4 of 5

31. 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

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.

32. What is the operational order of the Contact Delete process for Marketing Cloud?

Delete initiated > Suppression phase > Final Deletion

Delete initiated > Final deletion

Delete initiated > Final deletion >Suppression phase

Data identified > Suppression phase > Delete initiated > Account page

33. A developer wants to inject a Contact into a journey using API.

What method and route would be used to accomplish this?

Post / contacts/v1/contacts

Post/v1hub/datevents/key:[key} /rows / {primaryKeys

Post/ interaction/ v1/events

Post/interaction/v1/interactions

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

ListSubscribers

_Subscribers

_BusinessUnitUnsubscribes

.Subscribers

35. Northern Trail Outfitters (NTO) wants to prevent competitors from receiving 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?

Auto-Suppression list

RaiseError AMPscript function

Exclusion Script

Try/Catch SSJS functions

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

%%[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 THEN SET @color = 'Red' ELSE SET @color = 'White' ENDIF]%%

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

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

Send

ListSend

SentEvent

LinkSend

38. 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 each month in the following way:

How should the developer use AMPscript to generate the total?

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

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

Find the first day of next month and subtract one day

Use the date format string for last day of month within FormatDate

Add one month using DateAdd to now

Add 30 days using DateAdd to now

40. 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 to successfully create a TriggerSend object? Choose 2

Attribute

TriggerSendDefinition

Contact

Subscribers

Page 5 of 5

41. Northern Trail Outfitters sends a weekly email with dynamic content, and they want to record custom data inside a send log on each send to record what content was displayed and correlation flags.

What is the maximum number of custom data points recommended by Salesforce to ensure sends speeds are not affected when inserting into the built-in send log?

20 fields or less

10 fields or less

No limit

5 fields or less

42. Northern Trail Outfitters wants to trigger follow up messages after a subscriber opens an email.

What process would they use to get real-time engagement data?

Query Activity

Client-Side JavaScript

WSproxy Service

Event Notification Service

43. New subscribers at Northern Trail Outfitters (NTO) are added to a data extension. NTO would like to send these subscribers a welcome series with Journey Builder.

What would allow the data extension to be selected for journey entry'

At least one Campaign must be associated to the data extension.

The Triggered Send Template must be used to create the data extension.

The data extension must be configured for sending.

The data extension must contain a field of the EmailAddress data type.

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

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

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

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

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

45. NTO wants to exclude sends to specific subscribers based on a business rule, which is defined in an Exclusion Script.

Which three types of sends would support this functionality? Choose 3

Journey Builder Send Email Activity

Content Builder Send Flow

Send Marketing Cloud Email in Sales or Service Cloud

Journey Builder Send SMS Activity

Automation Studio Send Email Activity

46. 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 to retrieve the status of the API call?

Result Object and EmailAddress

Result Object and ConservationID

ResultItem Object and OrderID

ResultItem Object and RequestID

47. 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 contain line 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?

REPLACE and CHAR

FORMAT and SPACE

LTRIM and RTRJM

REPLICATE and NCHAR

48. When do synchronous REST API calls to Marketing Cloud time out? Choose 2.

240 seconds for tracking and data retrieve operations.

300 seconds for tracking and data retrieve operations.

120 seconds for non-tracking operations.

240 seconds for non-tracking operations.

49. A marketer is troubleshooting why an email send's tracking information is not available in Sales Cloud. The marketer confirms Marketing Cloud Connect is installed properly.

What should be confirmed next to continue troubleshooting the send's tracking information?

The audience was a Salesforce Data Extension containing the appropriate SFID

The email was sent to the All Subscribers list

The tracking destination folder was set to My Tracking

The audience was built using a Triggered Send Data Extension template