MCE-Dev-201 Marketing Cloud Engagement Developer Practice Questions
Prepare for MCE-Dev-201 with more than an answer.
- 1
A developer is writing a WSProxy script to retrieve all Automations that are currently in 'Error' status. Which property of the Automation object should be filtered on, and what is the integer value representing 'Error'?
Show answer details
Correct answer: B
In the Automation Object, the
Statusproperty indicates the current state. The integer value-1represents 'Error'. Other values include2(Ready),3(Running), etc. - 2
When using the REST API to insert data into a Data Extension asynchronously, which endpoint is recommended to handle high volumes of data without waiting for immediate write confirmation?
Show answer details
Correct answer: B
The
/data/v1/async/endpoints are specifically designed for high-throughput asynchronous operations. This endpoint queues the data for insertion, allowing the API to respond immediately with a request ID rather than blocking until the database commit is complete. - 3
A developer needs to ensure that a specific SQL Query Activity in Automation Studio does not overwrite existing records in the target Data Extension but adds new records and updates changed ones. Which Data Action should be selected in the Query Activity definition?
Show answer details
Correct answer: A
In Marketing Cloud SQL Activities, the 'Update' action functions as an UPSERT (Update if exists, Insert if new). 'Overwrite' clears the table first. 'Append' only adds new rows and fails on primary key violations.
- 4
A developer is tasked with retrieving specific subscriber details from a Data Extension named 'LoyaltyMembers' for an email send. The email must display the member's tier status. If the subscriber is not found in the 'LoyaltyMembers' Data Extension, the email should default the tier to 'Bronze'. Which AMPscript function provides the most efficient way to achieve this lookup while handling the default value inline?
Show answer details
Correct answer: B
The Lookup() function is designed to return a specific field value from a Data Extension. To handle the default 'Bronze' value efficiently, the developer can wrap the Lookup() function in a conditional statement or use the AttributeValue() function in conjunction with an inline check. However, compared to LookupOrderedRows (which returns a rowset), Lookup returns the specific scalar value directly, which is more performant for single-value retrieval. The default logic is typically handled as: SET @tier = Lookup(...) IF EMPTY(@tier) THEN SET @tier = 'Bronze' ENDIF.
- 5
A solution architect is designing a custom Journey Builder activity that requires authentication with an external vendor's API. The vendor uses a standard OAuth 2.0 flow. The Custom Activity's
config.jsonmust be configured to handle the security arguments. Which property in theconfig.jsonfile is used to specify that Marketing Cloud should sign the payload using a specific key when calling the activity's execute endpoint?Show answer details
Correct answer: D
In the
config.jsonfile for a Custom Activity, thearguments.execute.useJwtproperty is set totrueto instruct Journey Builder to wrap the payload in a JSON Web Token (JWT). This JWT is signed using the application signature secret, allowing the external endpoint to verify the request originated from Marketing Cloud. - 6
A developer needs to write a SQL Query Activity to identify subscribers who have bounced more than 3 times in the last 30 days. The query should join the
_Subscribersdata view with the_Bouncedata view. Which JOIN type is most appropriate to ensure only subscribers who exist in the_Bounceview are retrieved?Show answer details
Correct answer: A
An INNER JOIN is the correct choice because the developer only wants records that have matching entries in both tables. This ensures that only subscribers who actually have bounce records are selected. A LEFT JOIN would return all subscribers regardless of bounce history.
