• Cert++
  • Practice
  • Certle
  • Review
  • Tracks
  • Checklist
  • Guides
  • Upgrade
Cert++
  1. Home
  3. Marketing Cloud Engagement Developer

Marketing Cloud Engagement Developer

Checklist progress

0/109Learned

Marketing Cloud Engagement Developer

Study Checklist

  • Platform Administrator
  • Platform App Builder
  • Platform Foundations
  • Platform Developer
  • Platform Administrator II
  • Agentforce Sales Consultant
  • Agentforce Service Consultant
  • Platform Data Architect
  • Platform Development Lifecycle and Deployment Architect
  • Platform Identity and Access Management Architect
  • Platform Integration Architect
  • Platform Sharing and Visibility Architect
  • Heroku Architect
  • B2C Solution Architect
  • Experience Cloud Consultant
  • Agentforce Field Service and Operations Consultant
  • Agentforce Nonprofit Consultant
  • Data 360 Consultant
  • Omnistudio Consultant
  • CRM Analytics and Einstein Discovery Consultant
  • Platform User Experience Designer
  • Platform Strategy Designer
  • B2C Commerce Developer
  • JavaScript Developer
  • Omnistudio Developer
  • Platform Developer II
  • Marketing Cloud Engagement Administrator
  • Marketing Cloud Engagement Specialist
  • Marketing Cloud Engagement Consultant
  • Agentforce Sales Foundations
  • Business Analyst
  • Marketing Cloud Engagement Developer
  • Marketing Cloud Engagement Foundations
  • Agentforce Specialist
  • Agentforce Life Sciences Consultant
  • B2B Commerce Administrator AP
  • B2B Commerce Developer AP
  • Agentforce Consumer Goods AP
  • Agentforce Financial Services AP
  • Agentforce Health AP
  • Agentforce Manufacturing AP
  • MuleSoft Integration Foundations
  • MuleSoft Developer
  • MuleSoft Developer II
  • MuleSoft Platform Integration Architect
  • MuleSoft Platform Architect
  • Tableau Desktop Foundations
  • Tableau Data Analyst
  • Tableau Consultant
  • Tableau Server Administrator
  • Tableau Architect

Checklist progress

0/109Learned

  • What is the difference between a Contact and a Subscriber in Marketing Cloud's data model?
  • What are the two Contact models available in Marketing Cloud and how do they differ in terms of how contacts are identified and deduplicated?
  • In the Marketing Cloud Contact model, what is the role of the Contact Key and how does it map to a Subscriber Key?
  • When configuring the Enterprise 2.0 account model, which attribute uniquely identifies a contact across all business units?
  • How does Marketing Cloud handle a scenario where the same subscriber appears in multiple business units when using a shared Contact model?
  • What is the difference between a Standard data extension, a Sendable data extension, and a Testable data extension in Marketing Cloud?
  • What are the available field data types in a Marketing Cloud data extension?
  • What constraints apply to a Primary Key field in a data extension, and what happens when a record with a duplicate primary key is upserted?
  • A developer needs to store data that will be used to send emails to subscribers. Which data extension type must be configured, and which field must be designated as the Subscriber Key?
  • A marketer wants to track each subscriber's response to a send and query that data later. Which data extension type and configuration supports this requirement?
  • When is a Synchronized data extension used, and what is its source of data?
  • How does a shared data extension differ from a non-shared data extension in an Enterprise 2.0 account?
  • How do data extension retention settings work, and what are the available retention policy options?
  • Which data extension field type should be used for storing a date that will be used in AMPscript date functions?
  • What is the role of the Contact Builder attribute group in connecting data extensions to the Contact record?
  • In Contact Builder, what is the difference between a one-to-one and a one-to-many relationship when linking data extensions?
  • How is a data extension linked to a Contact Builder attribute group, and what field in the data extension must be designated as the linking key?
  • What does the Contact Delete process do to a contact record across all channels in Marketing Cloud?
  • What is the difference between suppressing a contact and deleting a contact in Marketing Cloud?
  • A developer is asked to delete a contact from Marketing Cloud using the REST API. What endpoint and method should be used?

Given a scenario, demonstrate knowledge of AMPscript and SSJS language syntax and functions.

