Home

Home / Salesforce / Certified Marketing Cloud Developer

Question list

List of questions

Question 1

(0)

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 Mana

Question 2

(0)

NTO is reconsidering the requirement to have English, Spanish and French versions of their email campaigns. They request a developer to create a query which aggregates clicks grouped by language of

Question 3

(0)

What parameter should a developer include to ensure the MobileConnect Contact is tied to the Email Contact when making a QueueMO call for an existing email subscriber?

Question 4

(0)

A developer wants to create an AMPscript FOR loop that populates HTML table rows based on the number of rows and data in a target DE. Where should the developer place the FOR keyword to begin the lo

Question 5

(0)

A developer wants a link to be dynamic based on subscriber attributes. Rather than create numerous links, the developer uses AMPscript to set the link's value as a variable. The variable will be use

Question 6

(0)

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

Question 7

(0)

Certification Aid wants to include SSJS in an email message. Which code block can be used for this? Choose 2.

Question 8

(0)

How can subscriber, system, and sendable Data Extension attributes be referenced for content personalization using SSJS? Choose 1.

Question 9

(0)

How can SSJS variables be referenced for content personalization? Choose 1.

Question 10

(0)

A developer needs to push real-time updates of the company's product catalog to a data extension. Which two API options are available? Choose 2 answers

Open VPLUS File

Convert VPLUS to PDF

Related questions

Northern Trail Outfitters (NTO) wants to determine the best identifier for subscribers across all channels. What should be recommended5

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

A developer is building a landing page in Marketing Cloud and an email with a Call-To page will display personal information about the subscriber. In which way could the developer create the CTA link?

A developer created an email using the fasubjectLine variable as the subject line. Due to revisions, the developer declared <>subjectLine in multiple locations throughout the email, including: Which subject line will be used at the time of deployment?

A developer is working on cross-channel campaign functions for the email team at Northern Trail Outfitters. They are reviewing available APIs for the different Marketing Cloud applications to determine the most appropriate solution for each. Which application utilizes the REST API?

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

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

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?

NTO puts the word TEST at the beginning of the name for each test emai. Which query would return the subs who were sent those emails?

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?

Question 187 - Certified Marketing Cloud Developer discussion

Report

A developer needs to find all subscribers on the Customers data extension who made a purchase in the last 30 days. Purchase data is on the Orders data extension which contains a column called 'PurchaseDate'. Contacts are identified in both data extensions by a column called 'ContactKey', and the Orders data extension can contain many instances of the same subscnber.

Which SQL keyword should the developer use to achieve the desired result?

A.

INNER JOIN

B.

OUTER JOIN

C.

ORDER BY PurchaseDate ASC

Show Answer

asked 23/09/2024

Azwihangwisi Ntikane

38 questions

User

Your answer: A B C

0 comments

Sorted by

Leave a comment first