Practice Free Salesforce Certified Marketing Cloud Engagement Developer Exam Online Questions
Certification Aid wants to include SSJS in an email message.
Which code block can be used for this? Choose 2.
- A . <script runat=server></script>
- B . <script language=ssjs></script>
- C . <script runat=server language=javascript></script>
- D . <script language=javascript></script>
A developer started a Contact Delete process that is now complete.
In which two places would the Contact Delete process remove data? Choose 2 answers
- A . Non-Sendable Data Extensions
- B . Import Files on the Enhanced SFTP
- C . Sendable Data Extensions
- D . Mobile Lists
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?
- A . REPLACE and CHAR
- B . FORMAT and SPACE
- C . LTRIM and RTRJM
- D . REPLICATE and NCHAR
Landing pages can use which SSJS library? 1. Core LibraryZ. Platform Library 3. SSJS Library
- A . Onlyl1 and 3
- B . Only1 ard2
- C . Only 2 and 3
- D . All 1,2 and 3
- E . None of these
A developer wants to retrieve a row of data from a data extension using the SOAP API.
Which API Object should be used for this call?
- A . DataExtensionField
- B . DataExtension
- C . DataExtensionObject
- D . Row
Northern Trail Outfitters has an Enterprise 2.0 account with 15 business units. Each business unit can access a Shared Data Extension named ‘Inventory’, which contains the details for each product. A Boolean field named ‘InStock’ indicates whether the item is available.
Which snippet of AMPscript would return all products which are currently available?
- A . LookupRows (‘Ent. Inventory*, ‘true’, ‘InStock’)
- B . LookupRows (‘Ent. Inventory*, itemName, ‘InStock’, ‘true’)
- C . LookupRows (‘Ent. Inventory*, ‘InStock’, ‘true’, )
- D . LookupRows (‘Inventory*, ‘InStock”true’,)
A developer wants to programmatically inject Contacts into a journey via REST API.
What is the recommended route using POST data extension fields and values?
- A . /interaction/v1/interactions
- B . /interaction/v1/events
- C . /interaction/v1/eventDefinitions
- D . /contacts/v1/contactEvents
A developer identified duplicate contacts and initiated a Contact Delete process for 10 million subscribers.
How could the process be expedited?
- A . Change the Suppression value to a larger value
- B . Manually delete subscribers in All Contacts
- C . Stop current delete process and delete smaller groups
- D . Delete any unnecessary Sendable Data Extensions
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?
- A . Marketing Cloud does not allow DateAdd functions in Query Activities. They should define a specific date.
- B . Marketing Cloud _Bounce data view does not contain EmailAddress. They should join on SubscriberlD.
- C . Marketing Cloud Data Views only hold 20 days worth of data. They should narrow scope of DateAdd function.
- D . Marketing Cloud does not allow use of GETDATE function. They should define a specific date.
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?
- A . Substring
- B . BuildRowSetFromString
- C . IndexOf
- D . Length