0/32

  • What is the purpose of `%%[` and `]%%` vs. `%%= =%%` in AMPscript, and when should each be used?
  • What is the correct AMPscript syntax to declare and output a variable?
  • What is the correct AMPscript syntax to conditionally output content using `IF`, `ELSEIF`, and `ENDIF`?
  • What is the AMPscript `CASE` statement syntax, and how does it differ from a series of nested `IF` statements?
  • What does the AMPscript `IIF()` function do, and how is it used as an inline conditional?
  • What is the difference between the AMPscript functions `LookupRows()` and `LookupOrderedRows()`?
  • Given an AMPscript `FOR` loop that iterates over a `LookupRows()` result set, what function retrieves the value of a specific field from each row?
  • What does the AMPscript function `InsertData()` do, and how does it differ from `UpsertData()`?
  • What is the AMPscript function used to update a single record in a data extension, and what are its required parameters?
  • What does the AMPscript `DeleteData()` function do and what parameters does it accept?
  • What are the AMPscript string functions for trimming and converting case, and what are their correct signatures?
  • What are the AMPscript string functions for replacing and manipulating strings, and what are their correct signatures?
  • What does the AMPscript `Concat()` function do, and how is it used to build a dynamic URL with multiple parameters?
  • What is the correct syntax and argument order for the AMPscript `Substring()` function, and what does it return when the start index exceeds the string length?
  • What does the AMPscript `Now()` function return, and how does it differ from `SystemDateToLocalDate()`?
  • What is the correct syntax and purpose of the AMPscript `FormatDate()` function?
  • What is the correct syntax for the AMPscript `DateAdd()` function, and what unit strings are valid for the interval parameter?
  • What is the AMPscript `AttributeValue()` function and in what context is it typically used?
  • What is the AMPscript `RequestParameter()` function, and how is it used to retrieve query string or POST body parameters?
  • How does the `ContentBlockByID()` AMPscript function differ from `ContentBlockByKey()`?
  • What is the AMPscript function for URL-encoding a string, and why is it important to use it for query string parameters?
  • What is the purpose of the AMPscript `TreatAsContent()` function and when would a developer use it?
  • What does the AMPscript `RegExMatch()` function do, and in what scenario would a developer use it to validate subscriber data?
  • What is the AMPscript `BuildRowsetFromString()` function and when would a developer use it instead of `LookupRows()`?
  • What are the AMPscript `Base64Encode()` and `Base64Decode()` functions used for, and in what integration context would they commonly appear?
  • What is the purpose of `Platform.Load('Core', '1')` in SSJS, and what capabilities does loading the Core library unlock?
  • In SSJS, what object and method is used to write output to the rendered page?
  • How is data serialized and deserialized in SSJS?
  • In SSJS, how do you retrieve the value of a Marketing Cloud data extension record using the Platform object?
  • How do you use the SSJS `HTTP.Get()` and `HTTP.Post()` methods to call an external API from a Marketing Cloud CloudPage?
  • What does the AMPscript function `Lookup()` return when no matching record is found in a data extension?
  • What is the Marketing Cloud SSJS `DataExtension` object and how is it used to retrieve, insert, update, and delete rows?

Implement standard development best practices using Marketing Cloud programming languages.

0/9

What are Content Blocks and how should a developer use them to promote code reuse in Marketing Cloud emails and CloudPages?

Learn this concept
Unseen

What is the recommended approach for error handling in AMPscript using the `RaiseError()` function?

Learn this concept
Unseen

How should a developer use the AMPscript `IsNull()` and `Empty()` functions together to safely handle missing data extension field values?

Learn this concept
Unseen

A developer needs to prevent an email from being sent if a required field in the data extension is empty. What AMPscript technique achieves this at send time?

Learn this concept
Unseen

What is the difference between using AMPscript `LookupRows()` vs. a SQL Query Activity for aggregating data, and when is each approach preferred?

Learn this concept
Unseen

What is the maximum number of `LookupRows()` rows returned by default, and how can a developer retrieve more records?

Learn this concept
Unseen

What is the correct way to use AMPscript inside an HTML attribute value (e.g., a link href), and what common mistake causes the attribute to break?

Learn this concept
Unseen

When using SSJS on a CloudPage, what security practice should be applied to user-supplied input to prevent injection vulnerabilities?

Learn this concept
Unseen

Why should AMPscript variable declarations using `VAR` be placed at the top of a block, and what error can occur if a variable is referenced before declaration?

Learn this concept
Unseen

Describe how Marketing Cloud handles AMPscript processing.

0/7

  • In what order does Marketing Cloud process AMPscript during an email send: server-side vs. client-side rendering?
  • What is the difference between AMPscript processing in an email context versus a CloudPage context?
  • What is the scope of an AMPscript variable declared inside a `%%[ ]%%` block — is it accessible in subsequent blocks within the same email?
  • How does AMPscript handle data extension lookups during personalization at send time — are lookups done once per send or per subscriber?
  • What is the effect of a runtime AMPscript error on an email send when `RaiseError()` is called without specifying 'true' for the skipline parameter?
  • Can SSJS be embedded inline in email body content the same way AMPscript can? What is the correct context for using SSJS in Marketing Cloud?
  • When AMPscript is placed inside an HTML comment in an email, how does Marketing Cloud process it?

Given a customer scenario, determine how to programmatically exclude a subscriber at email send time.

