Skip to content
Quizra

certified-marketing-cloud-developer Salesforce Certified Marketing Cloud Engagement Developer Practice Questions

Prepare for certified-marketing-cloud-developer with more than an answer.

203 questions in the full set20 sample questionsUpdated Oct 18, 2025
Study as flashcards
Exam fee
$200 USD
Level
Professional
Valid for
Does not expire but requires maintenance
Domains covered on the exam 5
  1. Data Modeling14%
  2. Programmatic Languages35%
  3. API22%
  4. Data Management22%
  5. Security7%
  1. 1

    A marketing manager needs to import a CSV file into a data extension. The CSV file contains a header row. During the Import Activity configuration, the manager needs to ensure that the data from the file correctly maps to the fields in the destination data extension.

    Show answer details

    Correct answer: A

    The 'Map by Header Row' option instructs the import process to match the column names in the first row of the CSV file to the field names in the target data extension. This is the most common method for mapping fields.

  2. 2

    A developer is building a CloudPage that accepts user input from a form field ( ) and displays it back on a confirmation page using AMPscript. They need to prevent Cross-Site Scripting (XSS) attacks where a user might input malicious JavaScript (e.g., alert('XSS')).

    Show answer details

    Correct answer: C

    This is the correct and secure method. The AttributeValue function automatically HTML-encodes its output, converting special characters like into their entity equivalents (< and >). This ensures the browser displays the input as plain text, preventing any malicious scripts from executing.

  3. 3

    A developer is writing an SSJS script to add new subscribers to a data extension called 'Leads'. The script receives subscriber data from an external source. The developer wants to ensure that if a subscriber with the same primary key already exists, their record is updated; otherwise, a new record is inserted.

    Show answer details

    Correct answer: C

    The Upsert function is specifically designed for this 'insert or update' logic. It checks for the existence of the primary key: if found, it updates the row; if not found, it inserts a new row. This is the most efficient way to achieve the desired outcome.

  4. 4

    A developer needs to get an OAuth 2.0 access token to make REST API calls to Marketing Cloud. They have already created an Installed Package in Setup and have the Client ID, Client Secret, and the tenant-specific authentication base URI.

    Show answer details

    Correct answer: B

    This is the correct method. To obtain an access token for a server-to-server integration, a developer must make an HTTP POST request to the /v2/token endpoint, passing the grant_type, client_id, and client_secret in the request body.

  5. 5

    A developer is trying to debug an AMPscript block in a CloudPage that is not producing the expected output. They want to see the value of a variable @myVar at a certain point in the script's execution.

    Which is the most direct and effective way to output the value of @myVar for debugging purposes on the CloudPage?

    flowchart TD Start([Start]) --> SetVar[SET @myVar = "Debug Value"] SetVar --> Output{How to display @myVar?} Output --> A["%%=TreatAsContent(@myVar)=%%"] Output --> B["%%=v(@myVar)=%%"] Output --> C["%%[OUTPUT(@myVar)]%%"] Output --> D["%%[Write(@myVar)]%%"] B --> Stop([End])

    Show answer details

    Correct answer: B

    The v() function is the correct and most common method for outputting the value of an AMPscript variable. It is a shortcut for printing the variable's content to the page, making it ideal for quick debugging checks.

  6. 6

    A financial services company needs to generate a highly personalized email containing a complex data table built from three different data extensions: Customers, Accounts, and Transactions. Due to performance concerns with nested LookupRows calls within a FOR loop during the send context, an architect has recommended pre-processing the data. The goal is to aggregate transaction data into a single JSON object and store it in a staging Data Extension before the send.

    Show answer details

    Correct answer: A

    This approach represents a best practice by separating the heavy data processing from the presentation layer. SSJS is more powerful and better suited for complex data manipulation, array handling, and JSON creation in a Script Activity. This pre-processing step ensures that the email rendering context only needs to perform a simple lookup and use the efficient BuildRowsetFromJSON function, leading to faster send times and avoiding timeouts.

  7. 7

    A retail company's e-commerce platform needs to trigger a transactional 'Order Confirmation' email immediately after a purchase. The development team is deciding between the SOAP API's TriggeredSend object and the REST API's Transactional Messaging endpoint (/messaging/v1/email/messages/). The payload contains customer details, order line items, and a unique promotional code for their next purchase.

    Show answer details

    Correct answer: B

    The REST Transactional Messaging API is the correct choice. It is designed for high-priority, non-promotional messages like order confirmations and password resets. It uses separate infrastructure from the bulk marketing send queues to ensure the lowest possible latency and highest delivery speed.

  8. 8

    A marketing team at a large university uses a SQL Query Activity to segment students for a new scholarship announcement. The query joins the Student_Master DE (containing StudentID, GPA, Major) with the Course_Enrollment DE (containing StudentID, CourseCode). The goal is to find all students with a GPA over 3.5 who are enrolled in any 'CS' prefixed course. The query is timing out.

    Query Snippet:

    SELECT
s.StudentID,
s.GPA,
s.Major
FROM
Student_Master s
INNER JOIN
Course_Enrollment c ON s.StudentID = c.StudentID
WHERE
s.GPA > 3.5 AND c.CourseCode LIKE 'CS%'

    Assuming StudentID is the primary key on Student_Master and a sendable relationship exists, what is the most effective optimization to prevent the query from timing out?

    Show answer details

    Correct answer: C

    This is the most effective solution. The query is filtering on GPA and CourseCode. Adding indexes to these columns allows the database engine to quickly find the matching rows without performing a full table scan, which is the most common cause of timeouts in queries like this.

  9. 9

    True or False: When a contact is deleted from Contact Builder through the official Contact Delete process, their corresponding records in all Sendable Data Extensions are automatically removed, but records in Non-sendable Data Extensions remain untouched.

    Show answer details

    Correct answer: A

    This statement is true. The Contact Delete process targets the contact record and its associated data in sendable contexts to comply with privacy regulations like GDPR. Non-sendable data extensions, which are often used for relational data, logging, or analytics, are not part of the automated deletion cascade.

  10. 10

    A developer is building a CloudPage that functions as a custom preference center. The page needs to retrieve a subscriber's current preferences from a Data Extension named Preferences_DE upon loading, and then update them when the subscriber submits a form. The form submission is handled by the same CloudPage.

    Show answer details

    Correct answer: B, C

    This function is essential for retrieving values from the form submission. It reads the data passed in the HTTP request (either from the query string or the form body), which is necessary to know what the subscriber's new preferences are.

    This function (or its counterpart, UpsertData) is essential for persisting the changes. After retrieving the new preferences from the form using RequestParameter(), UpdateData() is used to write those new values to the correct row in the Preferences_DE.

Create an account to continue.

Create accountSign in

Keep going

Related exams