Salesforce Marketing Cloud Developer Dumps Online – Great Learning Materials For Studying

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

2. A developer needs to display a value which has been calculated using an AMPscript block.

This value is stored in the variable named 'Label'.

Which two ways should the developer display this value in the body of an email? Choose 2 answers

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

4. Which two ways would a developer write an Exclusion Script to exclude sending an email at send time when comparing against a Boolean field in the Sendable Data Extension? Choose 2 answers

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

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

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

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

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

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

10. A developer receives a 401 Unathorized HTTP status message from a REST API request.

What is the reason for this error?

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

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

13. Landing pages can use which SSJS library? 1. Core LibraryZ. Platform Library 3. SSJS Library

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

15. Northern Trail Outfitters is using a mobile campaign to collect 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 TriggeredSend object? Choose 2 answers

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

17. Certification Aid wants to update Contact data stored in a Data Extension using the REST API.

What is required to achieve this? Choose 1.

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

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

20. A developer needs to configure a process that can store encrypted data from Marketing Cloud as a file on an external server.

What steps should the developer take?

21. A developer uses an API to send data to a Marketing Cloud data extension once every five minutes 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

22. A developer wants to transform the date and time 'Data_Enrolled' from Daylight Savings time.

How would the developer change the time to fall back one hour?

23. 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 to personalize emails from an external data source?

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

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

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

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

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

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

30. Certification Aid wants to trigger and email send in Marketing Cloud when a purchase is made on their website.

Which API should be used for this? Choose 2.

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

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

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

34. A developer identified a use case where a triggered send 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?

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

36. Clock Kicks would like to encrypt and store form 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

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

38. A developer wants to populate a data extension with the date of the most recent click for each subscriber.

Which query would accomplish this?

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

40. A developer wants to expand their knowledge of Query Activities. They want to identify email addresses that have bounced in the last 30 days, along with the Bounce Reason and some additional subscriber specific data; however, the SQL they have written does not return any records.

Below is the SQL statement:

What updates should be made to ensure this SQL statement returns the desired results?

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

What method and route would be used to accomplish this?

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

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

Which object and method should the developer use?

44. A developer identified duplicate contacts and wants to delete roughly 10 million subscribers using Contact Delete.

How could the process be expedited?

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

B)

C)

D)

46. A customer wants to export send data to their SFTP.

Which two automations would accomplish this? Choose 2

47. A doctor's office creates Populations for staff, patients and vendors.

What is the maximum number of Populations that should be created to ensure performance?

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

Which data view is required to gather this information?

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

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

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

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

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

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

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

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

Which three scenarios could have caused this? Choose 3 answers

57. A developer is writing a query to select unique subscribers who opened any emails sent since the beginning of the previous day.

Which query would provide that result?

A)

B)

C)

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

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

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

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

62. Which two AMPscript HTTP functions allow an OAuth token to be passed in a header? Choose 2 answers

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

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

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

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

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

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

69. A field value returned from a DE lookup contains a tab-delimited list of values.

Which AMPscript function could easily determine if a specific text string exist anywhere in the list?

70. A developer wants to upload a base64-encoded file to Content Builder using an API Installed Package but receives an insufficient Privileges error.

What should the developer check to troubleshoot the error?