certified-marketing-cloud-developer sample questions

Question 1

Northern Trail Outfitters (NTO) is launching a 'Track Your Order' CloudPage for customers. The page will accept an Order ID from a URL parameter (.../track?order=12345) and display sensitive order details, including the customer's shipping address and the items purchased. The development team is concerned about security, specifically preventing unauthorized users from guessing Order IDs and viewing other customers' data.

The initial plan is to use RequestParameter("order") to get the Order ID, then use LookupRows() on the Orders_DE to retrieve the details. The Orders_DE contains OrderID, CustomerID, ShippingAddress, and OrderDetails. To ensure the page is only viewed by the intended recipient, the links are sent in a transactional email and contain the subscriber's SubscriberKey as another parameter (...&subKey=XYZ).

The security team has mandated that a user accessing the page must be the actual customer associated with the order. They have also flagged potential Cross-Site Scripting (XSS) vulnerabilities if order details are displayed directly.

Accepted Answer

On page load, retrieve `OrderID` and `SubscriberKey` from the URL. Perform a `LookupRows()` on `Orders_DE` using both `OrderID` and `CustomerID` (where `CustomerID` matches the passed `SubscriberKey`). If a match is found, use the `AttributeValue()` function on each data field before displaying it to prevent XSS.

Answer

On page load, retrieve `OrderID` and `SubscriberKey` from the URL. Perform a `LookupRows()` on `Orders_DE` using both `OrderID` and `CustomerID` (where `CustomerID` matches the passed `SubscriberKey`). If a match is found, display the `OrderDetails`.

Answer

Encrypt the `OrderID` and `SubscriberKey` together into a single token before generating the email link. On the CloudPage, decrypt the token, validate the parameters, and then look up the order. Use the `TreatAsContent()` function to display all retrieved data.

Answer

On page load, retrieve `OrderID` and `SubscriberKey` from the URL. Perform a `LookupRows()` using only the `OrderID`. Then, in a separate step, compare the `CustomerID` from the result with the `SubscriberKey` from the URL. If they match, display the data wrapped in the `AttributeValue()` function for XSS protection.

Question 2

A developer needs to prevent an email from being sent to a subscriber if their Status field in the sendable data extension is 'Inactive'. The check must be performed at send time.

To accomplish this, the developer should use the _____(1, "Subscriber status is inactive") function in an AMPscript block within the email body.

Accepted Answer

RaiseError()

Answer

Skip()

Answer

Exit()

Answer

Abort()

Question 3

A company has a multi-brand architecture using separate Marketing Cloud Business Units (BUs) for each brand. They need to maintain a single, centralized data extension of all customers who have opted out of communications across all brands. This 'Global Unsubscribe' list must be accessible for suppression in sends from every BU.

Accepted Answer

Create the data extension in the parent BU, mark it as 'Shared,' and place it in a shared folder with permissions granted to all child BUs.

Answer

Create the data extension in each child BU and use a daily SQL query automation to synchronize them with a master list in the parent BU.

Answer

Create a standard data extension in the parent BU and use the API to query it from each child BU during the send process.

Answer

Utilize the out-of-the-box All Subscribers list at the Enterprise (parent) level, as it automatically handles global unsubscribes.

Question 4

A developer is building an integration that programmatically creates and updates hundreds of assets (emails, templates, content blocks) in Content Builder. After implementing the logic using the REST API, they notice the process is slow and occasionally fails with `429 Too Many Requests` errors. The current implementation sends one API request per asset.

Accepted Answer

Use the REST API's batch endpoint (`/asset/v1/content/assets/batch`) to create or update up to 25 assets in a single request.

Answer

Implement an exponential backoff strategy for retrying failed requests.

Answer

Switch to the SOAP API, as its `UpdateBatch` method is better suited for bulk operations.

Answer

Utilize the REST API's asynchronous processing mode by including the `async=true` query parameter in the requests.

Question 5

A marketing email needs to display a personalized greeting, "Hi [FirstName]," but must fall back to "Hi Valued Customer," if the `FirstName` attribute is empty or does not exist for a subscriber.

Accepted Answer

Hi %%=IIF(Empty(AttributeValue("FirstName")), "Valued Customer", AttributeValue("FirstName"))=%%

Answer

Hi %%=v(IF(@FirstName != "" THEN @FirstName ELSE "Valued Customer" ENDIF))=%%

Answer

Hi %%=Lookup("Subscribers", "FirstName", "SubscriberKey", _subscriberkey)=%%

Answer

Hi %%=Iif(Not IsNull(FirstName), FirstName, "Valued Customer")=%%

Question 6

A data analyst needs to create a targetable data extension containing customers who have opened any email in the last 90 days but have NOT clicked any email in the last 180 days. The analyst must use the system Data Views.

Accepted Answer

