Read Salesforce Certified Marketing Cloud Engagement Developer Free Dumps (Part 1, Q1-Q40) Online to Verify the V8.02 First

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

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

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

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

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

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

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

What is required to achieve this? Choose 1.

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. A developer needs to determine why a Query Activity in an Automation has failed.

Which three scenarios could have caused this? Choose 3 answers

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

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

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

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

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

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

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

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

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

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 is configuring a new Marketing Cloud account and has decided to use a unique 10-digit integer as each customer's Contact Key.

Which data type should be used when representing the value of Contact Key?

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

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

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

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

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

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

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

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

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

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

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

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

How could the process be expedited?

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

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

Which two automations would accomplish this? Choose 2

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

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

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

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

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

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