Salesforce Salesforce Certifications MARKETING-CLOUD-DEVELOPER Questions & Answers

• Question 121:

  A developer wants to populate a data extension with the date of the most recent click for each subscriber. Which query would accomplish this?

  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

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

  E. SELECT c.SubscriberKey, c.eventDate FROM _Click c WHERE c.IsUnique = 1

  Correct Answer: C

• Question 122:

  Northern Trail Outfitters uses a Send Log and sends more than one million emails per day. They want to execute daily reports on all subscriber activity without impacting send performance.

  Which set of best practices should be implemented''

  A. Add a data retention policy to the Send Log. then run reports from the Send Log data extension.

  B. Add a data retention policy to the Send Log. then run reports from the _Opensdata view.

  C. Copy new Send Log records to an Archive data extension, then run reports from the Archive data extension.

  D. Copy new Send Log records to an Archive data extension, then run reports from the Send Log data extension.

  Correct Answer: B

• Question 123:

  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

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: C

• Question 124:

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

  A. Auto-Suppression list

  B. RaiseError AMPscript function

  C. Exclusion Script

  D. Try/Catch SSJS functions

  Correct Answer: C

• Question 125:

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

  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

  Correct Answer: CDE

• Question 126:

  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?

  A. GET using the REST API/asset/v1/content/assets and parse theFileProperties parameter

  B. Use the SOAP API to create a Porfoglio object and idenfity the Source property

  C. POST to the REST API/asset/v1/content/categories and parse the Description parameter

  D. POST to the REST API/asset/v1/content/assets and parse the FileProperties parameter

  Correct Answer: A

• Question 127:

  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'

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

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

  C. The data extension must be configured for sending.

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

  Correct Answer: C

• Question 128:

  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

  A. Ends With operator

  B. %%MMMMdd%%

  C. %%Month%%%%Day%?o

  D. Begins With operator

  Correct Answer: CD

• Question 129:

  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 havebeen sent during his initial testing. Which object and method should the developer use?

  A. TriggerSend object and Update method

  B. TriggerSend object and Create method

  C. TriggerSendDefinition object and Execute method

  D. TriggerSendDefinition object andUpdate method

  Correct Answer: B

• Question 130:

  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 alwaysstarts with the current month and day (e.g. OCT26). How should the filename pattern be defined? Choose 2.

  A. %%Month%%%%Day%%

  B. %%MMDD%%

  C. Ends With operator

  D. Begins With operator

  Correct Answer: AD