Salesforce Salesforce Certifications MARKETING-CLOUD-DEVELOPER Questions & Answers

• Question 171:

  What is the purpose of the IF statement below?

  

  A. To handle when no row is returned by the LookupRows function

  B. To handle when thesubscriber is in a held status

  C. To handle when images are broken

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

  Correct Answer: A

• Question 172:

  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.

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

  B. POST /interaction/v1/events

  C. POST /interaction/v1/interactions/contactentry

  D. GET /eventDefinitions/key:{key}

  Correct Answer: BC

• Question 173:

  A new record is appended to the Orders dataextension each time a customer makes a purchase. Which SQL statement would select a unique list of subscribers who have made multiple purchases?

  A. SELECT TOP 1 SubscriberKey FROM Orders

  B. SELECT DISTINCT SubscriberKey FROM Orders

  C. SELECT SubscriberKeyFROM Orders GROUP BY SubscriberKey

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

  Correct Answer: C

• Question 174:

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

  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 Extension Template

  Correct Answer: D

• Question 175:

  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

  A. 6,961

  B. 6.96

  C. $6.96

  D. 6.96

  Correct Answer: CD

• Question 176:

  A developer wants to transformthe date and time 'Data_Enrolled' from Daylight Savings time. How would the developer change the time to fall back one hour?

  A. %%=DataAdd(Date_Enrolled,-1)=%%

  B. %%=DateAdd(Date_Enrolled,-1 'H')=%%

  C. %%=DateDiff(Date_Enrolled, 1, 'H')=%%

  D. %%=FormatDate(Date_Enrolled,-1,'HH','en-us')=%%

  Correct Answer: B

• Question 177:

  A customer wants a list of subscribers who were sent an email within the past 12 months.

  How should thisrequest be completed?

  A. Create a measure with criteria sent_date is after today minus 565 days

  B. Run a tracking extract via the SOAP API

  C. Query against the Job and Sent data views

  D. Locate the email sends in the Tracking tab within Email Studio

  Correct Answer: B

• Question 178:

  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?

  A. Use the RowCount function and an IF statement

  B. Use the Lookup, Row and Field functions

  C. Use the LookupOrderRows and Row functions

  D. Use the DataExtensionRowCount function

  Correct Answer: A