0/4

  • How can a developer use an Exclusion Script in a send definition to programmatically exclude subscribers, and where is this script applied?
  • A developer needs to exclude any subscriber whose 'OptOutDate' field is not null from receiving an email. What AMPscript code achieves this?
  • A marketer wants to exclude subscribers who have made a purchase in the last 7 days. The purchase data is in a separate data extension. How would a developer implement this suppression using AMPscript?
  • What AMPscript function is used to programmatically suppress a specific email recipient at send time, and what is its correct syntax?
  • What is the difference between the SOAP API and REST API in Marketing Cloud in terms of supported operations, data formats, and use cases?
  • What is the base URL structure for the Marketing Cloud REST API, and how does the tenant-specific endpoint differ from the generic login endpoint?
  • What REST API endpoint and HTTP method are used to create a new data extension row in Marketing Cloud?
  • What is the REST API route for retrieving the rows of a data extension by external key, and what HTTP method is used?
  • How does the Marketing Cloud REST API handle pagination when a data extension has more rows than the default page size, and what parameters control pagination?
  • Which Marketing Cloud REST API endpoint is used to trigger a triggered send, and what are the required request body parameters?
  • What is the Marketing Cloud REST API endpoint for sending a transactional email message (`/messaging/v1/email/messages/`), and what payload fields are required?
  • What is the SOAP API `TriggeredSend` object and what properties are required to initiate a send to a subscriber?
  • What SOAP API action is used to send a transactional email to a single subscriber using a triggered send definition?
  • What REST API endpoint is used to start a Journey Builder journey for a specific contact, and what payload is required?
  • What Marketing Cloud REST API resource is used to retrieve email send tracking data (opens, clicks, bounces) for a job?
  • What is the REST API endpoint for retrieving the status of a background asynchronous task (such as a data extension import) in Marketing Cloud?
  • What is the `/contacts/v1/contacts` REST API endpoint used for, and what HTTP methods does it support?
  • What is the `/data/v1/async/dataextensions` REST API endpoint used for?
  • How does a developer check the status of an asynchronous operation submitted to the `/data/v1/async/dataextensions` endpoint?
  • A developer wants to delete a data extension row via the REST API using a key. What endpoint and HTTP method should be used?
  • What is the OAuth 2.0 client credentials flow in Marketing Cloud, and what endpoint is used to request an access token?
  • What parameters are required in the POST body to obtain an access token from the Marketing Cloud authentication endpoint?
  • How is a Marketing Cloud access token included in a REST API request header?
  • How is an access token passed in a SOAP API request, and in which SOAP envelope element does it appear?
  • What is the token expiration behavior for Marketing Cloud access tokens?
  • What is the exact expiration duration of a Marketing Cloud OAuth access token?
  • How should a developer handle Marketing Cloud access token refresh when a token expires?
  • What HTTP status code is returned when a Marketing Cloud REST API request is made with an expired token?
  • In a Marketing Cloud Connected App, what is the purpose of the scope parameter when requesting an access token?
  • What is the difference between using a client ID/secret for server-to-server integration versus the authorization code grant flow in Marketing Cloud?
  • Which Marketing Cloud OAuth scopes are required to send emails via the REST API?
  • What HTTP status code indicates a successful API response when creating a new resource via POST in Marketing Cloud's REST API?
  • A REST API call to insert a data extension row returns a 400 status code. What does this indicate, and how should the developer investigate the error?
  • How should a developer handle a 401 Unauthorized response from the Marketing Cloud REST API?
  • In the SOAP API, where are fault codes and error messages returned in the response, and what SOAP element contains them?
  • A developer calls the Marketing Cloud REST API to start a Journey entry and receives a 202 Accepted response. What does this mean about the processing status of the request?
  • What does the Marketing Cloud REST API return in the response body when a data extension upsert partially succeeds (some rows fail)?
  • What file formats are supported by the Marketing Cloud Import Activity, and what are the delimiter options?
  • What are the three import types available in a Marketing Cloud Import Activity (Add and update, Add only, Update only), and when would a developer use each?
  • What does the 'Overwrite' import type do to existing records in a data extension compared to 'Add and Update'?
  • When configuring an Import Activity to map columns from a CSV file to a data extension, what options are available for handling column-to-field mapping?

Prepare for the Exam

Play Today's Certle
Back to track

Study Community

Ask questions and get the latest info from other Marketing Cloud Engagement Developer studiers.

Go to Discord

What is the difference between using AMPscript `LookupRows()` vs. a SQL Query Activity for aggregating data, and when is each approach preferred?

Explainer

Learn More

Practice Question

Keep going

Next conceptWhat is the maximum number of `LookupRows()` rows returned by default, and how can a developer retrieve more records?

Checklist progress

0/109 (0%)

0 of 109 concepts learned

Tip: You can filter concepts by status.

Prepare for the Exam

Play Today's Certle
Back to track

Study Community

Ask questions and get the latest info from other Marketing Cloud Engagement Developer studiers.

Go to Discord

Explainer

AMPscript's LookupRows() function retrieves specific rows from a data extension with a 2,000-row maximum, while SQL Query Activities query data extensions and data views for broader data operations. Each approach serves different purposes based on data volume, performance needs, and the type of data being accessed.

Core information
  • LookupRows() returns an unordered rowset from a data extension with up to 2,000 rows maximum
More details and nuances
  • Data extensions with ongoing information like click data tend to grow and can slow down queries, making staging table approaches preferable for performance