Salesforce Marketing-Cloud-Developer Exam Dumps

Salesforce Marketing-Cloud-Developer Sample Question Answers

Salesforce Marketing-Cloud-Developer Sample Questions

Question # 1

A developer wants to include a comment within an AMPscript code block for the benefit ofother developers who will be reviewing the code.Which syntax should the developer use?

A. < !- This is a comment
B. // Thisis a comment
C. -- This is a comment
D. /" This is a comment */

Answer: D

Show Answer

Question # 2

A developer is making an API REST call to trigger an email send. An access token is usedto authenticate the call.How long are Marketing Cloud v1 access tokens valid?

A. Access tokens expire after 24 hours.
B. REST calls do not require an access token.
C. Each API call requires a new access token.
D. Access tokens expire after one hour.

Answer: D

Show Answer

Question # 3

NTO puts the word TEST at the beginning of the name for each testemai. Which querywould return the subs who were sent those emails?

A. SELECT * FROM _Job J INNER JOIN _Sent S on J.EmailName LIKE 'TEST%'
B. SELECT * FROM _Job INNER JOIN _Sent on JobID = JobID WHERE EmailName LIKE'TEST%'
C. SELECT * FROM _Job J INNER JOIN _Sent S ON.JobID = S.JobID WHEREJ.EmailName LIKE 'TEST%'
D. SELECT * FROM _Job J INNER JOIN _Sent S on J.JobID = JobID = S.JobID WHEREJ.EmailName = 'TEST%'

Answer: C

Show Answer

Question # 4

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

A. Include the header x-access-token: your_access_token
B. Include as a query parameter access_token=Y0UR_ACCESS_TOKEN
C. Include the header Authorization: Basic your_access_token
D. Include the header Authorization: Bearer YOUR ACCESS TOKEN

Answer: D

Show Answer

Question # 5

Certification Aid wants to add records to a Data Extension using the SOAP API. Whichobject can be used for this? Choose 1.

A. DataExtensionObject object
B. Subscriber object
C. Attribute object
D. DataExtension object

Answer: A

Show Answer

Question # 6

Contact Builder can be used to create a relational model of an organization's data withinMarketing Cloud. Which three factors should be taken into consideration when preparingdata to be used in Contact Builder? Choose 3 answer

A. Assigningdata relationships and primary keys across all channels
B. Verifying data address marketing needs
C. Verifying all data extensions have a sendable value
D. Verifying each data extension has the required Email Address field populated
E. Normalizing data toreduce redundancy

Answer: A,B,C

Show Answer

Question # 7

A doctor's office creates Populations for staff, patients and vendors. What is the maximumnumber of Populations that should be created to ensure performance?

A. Five
B. Three
C. Unlimited
D. One

Answer: B

Show Answer

Question # 8

Anew record is appended to the Orders data extension each time a customer makes apurchase. Which SQL statement would select a unique list of subscribers who have mademultiple purchases?

A. SELECT TOP 1 SubscriberKey FROM Orders
B. SELECT DISTINCT SubscriberKey FROM Orders
C. SELECT SubscriberKey FROM Orders GROUP BY SubscriberKey
D. SELECT SubscriberKey FROM Orders GROUP BY SubscriberKey HAVINGCOUNT(*)>1

Answer: C

Show Answer

Question # 9

Which of the following statements are correctconcerning Contacts and Subscribers?Choose 2.

A. A Contact is subscribed to any channel.
B. Each Contact is also a Subscriber.
C. Each Subscriber is also a Contact.
D. A Contact is subscribed to a specific channel.

Answer: A,C

Show Answer

Question # 10

Which programming language should be used in email messages? Choose 1.

A. AMPscript only
B. Both
C. Either AMPscript or SSJS
D. SSJS only

Answer: C

Show Answer

Question # 11

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

A. SELECT TOP 1 c.SubscriberKey, c.eventDateFROM _Click c ORDER BY c.eventDateDESC
B. SELECT c.SubscriberKey, MIN (c.eventDate) AS eventDate FROM _Click c GROUP BYc.SubscriberKey
C. SELECT c.SubscriberKey, MAX(c.eventDate) AS eventDate FROM _Click c GROUPBY c.SubscriberKey
D. SELECT c.SubscriberKey, c.eventDate FROM _Click c WHERE c.IsUnique = 1

Answer: C

Show Answer

Question # 12

A developer is experiencing timeouts when testing a SQL Query Activity in AutomationStudio. How should the developer optimize the query?

A. Configure a longer timeout period within Administration in Automation Studio.
B. Use intermediate tables to breakqueries into smaller parts.
C. Ensure all SQL Query Activities are in the same step in the automation.
D. Limit joins to the INNER JOIN within all SQL Query Activities.

Answer: B

Show Answer

Question # 13

Certification Aid wants to create a file drop automation with a filename pattern. An importfile 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 bedefined? Choose 2.

A. %%Month%%%%Day%%
B. %%MMDD%%
C. Ends With operator
D. Begins With operator

Answer: A,D

Show Answer

Question # 14

Certification Aid wants to add new customers to a cross-channel welcome campaign whenthey register on the company website. Which API should be used for this? Choose 1.

A. Personalization Builder API
B. Event Notification API
C. Transactional Messaging API
D. JourneyBuilder API

Answer: C

Show Answer

Question # 15

A developer uses an API to send data to a Marketing Cloud data extension onceevery fiveminutes 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

A. In case of 'Not Authorized' errors, request a new Access Token and attempt the callagain.
B. In case of Server errors, request a new Access Token before each request.
C. In case of Server errors, ensure the Server is available and attempt the call again.
D. Use Username and Password authentication instead of oAuth client ID and client secret.
E. Store the expiry of the access token to ensure a new token is requested if the old one isinvalid.

Answer: A,D,E

Show Answer