```sql SELECT o.SubscriberKey FROM _Open o LEFT JOIN _Click c ON o.SubscriberKey = c.SubscriberKey AND c.EventDate > DATEADD(day, -180, GETDATE()) WHERE o.EventDate > DATEADD(day, -90, GETDATE()) AND c.SubscriberKey IS NULL ```

Answer

```sql SELECT s.SubscriberKey FROM _Subscribers s WHERE s.SubscriberID IN (SELECT o.SubscriberID FROM _Open o WHERE o.EventDate > DATEADD(day, -90, GETDATE())) AND s.SubscriberID NOT IN (SELECT c.SubscriberID FROM _Click c WHERE c.EventDate > DATEADD(day, -180, GETDATE())) ```

Answer

```sql SELECT o.SubscriberKey FROM _Open o WHERE o.EventDate > DATEADD(day, -90, GETDATE()) AND NOT EXISTS (SELECT 1 FROM _Click c WHERE c.SubscriberKey = o.SubscriberKey AND c.EventDate > DATEADD(day, -180, GETDATE())) ```

Answer

```sql SELECT DISTINCT o.SubscriberKey FROM _Open o LEFT JOIN _Click c ON o.SubscriberKey = c.SubscriberKey WHERE o.EventDate > DATEADD(day, -90, GETDATE()) AND (c.EventDate IS NULL OR c.EventDate <= DATEADD(day, -180, GETDATE())) ```

Question 7

During a code review, a senior developer points out that a block of AMPscript is making repeated `Lookup()` calls inside a `FOR` loop to retrieve the same piece of information for every row being processed. This is causing significant performance degradation in email rendering.

Accepted Answer

Before the loop begins, perform a single `Lookup()` or `LookupRows()` call to retrieve the required data and store it in a variable. Reference this variable inside the loop.

Answer

Replace the `Lookup()` calls with `LookupRows()` to retrieve the data in a batch, but keep the call inside the loop.

Answer

Move the entire `FOR` loop and lookup logic into an SSJS Script Activity and run it before the send.

Answer

Use the `TreatAsContent()` function to force the AMPscript to evaluate faster.

Question 8

True or False: When using the Marketing Cloud REST API with OAuth 2.0, a single access token can be used to make API calls to any Business Unit (BU) within the Enterprise 2.0 account, provided the API package has been granted access to those BUs.

Accepted Answer

True

Answer

False

Question 9

Cumulus Health, a healthcare provider, needs to manage patient communication preferences in Marketing Cloud. They have a primary Patients data extension with PatientID as the Subscriber Key. They need to store preferences for multiple communication types (e.g., 'Newsletter', 'AppointmentReminders', 'HealthTips') and multiple channels (e.g., 'Email', 'SMS'). A patient can have different opt-in statuses for each combination of communication type and channel.

The data architecture team is debating two approaches for storing this granular preference data.
Approach 1: A single, 'wide' Patient_Preferences DE with columns like PatientID, Newsletter_Email_OptIn, Newsletter_SMS_OptIn, AppointmentReminder_Email_OptIn, etc.
Approach 2: A 'narrow' or 'normalized' Patient_Preferences DE with three columns: PatientID, PreferenceType (e.g., 'Newsletter_Email'), and OptInStatus (e.g., 'true'/'false'). This would result in multiple rows per patient.

The solution must be scalable, as new communication types and channels will be added in the future. It also needs to be efficient for AMPscript lookups within emails.

Accepted Answer

Approach 2, because it is more scalable. Adding a new preference type only requires adding new rows, not altering the data extension schema, and `LookupRows()` can efficiently retrieve all preferences for a patient.

Answer

Approach 1, because a single `Lookup()` call can retrieve all preferences for a patient at once, making it more performant for email personalization.

Answer

Approach 1, because having fewer rows in the data extension will lead to faster query performance in SQL activities.

Answer

Approach 2, because it allows for using a Journey Builder preference center activity to update the data more easily.

Question 10

A developer is working with both Platform and Core SSJS libraries within a Script Activity. They need to perform several actions: 1) Initialize a Data Extension object, 2) Make an outbound HTTP GET request to an external API, 3) Parse a JSON response from that API, and 4) Set a variable that can be used by a subsequent activity in the Automation. Which THREE of the following SSJS functions or objects would be required to accomplish these tasks? (Select THREE)

Accepted Answer

DataExtension.Init()

Accepted Answer

Script.Util.HttpGet()

Accepted Answer

Platform.Variable.SetValue()

Answer

Platform.Function.Lookup()

Answer

Stringify.Parse()

Answer

Platform.Request.GetPostData()

certified-marketing-cloud-developer Sample Questions & Answers

Free certified-marketing-cloud-developer Sample Questions with Answers

Ready for the real thing?

certified-marketing-cloud-developer Sample Questions & Answers

Related practice tests

Ready for the real thing?